ITS Databases Practice Exam 25

University:
American Baptist College
Course:
CSCI 1534 | Data Analysis and Visualization
Academic year:

2024
Views:

429

Pages:

1
Author:

Muthia M.

Answer these question bellows. 1. Match the description to the database normal form. Instructions: To answer, drag the appropriate description from the column on the left to the database normal form on the right. Each description may be used once, more than once, or not at all. Answer: First Normal Form (1NF): Table has no repeating groups. Second Normal Form (2NF): No non-prime attribute in the table is functionally dependent on a proper subset of a candidate key Third Normal Form (3NF): Every non-prime attribute is non-transitively dependent on every candidate key in the table Fourth Normal Form (4NF): Every non-trivial multivalued dependency in the dependency on a super key Fifth Normal Form (5NF): Every non-trivial join dependency in the table is implied by the super keys of the table 2. The WHERE clause allows you to A. View a subset of columns. B. Obtain a subset of rows. C. Order a subset of rows. D. Update the values inside a record or groups of records. 3. What will be the result of the following statement? SELECT REPLACE ('The best TTS solutions is provided by GMetrix', 's', 'z') A. The bezt TTz zolutionz iz provided by GMetrix B. The beszt TTSz szolutionsz isz provided by GMetrix C. A SQL Server Orthographic error D. None of the above