Deck 4: The Relational Model: Advanced Topics

Question 1

The system catalog contains information about the operating system.

Answer 1

False

Question 2

Which of the following SQL commands creates an index named LastName on the LastName field in the Customers table?

A) CREATE INDEX LastName, Customers.LastName;
B) CREATE INDEX LastName;
C) SELECT LastName FROM Customers INDEX LastName
D) CREATE INDEX LastName ON Customers (LastName);

Answer 2

D

Question 3

Which of the following SQL commands creates a view named ClientList?

A) VIEW ClientList
B) CREATE TABLE ClientList
C) CREATE VIEW ClientList
D) CREATE ClientList AS View

Answer 3

C

Question 4

ClientID is the primary key field in the Clients table, which is related to the Projects table through its ClientID foreign key field. In Access, what option should you select to update the ClientID field values in the Projects table if the ClientID field values change in the Clients table?

A) Entity Integrity
B) Cascade Update Related Fields
C) Cascade Delete Related Records
D) Validation Rule Property

Question 5

In a database, a view is a copy of table data.

Question 6

What database concept states that the primary key cannot allow null values?

A) legal-values integrity
B) structural integrity
C) referential integrity
D) entity integrity

Question 7

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

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

Question 8

Why would you set an index on a field?

A) to prevent data integrity errors
B) to restrict access to the field
C) to improve the accuracy of data entry
D) to increase the speed of retrieving data

Question 9

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

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 10

How do you create a view of data in Access?

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

Question 11

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

Question 12

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

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

Question 13

Which of the following is not 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 14

In Access, what Indexed option do you select to create an index on a field that might contain duplicate values but is not a primary key field?

A) Yes (Duplicates OK)
B) No
C) Yes (No Duplicates)
D) Yes (Duplicates Only)

Question 15

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

Question 16

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

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

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

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 18

What type of security is not automatically available in an Access database?

A) file-level security
B) password protection
C) startup options
D) user-level security

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)

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

Question 20

A primary key field should never allow full values.

Question 21

When you display the system tables in Access, where do they appear?

A) Navigation Pane
B) Navigation Options dialog box
C) System Catalog dialog box
D) Database Tools tab of the ribbon

Question 22

Although Access does not have stored procedures, you can achieve some of the same benefits with _____.

A) update queries
B) indexes
C) data macros
D) validation rules

Question 23

Which of the following table events occurs after an existing record has been changed?

A) After Record
B) On Change
C) Before Update
D) After Update

Question 24

Which of the following statements removes the Comments field from the Projects table?

A) ALTER TABLE Projects DELETE FIELD Comments;
B) DROP Comments FROM Projects;
C) ALTER TABLE Projects DROP COLUMN Comments;
D) DELETE COLUMN Comments FROM Projects;

Question 25

What does the INNER JOIN command select from related tables?

A)all records in the parent table even if they do not have matching records in the child table b.
Records that have matching values in both tables
C)
All records in the child table even if they do not have matching records in the parent table
D)
All records in both tables even if they do not have matching records

Question 26

Which Access tool provides details about each table, query, report, form, and other object in a database?

A) Relationship Report
B) Database Optimizer
C) Navigation Pane
D) Database Documenter

Question 27

What type of join should you use to create a query from a parent table named Customers and a child table named Orders where the linking field contained values in both tables?

A) OUTER
B) LEFT
C) RIGHT
D) INNER

Question 28

Which clause has the same result as the clause WHERE Clients.ClientID = 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

Question 29

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

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

Question 30

Which of the following SQL commands do you use to change the structure of the Vendors table?

A) UPDATE TABLE Vendors
B) MODIFY (Vendors)
C) ALTER TABLE Vendors
D) CHANGE STRUCTURE Vendors

Question 31

When you add or delete a table or change the structure of a table, where does the DBMS record these changes?

A) stored procedure
B) system catalog
C) view
D) index

Question 32

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

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

Question 33

A(n) _____ is an action that occurs automatically in response to a database operation such as INSERT, UPDATE, or DELETE.

A) view
B) entity constraint
C) system prompt
D) trigger

Question 34

What happens when you use the DROP TABLE command?

A) Access deletes the table structure and makes a backup copy of the data.
B) Access deletes the table structure and the table data.
C) Access deletes only the table data, but preserves the structure.
D) Access requires a password to open the table.

Question 35

Which of the following statements removes the Services table from a database?

A) DELETE TABLE Services;
B) DROP TABLE Services;
C) REMOVE TABLE Services;
D) REVOKE TABLE Services;

Question 36

Which of the following database actions is not recorded 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.

Question 37

To specify the CustomerNum field as the primary key for the Customer table, which clause should you use?

A) PRIMARY KEY (CustomerNum)
B) PRIMARY KEY (Customer, CustomerNum)
C) KEY (CustomerNum)
D) PRIMARY (CustomerNum)

Question 38

To insert a new field in a table, which keyword should be used with the ALTER TABLE command?

A) INSERT
B) ADD
C) INCLUDE
D) ALTER

Question 39

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

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

Question 40

When would you use the SQL RIGHT JOIN command?

A) to find unique field values
B)to find matching records from three or more tables c.
To find orphan records
D)
To find null values

Question 41

According to an article referenced by the Bureau of Labor Statistics, which of the following is a fundamental competency for a job in database administration?

A) CSS (Cascading Style Sheets)
B) Oracle
C) NoSQL
D) Microsoft Outlook

Question 42

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

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

Question 43

Compare stored procedures and triggers in a database.

Question 44

List five technical competencies common to most database administration positions.

Question 45

List five benefits or uses for views.

Question 46

What is meant by a null value? Is a null value the same as a value of zero? Explain your answer.

Question 47

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

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 48

What is UNIX?

A) a popular open source operating system for client computers
B) a small-scale relational database management system
C) a popular open source operating system for servers
D) a large-scale relational database management system

Question 49

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

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