Multiple Choice
The purpose of creating databases indexes is to _____.
A) maintain the integrity of the data stored in tables
B) reduce the database's storage (memory) requirements
C) avoid searching through every row in a table with every query
D) grant and/or revoke privileges for certain actions to users
Correct Answer:
Verified
Correct Answer:
Verified
Q14: Views furnish a certain amount of security;
Q15: A database can be readily updated through
Q16: The CREATE VIEW command includes the words
Q17: In Oracle, which table contains information about
Q18: Which MySQL command displays all tables associated
Q20: Adding rows to a view is most
Q21: What does this SQL command accomplish? ALTER
Q22: An index makes certain types of retrieval
Q23: When renaming columns for a view, you
Q24: What happens if Samantha, whose view of