Question 1

What does SQL stand for?

technology databases

Structured Query Language
Strong Question Language
Structured Question Language
none of above

Answer

Correct Option: A

Question 2

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

technology databases

OPEN
GET
SELECT
EXTRACT

Answer

Correct Option: C

Question 3

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

technology databases

DELETE
COLLAPSE
REMOVE
None

Answer

Correct Option: A

Question 4

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

technology databases

OPEN
GET
SELECT
EXTRACT

Answer

Correct Option: C

Question 5

Which SQL statement is used to update data in a database?

technology databases

SAVE
SAVE AS
MODIFY
UPDATE

Answer

Correct Option: D

Question 6

Which SQL statement is used to insert new data in a database?

technology databases

INSERT NEW
ADD RECORD
ADD NEW
INSERT INTO

Answer

Correct Option: D

Question 7

With SQL, how do you select all the columns from a table named "Persons"?

technology databases

SELECT Persons
SELECT *.Persons
SELECT * FROM Persons
SELECT [all] FROM Persons

Answer

Correct Option: C

Question 8

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

technology databases

SELECT * FROM Persons WHERE FirstName<>'Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT * FROM Persons WHERE FirstName='Peter'
SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

Answer

Correct Option: C

Question 9

What does SQL stand for?

technology databases

Structured Query Language
Strong Question Language
Structured Question Language
None

Answer

Correct Option: A

Question 10

With SQL, how do you select a column named "FirstName" from a table named "Persons"?

technology databases

SELECT Persons.FirstName
SELECT FirstName FROM Persons
EXTRACT FirstName FROM Persons
None

Answer

Correct Option: B

Question 11

Can Primary Key be Null?

technology databases

True
False

Answer

Correct Option: B

Question 12

Can Sec Key be Null?

technology databases

True
False

Answer

Correct Option: B

Question 13

Can Composite Key be Null?

technology databases

True
False

Answer

Correct Option: B

Question 14

OBject Relational Database have entity relations?

technology databases

True
False

Answer

Correct Option: B

Question 15

Is DB2 database managament system?

technology databases

True
False

Answer

Correct Option: A

Question 16

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

technology databases

SORT BY
SORT
ORDER
ORDER BY

Answer

Correct Option: D

Question 17

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

technology databases

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

Answer

Correct Option: D

Question 18

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

technology databases

SELECT COUNT(*) FROM Persons
SELECT COLUMNS(*) FROM Persons
SELECT COLUMNS() FROM Persons
SELECT COUNT() FROM Persons

Answer

Correct Option: A

Question 19

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

technology databases

SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
SELECT * FROM Persons WHERE FirstName<>'Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT * FROM Persons WHERE FirstName='Peter'

Answer

Correct Option: D

Question 20

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

technology databases

SELECT * FROM Persons WHERE FirstName LIKE '%a'
SELECT * FROM Persons WHERE FirstName='%a%'
SELECT * FROM Persons WHERE FirstName='a'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'

Answer

Correct Option: D

Description: databases Online Quiz - 218
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 218

Find more quizzes from top tags