Reference no: EM13477373

Question 1

A candidate key is:

required to be unique.
used to represent rows in relationships.
a candidate to be the primary key.
Both required to be unique and used to represent rows in relationships
Both required to be unique and a candidate to be the primary key

 

Question 2

A database is a set of one or more computer programs that serves as an intermediary between the users and the database management system (DBMS).

Question 3

A database is self-describing because the user maintains a record of the database structure outside the database itself.

True

False

Question 4

A database may be used to help people:

track which student is assigned to a particular advisor.
know the current inventory levels of products their company sells.
check on the estimated arrival time of an incoming ?ight at an airport.
look up their checking account balance over the Internet.
All of these

Question 5

A composite primary key can be de?ned using the CONSTRAINT phrase in which SQL command?

MODIFY TABLE
CHANGE TABLE
CREATE TABLE
SET TABLE
BUILD TABLE

Question 6

A primary key is:

required to be unique.
used to represent rows in relationships.
a candidate key.
used to identify unique rows.
All of these

Question 7

A relational database is:
a self-describing collection of related tables.
a collection of forms and reports that support a given purpose.
a library of queries and data ?les for querying.
a set of applications and the data sets for those applications.
a set of metadata.

Question 8

A relational database stores data in the form of:
lists.
forms.

columns.
tables.
spreadsheets.

Question 9

A surrogate key may be appropriate under which of the following circumstances?

The available candidate keys would produce a lot of data duplication when representing relationships.

The primary key is numeric.
The available candidate keys would be prone to typographical errors.
The available candidate keys have little meaning to the users.
Both The available candidate keys would produce a lot of data duplication when representing relationships and The available candidate keys would be prone to typographical errors

Question 10

During the normalization process, the remedy for a relation that is not well formed is to:
create a surrogate key.
create a functional dependency.
break it into two or more relations that are well formed.
combine it with another relation that is well formed.
convert it into a list.

Question 11

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to add new student data to the STUDENT table?

INSERT DATA STUDENT SET StudentID=123, Name='Jones', Advisor='Smith';
INSERT INTO STUDENT VALUES (123, 'Jones', 'Smith');
INSERT INTO STUDENT (New Student Data) VALUES (123, 'Jones', 'Smith');
INPUT DATA STUDENT SET StudentID=123, Name=' Jones', Advisor='Smith';
INPUT INTO STUDENT (123, 'Jones', 'Smith');

Question 12

Given the table STUDENT(StudentID, Name, Advisor), which of the following SQL statements would be used to change the value of the Advisor ?eld to 'Smith' for all rows in the STUDENT table?

UPDATE STUDENT SET Advisor = 'Smith';
MODIFY STUDENT SET Advisor = 'Smith';
MODIFY Advisor SET STUDENT = 'Smith';
UPDATE Advisor = 'Smith';
SET STUDENT Advisor = 'Smith';

Question 13

In Microsoft Access, a relationship between two tables is created:
by entering the name of the foreign key in the appropriate table in Design View.
by entering the name of the primary key in the appropriate table in Design View.
by dragging the primary key column of one table onto the foreign key column of the other table in the Relationships window.
by dragging the foreign key column of one table onto the primary key column of the other table in the Relationships window.
by dragging the primary key column of one table onto the primary key column of the other table in the Relationships window.

Question 14

Which symbol is used in standard SQL as a wildcard to represent a series of one or more unspeci?ed characters?

% (percent sign)
! (exclamation mark)
_ (underscore)
? (question mark)
; (semi-colon)

Question 15

Which symbol is used in standard SQL as a wildcard to represent a single, unspeci?ed character?

% (percent sign)
! (exclamation mark)
_ (underscore)
? (question mark)
; (semi-colon)

Question 16

Which of the following data types used in SQL would de?ne a numeric ?eld of the pattern
99.99?
integer(2,2)
integer(5,2)
numeric(2,2)
numeric(4,2)
numeric(5,2)

Question 17
Which of the following functional dependency diagrams accurately represents the following

Which of the following functional dependency diagrams accurately represents the following

situation:
BuildingName (RoomNumber, Capacity, Department)
RoomNumber (BuildingName, Department, Capacity)
(Department, Capacity) (BuildingName, RoomNumber)
(BuildingName, Capacity) (Department, RoomNumber)
(BuildingName, RoomNumber) (Capacity, Department)

Question 18

