MySQL EXAM Q&A

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 mechanism for providing access to a dataset is the _____ command. Primary Key - Answer- A view is updatable when it derived from joining two base tables on the ___ of each table. Parentheses - Answer- When renaming columns, you include the new column names in __ following the name of the view. DROP TABLE - Answer- You can use the _____ command to delete an entire table and its data. Query - Answer- A view is defined by creating a defining __________, which indicates the rows and columns to inclue in the view. Database Administrator - Answer- in a business organization, a person or an entire group known as the ___ is charged with managing the database. DROP VIEW - Answer- The command to delete a view is DROP VIEW. Transaction - Answer- A _____ can be viewed as a sequence of steps that accomplishes a single task. DELETE - Answer- The correct command to allow user Thompson to delete rows in the CUSTOM