SQL Basic Quiz – 1 March 1, 2019 admin Leave a comment Welcome to your SQL Basic Quiz - 1. One of the best ways to test your knowledge of SQL is by taking this SQL Quiz. The test requires moderate knowledge of the database language and will allow you to see how well you understand certain areas of SQL and areas that you need to improve. The SQL language used is MySQL. Name E-Mail 1. What does SQL stand for? Structured Query Language Structured Question Language Strong Query Language Strong Question Language None of the Above 2. Data Definition Language is used to define the structure of the database. Select True or False. True False 3. Select Data Definition Language constructs CREATE TABLE INSERT INTO ADD COLUMN UPDATE 4. What type of query removes information from a database table? REMOVE DELETE COLLAPSE ELIMINATE 5. Which SQL statement is used to insert new data into a table? INSERT NEW INSERT INTO ADD ADD RECORD ADD INTO 6. Select the SQL statement used to update data in a table? SAVE SAVE AS MODIFY UPDATE PUT 7. Which SQL statement is used to get data from a table? SELECT GET FETCH EXTRACT RETRIEVE 8. How do you select a column "address" from a table "AddressBook"? SELECT [address] from AddressBook SELECT address of AddressBook SELECT address from AddressBook SELECT address in AddressBook 9. How do you select all the columns from a table "AddressBook"? SELECT all from AddressBook SELECT * from AddressBook SELECT [everything] from AddressBook SHOW AddressBook 10. Choose the keyword you would use to add conditions to your query? WHEN WHAT WHERE EQUALS CONDITION 11. How do you insert a new record into the "Employee" table with columns Name, Employee_ID, Department? INSERT VALUES ('Peter', '1001', 'IT') INTO Employee INSERT INTO Employee VALUES 'Peter', '1001', 'IT' INSERT INTO Employee VALUES ('Peter', '1001', 'IT') INSERT INTO Employee ('Peter', '1001', 'IT') Post navigation BigData → Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Save my name, email, and website in this browser for the next time I comment.