Which of the following is a function of the database application in a database system?
Create and transmit queries
Update database data
Maintain database structures
Create tables
Backup and restore data

Question 19

Which of the following is true about a relation?
The order of the columns in a relation must go from largest to smallest.
All entries in any column must be of the same kind.
A relation may have duplicate column names.
A relation may have duplicate rows.
A relation may have multiple names.

Question 20
Which of the following is not a basic component of a database system?
Database
User
ERD
DBMS
Data applications

Question 21
Which of the following is not a function of the database application in a database system?
Execute application logic
Control concurrency
Create and process forms
Create and transmit queries
Create and process reports

Question 22
Which of the following is not true about a relation?
A relation is a two-dimensional table.
The cells of a relation must hold a single value.
A relation may have duplicate column names.
A relation may not have duplicate rows.
The order of the rows of a relation is insigni?cant.

Question 23
Which of the following is not true about null values?
A null value can mean that the value is unknown.
A null value is ambiguous.
A null value can mean that the value is known to be blank.
A null value can mean that no value for the ?eld is appropriate.
Null values cannot be avoided.

Question 24
Which of the following is not true about primary keys?
Primary keys cannot be null.
Primary keys must be unique.
Primary keys must be a single attribute.
Primary keys are used to represent relationships.
Primary keys can be de?ned using an SQL CONSTRAINT phrase.

Question 25
Which of the following is not true of surrogate keys?
They are meaningful to the users.
They are numeric.
They are usually generated by the DBMS.
They are unique.
They are usually hidden on forms and reports.

Question 26
Which of the following problems associated with storing data in a list is avoided by storing
data in a relational database?
Maintaining the data may require changing the same data value in many locations.
Inconsistency when a data item is used multiple times
Inability to store partial data
Duplication of data items
All of these

Question 27
Which of the following terms is synonymous with "relation"?
Attribute
Table
Record
Row
Tuple

Question 28
Which of the following terms is synonymous with "tuple"?
Attribute
Table
Field
Row
Relation

Question 29
MedicineCode (MedicineName, ShelfLife, Manufacturer, Dosage)Given the above
functional dependency, which of the following statement is not known to be true?
MedicineCode is a determinant.
MedicineName is a determinant.
Manufacturer is functionally dependent on MedicineCode.
ShelfLife is functionally dependent on MedicineCode.
MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife,
Manufacturer, Dosage, MedicineCode).

Question 30
Microsoft Access 2010 database ?les are stored using the ?le extension:
.adb.

.asp.
.accdb.
.mdb.
.sql.

Question 31
Microsoft Access is a personal database system, and a personal database system is
characterized by:
the DBMS removing the metadata from the database.
the DBMS product taking the role of the DBMS and the database application generator.
the database being stored inside the DBMS.
the DBMS product being limited to a maximum of ten tables in any given database.
the DBMS not supporting indexes.

Question 32
One important relational design principle is that:
every determinant must be a candidate key.
every candidate key must not be a determinant.
every primary key must be a surrogate key.
every determinant must be functionally dependent on the primary key.
every primary key must be functionally dependent on every determinant.

Question 33
SQL stands for:
Standard Query Language.
Structural Question Language.
Structured Query Language.
Standard Question Language.
Structured Question Language.

Question 34
STUDENT (SID, StudentName, Major, AdvisorID)ADVISOR (AdvisorID, AdvisorName,
Ofce, Phone)Given the relations above such that each student is assigned to one advisor,
which of the following is true?
SID is both a primary key and a foreign key.
AdvisorName is a determinant.
AdvisorID is a foreign key.
Phone is a candidate key.
Major is a candidate key.

Question 35
The component of a database that makes it self-describing is the:
related tables.
applications.
library.
data set.
metadata.

Question 36
The creation of a database and its tables is a function of which component of the database
system?
Users
Application
DBMS
Database
Web server

Question 37
The ?rst step of the normalization process is to:
identify all the candidate keys of a relation.
identify all the foreign keys of a relation.
identify all the functional dependencies of a relation.
identify all the determinants of a relation.
split the relation into two or more new relations.

Question 38
The statement is an
example of:
QBE.
SQL.
QLE.
C++.
Java.

Question 39

Today almost every commercial database is based on:

lists.
the hierarchical model.

the linked-list model.
the relational model.
the object-oriented model.

Question 40

When the primary key of one relation is placed into a second relation, it is called a:

?eld key.
referential integrity.
foreign key.
candidate key.
relocated key.