Question 1

Which clause has the same result as the clause WHERE Clients.ClientID = Projects.ClientID?

Accepted Answer

A) JOIN Clients.ClientID = Projects.ClientID 
B) INNER JOIN Projects ON Clients.ClientID = Projects.ClientID 
C) INNER JOIN Clients AND Projects 
D) JOIN Clients ON Clients.ClientID AND Projects ON Projects.ClientID 
A) JOIN Clients.ClientID = Projects.ClientID 
B) INNER JOIN Projects ON Clients.ClientID = Projects.ClientID 
C) INNER JOIN Clients AND Projects 
D) JOIN Clients ON Clients.ClientID AND Projects ON Projects.ClientID B

Question 2

You use the SQL ALLOW statement to provide access to specific data.

Accepted Answer

A) True 
 B)False  False

Question 3

If you will frequently sort on a field, it is a good candidate for an index.

Accepted Answer

A) True 
 B)False  True

Question 4

How do you create a view of data in Access?

Accepted Answer

A) Create and run a query. 
B) Create and open a table. 
C) Create and print a report. 
D) Create an update query. 
A) Create and run a query. 
B) Create and open a table. 
C) Create and print a report. 
D) Create an update query.

Question 5

In an enterprise-level relational database, where might you save a query if you anticipate running it often?

Accepted Answer

A) index 
B) stored procedure 
C) navigation form 
D) system catalog 
A) index 
B) stored procedure 
C) navigation form 
D) system catalog

Question 6

What can you do to provide physical security for a database?

Accepted Answer

A) Create a backup of the database. 
B) Set more than one index on each table. 
C) Create startup forms for users. 
D) Maintain the system catalog. 
A) Create a backup of the database. 
B) Set more than one index on each table. 
C) Create startup forms for users. 
D) Maintain the system catalog.

Question 7

Contrast LEFT and RIGHT joins and the records they return.

Accepted Answer

A LEFT join returns all records in the t

Question 8

In Access, you can change _____ such as Indexed and Field Size in Table Design View.

Accepted Answer

A) table attributes 
B) data types 
C) field properties 
D) field descriptions 
A) table attributes 
B) data types 
C) field properties 
D) field descriptions

Question 9

Which of the following is not a database security concern?

Accepted Answer

A) preventing unauthorized access to the data 
B) distributing data safely 
C) providing physical security 
D) Each of these is a database security concern. 
A) preventing unauthorized access to the data 
B) distributing data safely 
C) providing physical security 
D) Each of these is a database security concern.

Question 10

List five technical competencies common to most database administration positions.

Accepted Answer

Database administrators are expected to

Question 11

Which of the following is a language that is used to describe content distributed through a webpage?

Accepted Answer

A) CSS 
B) HTML 
C) Linux 
D) DB2 
A) CSS 
B) HTML 
C) Linux 
D) DB2

Question 12

What must you do before setting a database password in Access?

Accepted Answer

A) Create an index for each primary key field. 
B) Set startup options that restrict access to the database tables. 
C) Encrypt the database. 
D) Open the database in exclusive mode. 
A) Create an index for each primary key field. 
B) Set startup options that restrict access to the database tables. 
C) Encrypt the database. 
D) Open the database in exclusive mode.

Question 13

Views are often called a(n) _____ representation of the data in the database.

Accepted Answer

A) physical 
B) composite 
C) logical 
D) exclusive 
A) physical 
B) composite 
C) logical 
D) exclusive

Question 14

What does the Bureau of Labor Statistics project for database administration jobs?

Accepted Answer

A) They will grow 11 percent through the year 2026. 
B) They will decline 5 percent through the year 2026. 
C) They will neither grow nor decline through the year 2026. 
D) They will become obsolete by the year 2026. 
A) They will grow 11 percent through the year 2026. 
B) They will decline 5 percent through the year 2026. 
C) They will neither grow nor decline through the year 2026. 
D) They will become obsolete by the year 2026.

Question 15

Which of the following clauses sets the ProductID field as the foreign key to the Orders table?

Accepted Answer

A) FOREIGN KEY (ProductI
D)  RELATED TO Orders 
B) SET ProductID AS FOREIGN KEY TO Orders 
C) CREATE FOREIGN KEY (ProductI
D)  Orders 
D) FOREIGN KEY (ProductI
D)  REFERENCES Orders 
A) FOREIGN KEY (ProductI
D)  RELATED TO Orders 
B) SET ProductID AS FOREIGN KEY TO Orders 
C) CREATE FOREIGN KEY (ProductI
D)  Orders 
D) FOREIGN KEY (ProductI
D)  REFERENCES Orders

Question 16

Which of the following SQL commands lets user Mendez select data from the Projects table but not take any other action?

