Question 1

The system catalog contains information about the operating system.

Accepted Answer

The system catalog contains information about the database schema, such as tables, views, indexes, and stored procedures, not about the operating system.

Question 2

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

Accepted Answer

User-level security is not automatically available in Access databases starting from Access 2007, as it was removed in favor of other security measures.

Question 3

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

Accepted Answer

Setting an index on a field primarily increases the speed of data retrieval operations by allowing the database management system to find records faster. Indexes are not directly related to preventing data integrity errors, restricting access, or improving the accuracy of data entry.

Question 4

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.

Accepted Answer

To set a database password in Access, the database must be opened in exclusive mode. This ensures that no other users are accessing the database at the same time, which is necessary for setting or changing its password.

Question 5

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.

Accepted Answer

Creating and running a query in Access allows you to view specific subsets of data based on criteria you define, effectively creating a "view" of the data.

Question 6

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

Accepted Answer

Indexing a field that is frequently sorted on can significantly improve the performance of the sort operations by reducing the time it takes to locate and order the records based on that field.

Question 7

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;

Accepted Answer

The SQL command "GRANT SELECT ON Projects TO Mendez;" specifically grants the user Mendez the permission to select (or query) data from the Projects table, without granting any other type of access or action such as insert, update, or delete.

Question 8

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

Accepted Answer

The correct syntax to set a field as a foreign key in SQL is "FOREIGN KEY (column_name) REFERENCES parent_table(column_name)". Therefore, option D is correct as it follows this syntax.

Question 9

Views are often called a(n) _____ representation of the data in the database.
A)physical
B)composite
C)logical
D)exclusive

Accepted Answer

Views are considered a logical representation of the data in the database because they provide a way to look at data in the database without storing the data separately. They are essentially virtual tables created by a query.

Question 10

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);

Accepted Answer

The correct SQL syntax to create an index on a specific column in a table is "CREATE INDEX index_name ON table_name (column_name);".

Question 11

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)

Accepted Answer

The correct option is "Yes (Duplicates OK)" because it allows the field to be indexed while permitting duplicate entries, which is necessary for fields that are not primary keys and might contain duplicates.

Question 12

A primary key field should never allow full values.

Accepted Answer

A primary key field should never allow null values because it is used to uniquely identify each record in a table. If a primary key field can contain null values, then it is possible for two or more records to have the same primary key value, which would violate the uniqueness constraint.

Question 13

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

Accepted Answer

A view is a virtual table based on the result-set of an SQL statement. It does not store data itself but fetches it from one or more tables upon request.

Question 14

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.

Accepted Answer

Each option listed (A, B, C) represents a legitimate concern in database security. Unauthorized access prevention, safe data distribution, and physical security are all critical aspects of securing a database.

Question 15

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

Accepted Answer

The correct SQL command to provide access to specific data is the GRANT statement, not ALLOW.

Question 16

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

Accepted Answer

Entity integrity is the database concept that ensures the primary key of a table is unique and contains no null values. This is crucial for uniquely identifying each record in a table.

Question 17

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

Accepted Answer

CustomerID is typically a unique identifier for each record in the Customers table, making it the best candidate for indexing to improve search and retrieval performance.

Question 18

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

Accepted Answer

The correct SQL syntax to create a view named ClientList is "CREATE VIEW ClientList". This command defines a virtual table that you can query to simplify complex queries or to provide a specific view of the data to users.

Question 19

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

Accepted Answer

Cascade Update Related Fields option ensures that changes made to the value of a primary key in the parent table (Clients table, in this case) are automatically reflected in the corresponding foreign key in the related child table (Projects table). This maintains referential integrity by updating related foreign key values when the primary key value changes.

Question 20

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.

Accepted Answer

Creating a backup of the database is a physical security measure to ensure data integrity and availability in case of hardware failure, data corruption, or other physical threats.

Quiz 6: Database Design: Relationships

The system catalog contains information about the operating system.

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

Why would you set an index on a field?

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

How do you create a view of data in Access?

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

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 clauses sets the ProductID field as the foreign key to the Orders table?

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

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

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 primary key field should never allow full values.

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

Which of the following is not a database security concern?

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

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

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 SQL commands creates a view named ClientList?

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?

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