Maersk - SQL

  Structured Query Language

1.   With SQL, how can you insert “Olsen” as the “LastName” in the “Persons” table?

o  INSERT INTO Persons (LastName) VALUES (‘Olsen’)

o  INSERT (‘Olsen’) INTO Persons (LastName)

o  All of the mentioned options

o  INSERT INTO Persons (‘Olsen’) INTO LastName

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

o  Update

o  Modify

o  Save as

o  Save

3.   With SQL how can you insert a new record into the “Persons” table?

o  None of the mentioned options

o  INSERT (‘Jimmy’, ’Jackson’) INTO Persons

o  INSERT INTO Persons VALUES (‘Jimmy’, ’Jackson’)

o  INSERT VALUES (‘Jimmy’, ’Jackson’) INTO Persons

4.   Which SQL statement is used to return only unique values?

o  None of the mentioned options

o  Select Distinct

o  Select Different

o  Select Unique

5.   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”?

o  All of the mentioned options

o  SELECT LastName>’Hansen’ AND LastName<’Pettersen’ FROM Persons

o  SELECT * FROM Persons Where LastName BETWEEN ‘Hansen’ AND ‘Pettersen’

o  SELECT * FROM Persons WHERE LastName>’Hansen’ AND LastName<’Pettersen’

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

o  Clear

o  Truncate

o  Delete

o  Collapse

7.   With SQL, how do you select a column named “FirstName” from a table named “Persons” having many columns?

o  Select FirstName frm Persons

o  Select Persons.FirstName

o  Extract FirstName From Persons

o  Select * from Persons