Accepted Answer

A) GRANT INSERT ON Projects TO Mendez; 
B) GRANT SELECT ON Projects TO Mendez; 
C) REVOKE SELECT ON Projects TO Mendez; 
D) ALLOW SELECT ON Projects TO Mendez; 
A) GRANT INSERT ON Projects TO Mendez; 
B) GRANT SELECT ON Projects TO Mendez; 
C) REVOKE SELECT ON Projects TO Mendez; 
D) ALLOW SELECT ON Projects TO Mendez;

Question 17

Which of the following is a system table typically maintained by a DBMS?

Accepted Answer

A) Syscolumns 
B) Sysrows 
C) Sysfilters 
D) Sysrecords 
A) Syscolumns 
B) Sysrows 
C) Sysfilters 
D) Sysrecords

Question 18

What is the term for a general set of skills that involves defining, dissecting, communicating, and solving problems using data and information?

Accepted Answer

A) data analysis 
B) library science 
C) data warehousing 
D) information research 
A) data analysis 
B) library science 
C) data warehousing 
D) information research

Question 19

Which field in the Customers table is the best candidate to index to improve database performance? Customers (CustomerID, FirstName, LastName, Address, City, Zip, Phone, BirthDate)

Accepted Answer

A) CustomerID 
B) FirstName 
C) Address 
D) BirthDate 
A) CustomerID 
B) FirstName 
C) Address 
D) BirthDate

Question 20

Which of the following database actions is not recorded in the system catalog?

Accepted Answer

A) You delete a table. 
B) You establish a relationship between two tables. 
C) You add an index. 
D) All of these actions are included in the system catalog. 
A) You delete a table. 
B) You establish a relationship between two tables. 
C) You add an index. 
D) All of these actions are included in the system catalog.

Which clause has the same result as the clause WHERE Clients.ClientID = Projects.ClientID?

You use the SQL ALLOW statement to provide access to specific data.

If you will frequently sort on a field, it is a good candidate for an index.

How do you create a view of data in Access?

In an enterprise-level relational database, where might you save a query if you anticipate running it often?

What can you do to provide physical security for a database?

Contrast LEFT and RIGHT joins and the records they return.

In Access, you can change _____ such as Indexed and Field Size in Table Design View.

Which of the following is not a database security concern?

List five technical competencies common to most database administration positions.

Which of the following is a language that is used to describe content distributed through a webpage?

What must you do before setting a database password in Access?

Views are often called a(n) _____ representation of the data in the database.

What does the Bureau of Labor Statistics project for database administration jobs?

Which of the following clauses sets the ProductID field as the foreign key to the Orders table?

Which of the following SQL commands lets user Mendez select data from the Projects table but not take any other action?

Which of the following is a system table typically maintained by a DBMS?

What is the term for a general set of skills that involves defining, dissecting, communicating, and solving problems using data and information?

Which field in the Customers table is the best candidate to index to improve database performance? Customers (CustomerID, FirstName, LastName, Address, City, Zip, Phone, BirthDate)

Which of the following database actions is not recorded in the system catalog?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters

Exam 6: Database Design: Relationships

Which clause has the same result as the clause WHERE Clients.ClientID = Projects.ClientID?

You use the SQL ALLOW statement to provide access to specific data.

If you will frequently sort on a field, it is a good candidate for an index.

How do you create a view of data in Access?

In an enterprise-level relational database, where might you save a query if you anticipate running it often?

What can you do to provide physical security for a database?

Contrast LEFT and RIGHT joins and the records they return.

In Access, you can change _____ such as Indexed and Field Size in Table Design View.

Which of the following is not a database security concern?

List five technical competencies common to most database administration positions.

Which of the following is a language that is used to describe content distributed through a webpage?

What must you do before setting a database password in Access?

Views are often called a(n) _____ representation of the data in the database.

What does the Bureau of Labor Statistics project for database administration jobs?

Which of the following clauses sets the ProductID field as the foreign key to the Orders table?

Which of the following SQL commands lets user Mendez select data from the Projects table but not take any other action?

Which of the following is a system table typically maintained by a DBMS?

What is the term for a general set of skills that involves defining, dissecting, communicating, and solving problems using data and information?

Which field in the Customers table is the best candidate to index to improve database performance? Customers (CustomerID, FirstName, LastName, Address, City, Zip, Phone, BirthDate)

Which of the following database actions is not recorded in the system catalog?

Introduction to Database Management

The Relational Model: Introduction, Qbe, and Relational Algebra

The Relational Model: SQL

The Relational Model: Advanced Topics

Database Design: Normalization

Database Management Systems Processes and Services

Database Industry Careers

Database Industry Trends

Filters