CIS 458-

5) ________ is a set of commands used to update and query a database. A) DML B) DDL C) DCL D) DPL

A

13) INSERT INTO is an example of ________ code. A) DDL B) DML C) DCL D) DNL

B

17) A primary key that consists of more than one attribute is called a: A) foreign key. B) composite key. C) multivalued key. D) cardinal key.

B

2) ________ are established between entities in a well-structured database so that the desired information can be retrieved. A) Entities B) Relationships C) Lines D) Ties

B

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

B

6) DDL is typically used during which phase of the development process? A) Implementation B) Physical design C) Analysis D) Evaluation

B

7) Any create command may be reversed by using a(n) ________ command. A) undo B) drop C) delete D) unpack

B

8) The SQL command ________ adds one or more new columns to a table. A) create table B) alter table C) create view D) create relationship

B

12) Referential Integrity Constraints are generally established between: A) Referential and Integrity keys. B) Primary and Secondary keys. C) Primary and Foreign keys. D) Foreign and Domestic keys.

C

15) An attribute (or attributes) that uniquely identifies each row in a relation is called a: A) column. B) foreign field. C) primary key. D) duplicate key.

C

16) An attribute in a relation of a database that serves as the primary key of another relation in the same database is called a: A) link attribute. B) link key. C) foreign key. D) foreign attribute.

C

4) ________ is a set of commands used to control a database, including security. A) DML B) DDL C) DCL D) TCL

C

28) The DROP command deletes rows from a table individually or in groups.

FALSE

30) RDBMS stands for Related Data Build Management System.

FALSE

1) A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly

A

11) What does the following SQL command do? insert into Customer values (001,'John Smith','231 West St','Boston','MA','02115'); A) Adds a new record to the Customer B) Creates the Customer table C) Deletes the Customer table D) Updates the Customer table

A

10) What does the following SQL statement do? Alter Table Customer Add Type (varchar2 (10)); A) Alters the Customer table to accept Type Varchar2 B) Alters the Customer table to be a Type 2 Varchar C) Alters the Customer table, and adds a field called "Type" D) Alters the Customer table by adding a 2-byte field called "Varchar"

C

14) In an SQL statement, which of the following parts states the conditions for row selection? A) Select B) From C) Where D) Group By

C

18) A ________ defines or constrains some aspect of the business. A) Business constraint B) Business structure C) Business control D) Business rule

D

9) How to make changes permanent after manipulating a table? A) Rollback B) Update C) Delete D) Commit;

D

19) DCL is used to update the database with new records.

FALSE

21) A database is maintained and queried using the data mapping language (DML).

FALSE

22) The CREATE SCHEMA DDL command is used to create a table.

FALSE

24) In databases, null values are equivalent to zero.

FALSE

25) The DELETE TABLE DDL command is used to remove a table from the database.

FALSE

27) The following insert command would work fine: insert into budget values 121,222,111;

FALSE

20) A database table is defined using the data definition language (DDL).

TRUE

23) SQL is a standard language for database access.

TRUE

26) The SQL command used to populate tables is the INSERT command.

TRUE

29) The asterisk (*) wildcard designator can be used to select all fields from a table as well as in WHERE clauses when an exact match is not possible.

TRUE