0

databases Online Quiz - 243

Description: databases Online Quiz - 243
Number of Questions: 22
Created by:
Tags: databases
Attempted 0/22 Correct 0 Score 0
  1. INSERT NEW

  2. ADD NEW

  3. ADD RECORD

  4. INSERT INTO


Correct Option: D
  1. SELECT FirstName FROM Persons

  2. EXTRACT FirstName FROM Persons

  3. SELECT Persons.FirstName

  4. SELECT * FROM Persons


Correct Option: A
  1. SELECT [all] FROM Persons

  2. SELECT * FROM Persons

  3. SELECT *.Persons

  4. SELECT Persons


Correct Option: B
  1. SELECT * FROM Persons WHERE FirstName <> 'Peter'

  2. SELECT [all] FROM Persons WHERE FirstName='Peter'

  3. SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

  4. SELECT * FROM Persons WHERE FirstName='Peter'


Correct Option: D
  1. SELECT * FROM Persons WHERE FirstName LIKE 'a%'

  2. SELECT * FROM Persons WHERE FirstName LIKE '%a'

  3. SELECT * FROM Persons WHERE FirstName='a'

  4. SELECT * FROM Persons WHERE FirstName='%a%'


Correct Option: A
  1. SELECT DISTINCT

  2. SELECT DIFFERENT

  3. SELECT UNIQUE

  4. SELECT ALL


Correct Option: A
  1. SELECT * FROM Persons ORDER FirstName DESC

  2. SELECT * FROM Persons ORDER BY FirstName DESC

  3. SELECT * FROM Persons SORT BY 'FirstName' DESC

  4. SELECT * FROM Persons SORT 'FirstName' DESC


Correct Option: B
  1. Primary key access

  2. Full table scan

  3. Access via unique index

  4. Table access by ROWID

  5. None of the above


Correct Option: A
  1. By value

  2. By reference

  3. By type

  4. none of the above


Correct Option: A
  1. Real abstarct clustersl

  2. Real application cursors

  3. Real application clusters

  4. none of the above


Correct Option: A
  1. Primary key access

  2. Full table scan

  3. Access via unique index

  4. Table access by ROWID


Correct Option: D
- Hide questions