- Study guides, Revision notes & Summaries

MySQL FINAL EXAM STUDY GUIDE QUESTIONS WITH COMPLETE SOLUTIONS

MySQL Exam Questions with Correct Answers A SELECT statement that includes aggregate functions is often called a/an ____________ query. - Answer-Summary All of the aggregate functions ignore null values, except for the _________ function. - Answer-COUNT By default, all duplicate values are included in the aggregate calculation, unless you specify the ______________ keyword - Answer-DISTINCT Write an aggregate expression for the number of entries in the vendor_name column - Answer-SELE...

AS - Answer- The CREATE VIEW command includes the words CREATE VIEW, followed by the name of the view, ____ and then a query. UPDATE - Answer- To change rows for which a specific condition is true, use the ___command. DROP TABLE LEVEL1_CUSTOMER - Answer- Which of the following is a valid SQL Command? CREAT UNIQUE INDEX - Answer- To ensure the uniqueness of values in a non-primary key column, you can create a unique index by using the _____________ command. GRANT - Answer- The main me...

SELECT - Answer- You can use the AS keyword with the CREATE TABLE statement to create a copy of a table from a ____________________ statement. SELECT DELETE WHERE LIKE DELETE - Answer- By default, MySQL automatically commits changes to the database immediately after each INSERT, UPDATE, and ______________ statement that you issue. ON DELETE AS COMMIT null - Answer- When you code a column list in an INSERT statement, you can omit columns with default values and col...