Which of the following is true about indexes and index design?
A. indexes should be created on columns used by WHERE and BY clauses
B. a composite index is an index on a single column
C. an index is created for every foreign key by default
D. indexes usually speed up write operations
Answer: A
You might also like to view...
List the comments on the columns for the STUDENT table along with their column names.
What will be an ideal response?
Use a PL/SQL table of records to retrieve all information from the DEPT table and print information to the screen. You will declare a table to store names and locations of the departments. Remember that the department number is a multiple of 10. Retrieve all department information from the DEPT table to the PL/SQL table using a loop, and then use another loop to print the information.
What will be an ideal response?
A database is divided into separate tables.
Answer the following statement true (T) or false (F)
Before you can open and edit a compressed file, you must uncompress it, or ____ it.
A. extract B. dearchive C. explore D. unlock