20%-Implements Databases and Database Management Systems

Question 1

Portland, OR 97212

How many attributes are present in the address fragment?

a. 1
b 2
c. 3
d. 4

Answer 1

c. 3

Question 2

Which data type represents numbers with fractional values:

e. Varchar
f. Integer
g. Binary
h. Decimal

Answer 2

h. Decimal

Question 3

What does a DDL command(Data Definition Language) command do?

Answer 3

CREATES, ALTERS AND DROPS Tables.

Question 4

What does a DML(Data Manipulation Language) command do?

Answer 4

INSERTS, UPDATES and DELETES data in a Table.

Question 5

What does a DQL(Data Query Language) command do?

Answer 5

SELECTS (Retrieves) data from a database.

Question 6

Which of the following are true about materialized view (Choose 2)?

e. It is a base table.
f. It is stored.
g. It must be refreshed whenever the base table changes.
h. The results are stored as a temporary table.

Answer 6

f. It is stored.
g. It must be refreshed whenever the base table changes.

Question 7

Seattle, WA 98111
USA
How many attributes are present in the address fragment?
a. 1
b. 2
c. 3
d. 4

Answer 7

D.4

Question 8

Which of the following are DDL commands?

a. INSERT
b. SELECT
c. CREATE INDEX
d. UPDATE

Answer 8

c. CREATE INDEX

Question 9

Which of the following is a DML command?
a. CREATE VIEW
b. CREATE TABLE
c. INSERT
d. ALTER INDEX

Answer 9

c. INSERT

Question 10

Which SQL command is an example of data definition language (DDL)?
A. UPDATE
B. ALTER.
C. SELECT
D. DELETE

Answer 10

B. ALTER

Question 11

How would a database engine process an update that violates a RESTRICT referential integrity constraint?
A. The offending value would be set to the database default value
B. The update would be rejected by the database.
C. The offending value would be set to NULL
D. The updated value would flow to the primary key

Answer 11

B. The update would be rejected by the database.

Question 12

Which restriction applies when using a materialized view?
A. The users of the view must provide search terms.
B. The underlying data must be periodically refreshed.
C. The tables referenced in the view must be indexed
D. The rows in the table must be compressed

Answer 12

B. The underlying data must be periodically refreshed.

Question 13

All changes to a table structure are made using the _____ command, followed by a keyword
that produces the specific changes a user wants to make.
e. ALTER TABLE
f. UPDATE TABLE
g. COMMIT TABLE

Answer 13

ALTER TABLE

Question 14

The SQL aggregate function that gives the number of rows containing non-null values for a
given column is _____.
a. COUNT
b. MIN
c. MAX
d. SUM

Answer 14

a. COUNT