BSDGSYS: SQL Server Advance 101

What does SQL stand for?

• Structured Query Language

• Structural Query Language

• Strong Question Language

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

• Extract

• Get

• Select

• Open

Which SQL statement is used to delete database?

• Drop

• Delete

• Remove

• Renew

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

• Order

• Sort By

• Order By

• Group By

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

• SELECT COLUMNS(*) FROM Persons

• SELECT LEN(*) FROM Persons

• SELECT NO(*) FROM Persons

• SELECT COUNT(*) FROM Persons

Which SQL statement is used to create a table in a database?

• CREATE DATABASE TAB

• CREATE DB

• CREATE TABLE

• CREATE DATABASE TABLE

With SQL, how can you insert "Olsen" as the "LastName" in the "Persons" table?

Next ❯

• INSERT INTO Persons (LastName) VALUES ('Olsen')

• INSERT ('Olsen') INTO Persons (LastName)

• INSERT INTO Persons ('Olsen') INTO LastName

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

• SELECT * FROM Persons ORDER FirstName DESC

• SELECT * FROM Persons SORT BY 'FirstName' DESC

• SELECT * FROM Persons SORT 'FirstName' DESC

• SELECT * FROM Persons ORDER BY FirstName DESC

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

• SELECT [all] FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName='Peter'

• SELECT * FROM Persons WHERE FirstName<>'Peter'

• SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

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

• SELECT Persons

• SELECT [all] FROM Persons

• SELECT * FROM Persons

• SELECT *.Persons