80s Gold.com (Memories) Pop Music and Tech Quiz

Total Questions in Database = 25 : Please wait while randomising 10 New Questions

#0 - 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 COUNT() FROM Persons
4. SELECT COLUMNS(*) FROM Persons


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

1. OPEN
2. GET
3. EXTRACT
4. SELECT


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

1. UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
2. UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
3. MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
4. MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'


#3 - 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


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

1. DELETE
2. COLLAPSE
3. REMOVE


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

1. SELECT * FROM Persons SORT 'FirstName' DESC
2. SELECT * FROM Persons ORDER FirstName DESC
3. SELECT * FROM Persons SORT BY 'FirstName' DESC
4. SELECT * FROM Persons ORDER BY FirstName DESC


#6 - With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?

1. DELETE ROW FirstName='Peter' FROM Persons
2. DELETE FROM Persons WHERE FirstName = 'Peter'
3. DELETE FirstName='Peter' FROM Persons


#7 - In SQL how do you place a value 'Alan' and 'Andy' into 'users'?

1. MOVE 'Alan,Andy' TO 'users'
2. INSERT VALUES ('Alan','Andy') INTO 'users'
3. INSERT INTO 'users' VALUES ('Alan','Andy)
4. FPUT users [Alan;Andy]
5. INSERT ('Alan' + 'Andy') TO users


#8 - What does SQL stand for?

1. Structured Question Language
2. Structured Query Language
3. Strong Question Language


#9 - 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"?

1. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName<'Pettersen'
2. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
3. SELECT LastName>'Hansen' AND LastName<'Pettersen' FROM Persons

        
The next time you visit this page, there will another 10 random questions

Submit your own question and up to 5 answers for inclusion on this website HERE