SOLVED

1) Which of the following is a purpose of the SQL standard? A) To specify syntax and semantics of SQL data definition and manipulation B) To specify minimal and complete standards, which permit different degrees of adoption in products C) To define the data structures and basic operations for SQL databases D) All of the above 2) The benefits of a standardized relational language include: A) application longevity. B) reduced training costs. C) cross-system communication. D) all of the above. 3) The ________ is the structure that contains descriptions of objects such as tables and views created by users. A) SQL B) schema C) catalog D) master view 4) ________ is a set of commands used to control a database, which includes security. A) DML B) DDL C) DCL D) DPL 5) ________ is a set of commands used to update and query a database. A) DML B) DDL C) DCL D) DPL 6) DDL is typically used during which phases of the development process? A) Implementation B) Physical design C) Analysis D) All of the above 7) The command for creating a database is: A) create table. B) create view. C) create schema. D) create authorization. 8) The SQL command ________ defines a logical table from one or more tables or views. A) create table B) alter table C) create view D) create relationship 9) Any create command may be reversed by using a ________ command. A) truncate B) drop C) delete D) unpack 10) The first in a series of steps to follow when creating a table is to: A) identify columns that must be unique. B) identify each attribute and its characteristics. C) create an index. D) identify columns that must be null.