Q1. HOTSPOT
Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Answer:
Q2. You have a Department table and an Employee table in your database.
You need to ensure that an employee can be assigned to only an existing department.
What should you apply to the Employee table?
A. A primary key
B. An index
C. A foreign key
D. A unique constraint
E. A data type
Answer: C
Q3. This question requires that you evaluate the underlined text to determine if it is correct.
Views are database objects that contain all of the data in a database.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct
A. No change is needed
B. Queries
C. Stored procedures
D. Tables
Answer: D
Q4. You accept an IT internship at a local charity. The charity wants you to help them with compliance and auditing requirements.
You need to ensure that a column or combination of columns uniquely identifies each row of a table.
Which constraint should you define?
A. Primary key
B. Secondary key
C. Foreign key
D. Default key
Answer: C
Q5. Which constraint ensures a unique value in the ID column for each customer?
A. DISTINCT
B. FOREIGN KEY
C. SEQUENTIAL
D. PRIMARY KEY
Answer: D
Q6. One reason to create a stored procedure is to:
A. Improve performance.
B. Minimize storage space.
C. Bypass case sensitivity requirements.
D. Give the user control of the query logic.
Answer: A
Q7. You execute the following statement:
This statement is an example of a/an:
A. Subquery
B. Union
C. Outer join
D. Cartesian product
Answer: A
Q8. Your class project requires that you help a charity to create a website that registers volunteers.
The website must store the following data about the volunteers:
Given name
Surname
Telephone number
Email address
You need to recommend a correct way to store the data.
What do you recommend?
A. Create a table that contains columns that are named given name, surname, phone number, and email.
B. Create a table that contains rows that are named given name, surname, phone number, and email.
C. Create a view that contains columns that are named given name surname, phone number, and email.
D. Create a view that contains rows that are named given name surname, phone number, and email
Answer: A
Q9. This question requires that you evaluate the underlined text to determine if it is correct.
First normal form requires that a database excludes repeating groups.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.
A. No change is needed.
B. Composite keys
C. Duplicate rows
D. Foreign keys
Answer: A
Q10. On which database structure does an insert statement operate?
A. Role
B. Trigger
C. User
D. Stored procedure
E. Table
Answer: E