ITS Databases Practice Exam #9

University:
American Baptist College
Course:
CIT370 | Database Design and Processing
Academic year:

2024
Views:

313

Pages:

1
Author:

Muthia M.

Answer these question bellows. 1. Which SQL statement will delete a table named testtable from a database? A. TRUNCATE TABLE testtable B. DELETE TABLE testtable C. DROP TABLE testtable D. REVOKE TABLE testable 2. An organization storing climate data needs to have its database tables be in third normal form. Which statement best defines a table in third normal form? A. The table faithfully represents a relation and has no repeating groups. B. No non-prime attribute in the table is functionally dependent on a proper subset of a candidate key. C. Every non-trivial join dependency in the table is implied by the superkeys of the table D. Every non-prime attribute is non-transitively dependent on every candidate key in the table. 3. You are the assistant database manager at a local amusement park. Amusement Park ticket prices are being raised this season by 10%, and you have been tasked to update the database Park table. Which would be the correct statement to raise Ticket prices 10% in the Park table? A. UPDATE Park SET Ticket = Ticket * 1.1 B. UPDATE Ticket SET Park = Ticket * 1.1 C. UPDATE Park SET Ticket = .10 D. UPDATE Park SET Ticket = increase 10%