You work as a Database Administrator for Bell Ceramics Inc. An employee of the company has fired a
query, including a DML statement, such as INSERT, against a table named Sales. You notice that the
DML statement has not executed. What will you do to resolve the issue? Each correct answer
represents a complete solution. Choose two.

You manage a large database named Sales. The Sales database contains a table named OrderDetails,
which is a heavily transacted table with frequent inserts. Indexes in the table often become
fragmented due to excessive page splitting. You want to minimize the amount of fragmentation due
to page splits. What should you do?

Which of the following is the process of extracting trails on a regular basis so that they can be
transferred to a designated security system where the database administrators do not have access?

You work as a Database Developer for GraySoft Inc. You are designing a database to record
information about potential customers. You create a table named ProductInquiry for the database.
The table is given below:

You want to uniquely identify the product in which a customer is interested. Choose the columns on
which a PRIMARY KEY constraint needs to
be created to accomplish this.