0

databases Online Quiz - 218

Description: databases Online Quiz - 218
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. Structured Query Language

  2. Strong Question Language

  3. Structured Question Language

  4. none of above


Correct Option: A

Which SQL statement is used to extract data from a database?

  1. OPEN

  2. GET

  3. SELECT

  4. EXTRACT


Correct Option: C

Which SQL statement is used to extract data from a database?

  1. OPEN

  2. GET

  3. SELECT

  4. EXTRACT


Correct Option: C
  1. Which SQL statement is used to update data in a database?
  1. SAVE

  2. SAVE AS

  3. MODIFY

  4. UPDATE


Correct Option: D
  1. Which SQL statement is used to insert new data in a database?
  1. INSERT NEW

  2. ADD RECORD

  3. ADD NEW

  4. INSERT INTO


Correct Option: D
  1. With SQL, how do you select all the columns from a table named "Persons"?
  1. SELECT Persons

  2. SELECT *.Persons

  3. SELECT * FROM Persons

  4. SELECT [all] FROM Persons


Correct Option: C
  1. With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?
  1. SELECT * FROM Persons WHERE FirstName<>'Peter'

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

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

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


Correct Option: C
  1. Structured Query Language

  2. Strong Question Language

  3. Structured Question Language

  4. None


Correct Option: A
  1. SELECT Persons.FirstName

  2. SELECT FirstName FROM Persons

  3. EXTRACT FirstName FROM Persons

  4. None


Correct Option: B

Can Composite Key be Null?

  1. True

  2. False


Correct Option: B

Is DB2 database managament system?

  1. True

  2. False


Correct Option: A

Which SQL keyword is used to sort the result-set?

  1. SORT BY

  2. SORT

  3. ORDER

  4. ORDER BY


Correct Option: D

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

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

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

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

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


Correct Option: D

With SQL, how can you return the number of records in the "Persons" table?

  1. SELECT COUNT(*) FROM Persons

  2. SELECT COLUMNS(*) FROM Persons

  3. SELECT COLUMNS() FROM Persons

  4. SELECT COUNT() FROM Persons


Correct Option: A

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

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

  2. SELECT * FROM Persons WHERE FirstName<>'Peter'

  3. SELECT [all] FROM Persons WHERE FirstName='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='%a%'

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

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


Correct Option: D
- Hide questions