SQL Foundations  «Prev  Next»

Database Foundations - Quiz

Each question is worth 1 point. Select the best answer for each question.
1. Which item below refers to a column in a table (for example, the lastName column)?
Please select the best answer.
  A. A column
  B. A row
  C. A table
  D. A database

2. What clause do you use if you want to create a column that does not allow NULL values?
Please select the best answer.
  A. NOT BLANK
  B. REQUIRED
  C. NOT NULL
  D. NOT NULLABLE

3. What benefits do indexes provide for your queries?
Please select the best answer.
  A. Faster query times
  B. Sorting
  C. Better use of the database engine (less work in retrieving your results)
  D. Both A and C

4. Which of the statements below is correct?
Please select the best answer.
  A. CREATE NEW INDEX New_Index on MyTable (MyColumn)
  B. CREATE INDEX ON MyTable(MyColumn) NAME New_Index
  C. CREATE INDEX New_Index ON MyTable(MyColumn)
  D. CREATE INDEX ON MyTable(MyColumn) AS New_Index

5. Which of the following statements is incorrect regarding indexes?
Please select the best answer.
  A. Indexes are largely for optimizing the query of a table.
  B. Indexes control the sort order for information in the table.
  C. Indexes provide a logical path for the engine to consider when it extracts information from the table.
  D. Indexes are manually created using SQL commands.