Pretest DBMS

Pick which ARE the entities from the following:

• a) vendor

• b) student

• c) attends

• d) km/hour

Select which ARE the DBMS software

• 
• 
• 
• 

Which attribute is the KEY IDENTIFIER or the PRIMARY KEY?

• EmpID

• Degree

• Name

• Birthday

The__________ operator

returns true or false

• string

• logical

• unknown

• list

On a table, which has one or more columns with values that are unique within the table and thus can be used to identify the rows of the table?

• Row

• Column

• Domain

• Primary Key

The descriptive property possessed by each entity set is _________

• a) Entity

• b) Attribute

• c) Relation

• d) Model

Drop table statement

• deletes the table structure only

• deletes the table structure along with the table data

• works whether or not referential integrity constraints would be violated

• is not an SQL statement

The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________

• TCL (Transaction Control Language)

• DCL (Data Control Language)

• DDL (Data Definition Langauge)

• DML (Data Manipulation Langauge

In the __________ normal form, a composite attribute is converted to individual attributes

• First Normal Form

• Second Normal Form

• Third Normal Form

• Fourth Normal Form

  To which of the following the term "DBA" referred?

•   Data Bank Administrator

•   Database Administrator

•   Data Administrator

•   None of the above