Question 1

You cannot delete a row from a view.​

Accepted Answer

A) True 
 B)False

Question 2

A view is a derived table.​

Accepted Answer

A) True 
 B)False

Question 3

You can create and use a(n)____________________ to speed up the searching process significantly.​

Accepted Answer

The answer of You can create and use a(n)____________________ to...

Question 4

You can add rows to a view that includes calculations.​

Accepted Answer

A) True 
 B)False

Question 5

To create a view definition,use the ____________________ command.​

Accepted Answer

The answer of To create a view definition,use the ____________________...

Question 6

The database administrator uses the ____ command to revoke privileges from users.​

Accepted Answer

A) DROP 
B) ​REMOVE 
C) REVOKE 
D) ​CANCEL 
A) DROP 
B) ​REMOVE 
C) REVOKE 
D) ​CANCEL

Question 7

The CREATE VIEW command includes the words CREATE VIEW,followed by the name of the view,the word ____,and then a query.​

Accepted Answer

A) AC 
B) ​SA 
C) AS 
D) ​IN 
A) AC 
B) ​SA 
C) AS 
D) ​IN

Question 8

The defining query can be any transaction.​

Accepted Answer

A) True 
 B)False

Question 9

The DROP VIEW command removes the tables and data on which the view is based.​

Accepted Answer

A) True 
 B)False

Question 10

To add a primary key after creating a table,you can use the ____________________ clause of the ALTER TABLE command.​

Accepted Answer

The answer of To add a primary key after creating...

Question 11

A view that involves statistics calculated from one or more base tables is the easiest view when attempting to update data.​

Accepted Answer

A) True 
 B)False

Question 12

To ensure the uniqueness of values in a nonprimary key column,use the ____ command to create an index.​

Accepted Answer

A) CREATE UNIQUE INDEX 
B) ​CREATE NONPRIMARY INDEX 
C) CREATE INDEX 
D) ​CREATE ONLY INDEX 
A) CREATE UNIQUE INDEX 
B) ​CREATE NONPRIMARY INDEX 
C) CREATE INDEX 
D) ​CREATE ONLY INDEX

Question 13

The privilege ____ can be granted to change the table structure.​

Accepted Answer

A) WRITE 
B) ​UPDATE 
C) ALTER 
D) ​MODIFY 
A) WRITE 
B) ​UPDATE 
C) ALTER 
D) ​MODIFY

Question 14

When the primary key contains more than one column,use commas to separate the column names.​

Accepted Answer

A) True 
 B)False

Question 15

When you specify a foreign key,the table containing the foreign key is the parent​

Accepted Answer

A) True 
 B)False

Question 16

Most database management systems support the creation of views.​

Accepted Answer

A) True 
 B)False

Question 17

If two base tables have the same primary key and the primary key is used as the join column,updating the database is a problem.​

Accepted Answer

A) True 
 B)False

Question 18

To ensure the uniqueness of values in a non-primary key column,you can create a unique index by using the ____________________ command.​

Accepted Answer

CREATE UNI

Question 19

Normally,when the database administrator grants a particular privilege to a user,the user cannot pass that privilege along to other users.​

Accepted Answer

A) True 
 B)False

Question 20

____________________ is the prevention of unauthorized access to a database.​

Accepted Answer

The answer of ____________________ is the prevention of unauthorized access...

You cannot delete a row from a view.

A view is a derived table.

You can create and use a(n)____________________ to speed up the searching process significantly.

You can add rows to a view that includes calculations.

To create a view definition,use the ____________________ command.

The database administrator uses the ____ command to revoke privileges from users.

The CREATE VIEW command includes the words CREATE VIEW,followed by the name of the view,the word ____,and then a query.

The defining query can be any transaction.

The DROP VIEW command removes the tables and data on which the view is based.

To add a primary key after creating a table,you can use the ____________________ clause of the ALTER TABLE command.

A view that involves statistics calculated from one or more base tables is the easiest view when attempting to update data.

To ensure the uniqueness of values in a nonprimary key column,use the ____ command to create an index.

The privilege ____ can be granted to change the table structure.

When the primary key contains more than one column,use commas to separate the column names.

When you specify a foreign key,the table containing the foreign key is the parent

Most database management systems support the creation of views.

If two base tables have the same primary key and the primary key is used as the join column,updating the database is a problem.

To ensure the uniqueness of values in a non-primary key column,you can create a unique index by using the ____________________ command.

Normally,when the database administrator grants a particular privilege to a user,the user cannot pass that privilege along to other users.

____________________ is the prevention of unauthorized access to a database.

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

SQL Functions and Procedures

Filters

Exam 7: Database Administration

You cannot delete a row from a view.​

A view is a derived table.​

You can create and use a(n)____________________ to speed up the searching process significantly.​

You can add rows to a view that includes calculations.​

To create a view definition,use the ____________________ command.​

The database administrator uses the ____ command to revoke privileges from users.​

The CREATE VIEW command includes the words CREATE VIEW,followed by the name of the view,the word ____,and then a query.​

The defining query can be any transaction.​

The DROP VIEW command removes the tables and data on which the view is based.​

To add a primary key after creating a table,you can use the ____________________ clause of the ALTER TABLE command.​

A view that involves statistics calculated from one or more base tables is the easiest view when attempting to update data.​

To ensure the uniqueness of values in a nonprimary key column,use the ____ command to create an index.​

The privilege ____ can be granted to change the table structure.​

When the primary key contains more than one column,use commas to separate the column names.​

When you specify a foreign key,the table containing the foreign key is the parent​

Most database management systems support the creation of views.​

If two base tables have the same primary key and the primary key is used as the join column,updating the database is a problem.​

To ensure the uniqueness of values in a non-primary key column,you can create a unique index by using the ____________________ command.​

Normally,when the database administrator grants a particular privilege to a user,the user cannot pass that privilege along to other users.​

____________________ is the prevention of unauthorized access to a database.​

Introduction to TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group

Database Design Fundamentals

Creating Tables

Single-Table Queries

Multiple-Table Queries

Updating Data

SQL Functions and Procedures

Filters

You cannot delete a row from a view.

A view is a derived table.

You can create and use a(n)____________________ to speed up the searching process significantly.

You can add rows to a view that includes calculations.

To create a view definition,use the ____________________ command.

The database administrator uses the ____ command to revoke privileges from users.

The CREATE VIEW command includes the words CREATE VIEW,followed by the name of the view,the word ____,and then a query.

The defining query can be any transaction.

The DROP VIEW command removes the tables and data on which the view is based.

To add a primary key after creating a table,you can use the ____________________ clause of the ALTER TABLE command.

A view that involves statistics calculated from one or more base tables is the easiest view when attempting to update data.

To ensure the uniqueness of values in a nonprimary key column,use the ____ command to create an index.

The privilege ____ can be granted to change the table structure.

When the primary key contains more than one column,use commas to separate the column names.

When you specify a foreign key,the table containing the foreign key is the parent

Most database management systems support the creation of views.

If two base tables have the same primary key and the primary key is used as the join column,updating the database is a problem.

To ensure the uniqueness of values in a non-primary key column,you can create a unique index by using the ____________________ command.

Normally,when the database administrator grants a particular privilege to a user,the user cannot pass that privilege along to other users.

____________________ is the prevention of unauthorized access to a database.