Exam 6: Database Design: Relationships

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

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

Why would you set an index on a field?

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

The system catalog contains information about the operating system.

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

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

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

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?

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

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

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?

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

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

What is UNIX?

Compare stored procedures and triggers in a database.

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

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

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

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