Slq Quiz

TEST YOUR SQL SKILLS START STUDYIN OR ELSE KT MUBARAK ? YOU LL SCORE GREAT IN DBMS PAPER ? YOU WILL SCORE 100 IN DBMS PAPER :p ?

开始分享

Slq Quiz

1. What does SQL stand for?

题 1 out of 8

Strong Question Language Structured Query Language Structured Question Language

Slq Quiz

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

题 2 out of 8

GET OPEN SELECT

Slq Quiz

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

题 3 out of 8

MODIFY SAVE UPDATE

Slq Quiz

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

题 4 out of 8

ADD RECORD INSERT INTO INSERT NEW

Slq Quiz

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

题 5 out of 8

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

Slq Quiz

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

题 6 out of 8

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

Slq Quiz

7. 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"?

题 7 out of 8

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

Slq Quiz

8. With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?

题 8 out of 8

SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen' SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen' SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

由Dixie.West15创建

创建自己的测验

Online People - 约会、聊天和结识新朋友

建议测验

更多测验

建议民意调查

更多民意调查

推荐应用

更多应用程序