Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. Each correct selection is worth one point.
Hot Area:
You have a table that contains the following data.
You break the table into the following two tables.
This process is referred to as:
A. defragmentation
B. normalization
C. fragmentation
D. denormalization
Data in a database is stored in:
A. Tables
B. Queries
C. Data types
D. Stored procedures
You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement:
DELETE FROM Student
What is the result?
A. All rows in the table will be deleted.
B. All rows containing a NULL value in the FirstName column will be deleted.
C. You will receive an error message.
D. All rows and the table definition will be deleted.
You need to disable User1's access to view the data in the Customer table.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
You have a table named Customer. You need to add a new column named District. Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
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
You accept an IT internship at a local charity. The charity asks you to keep a record of its volunteers by using a database table named Volunteer.
When volunteers ask to be removed from mailing lists, the table must be updated.
You need to use a transaction to ensure that the database has data integrity and referential integrity.
Which statement should you use?
A. Option A
B. Option B
C. Option C
D. Option D
You create the following table, which lists how many books you have on loan to your friends.
Harry in San Francisco returns your books.
Which statement will update your table correctly?
A. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' AND City = 'San Francisco')
B. UPDATE LoanedBooks SET Books = 0 WHERE (Name = 'Harry' OR City = 'San Francisco')
C. UPDATE LoanedBooks SET Books = 0 WHERE (Name in 'Harry', 'San Francisco')
D. INSERT INTO LoanedBooks SET Books = 0 WHERE ID =
You need to create a view to filter rows of data from an underling table.
Which type of clause must be included in the CREATE VIEW statement?
A. CONSTRAINT
B. WHERE
C. JOIN
D. FILTER