databases Online Quiz - 13

Description: databases Online Quiz - 13
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

With SQL, how can you insert a new record into the "Persons" table?

  1. INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

  2. INSERT ('Jimmy', 'Jackson') INTO Persons

  3. INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

  4. INSERT ('Jimmy', 'Jackson') INTO Persons

Correct Option: A
  1. INSERT ('Olsen') INTO Persons (LastName)

  2. INSERT INTO Persons (LastName) VALUES ('Olsen')

  3. INSERT INTO Persons ('Olsen') INTO LastName

  4. INSERT FROM Persons ('Olsen') INTO LastName

Correct Option: B
  1. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

  2. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

  3. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

  4. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Correct Option: B
  1. DELETE FROM Persons WHERE FirstName = 'Peter'

  2. DELETE FirstName='Peter' FROM Persons

  3. DELETE ROW FirstName='Peter' FROM Persons

  4. DELETE FROM Persons WHERE FirstName <> 'Peter'

Correct Option: A
  1. SELECT COUNT() FROM Persons



  4. SELECT COUNT(*) FROM Persons

Correct Option: D

Select statement in Sybase can include columns not specified in the GROUP BY clause

  1. True

  2. False

Correct Option: A
  1. SQL Developer

  2. SQLWays

  3. Both a and b

  4. Only a

Correct Option: C
  1. MYSQL

  2. SQL Server

  3. DB2

  4. Oracle

  5. All of the above/ Any database suggested by client

Correct Option: B,D
  1. A procedure that is very small

  2. A procedure being invoked by another procedure

  3. A procedure that is not used by application

  4. System stored procedures

Correct Option: B
  1. timestamp

  2. varchar

  3. datetime

  4. number

  5. raw

Correct Option: C
  1. inserted

  2. updated

  3. deleted

  4. created

Correct Option: A,C
  1. Database Buffer Cache

  2. Shared Pool

  3. Data Dictionary

  4. Redolog Group

  5. Redolog Buffer

Correct Option: A,B,E

Identify the physical components of the database. Choose all that apply

  1. Database

  2. Controlfile

  3. Table

  4. Datafile

  5. Index

  6. Redolog Group

Correct Option: B,D,F
- Hide questions