ITS Databases Practice Exam 23

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

2024
Views:

331

Pages:

3
Author:

Muthia M.

Answer these question bellows. 1. Which three are true statements about Foreign Keys? (Choose three) A. A Foreign Key enforces referential integrity by ensuring only valid data is stored B. A table can contain only one Foreign Key C. A Foreign Key is the same as a Primary Key D. A Foreign Key is a combination of one or more columns used to establish and enforce a link between the data in two tables E. You can create a Foreign Key by defining a Foreign Key constraint when you create or alter a table 2. Review the underlined text in the following statement. 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. MINUS is a reserved keyword in SQL Server 2008 and therefore cannot be used as an object name or as a column name in a table, unless delimited. A. SUBTRACT B. PLUS C. ADD D. No change is needed 3. Refer to the image below. Use the dropdown menus to select the answer choice that completes each statement. a. The diagram is an example of a _____ Answer: Clustered Index b. Pages and rows are _____ Answer: Ordered 4. Review the underlined text in the following statement. 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. User Defined Functions can be used in Select, Where, or Case statements. They also can be used to create joins. A. Queries B. No change is needed C. Relationship Maps D. Stored Procedures 5. Review the underlined text in the following statement. 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. UPS is the best method to prevent the loss of data. A. Redundant NICS B. RAID C. Backup D. No change is needed