ITS Databases Practice Exam #6 | American Baptist College

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

2024
Views:

494

Pages:

2
Author:

Muthia M.

Answer these question bellows. 1. Use the dropdown arrows to choose whether each index characteristic is part of a clustered index or a non-clustered index. a. This type of index sorts data on the column with a clustered index. (CLUSTERED b. The type of index stored data in a separate structure from the table being indexed. (NON-CLUSTERED) 2. A junior administrator discovers the roles area on a SQL server and wants to know what the roles represent. What is the main purpose of roles in a database? A. Roles are states of a database. B. Roles are objects within a database. C. Roles contain sets of permissions that can be granted to users and groups in a database. D. Roles are keywords, such as GRANT or REVOKE. 3. An IT manager needs to know which day within a log of days for a month had the lowest number of calls. The date and number of calls needs to display. Which SQL statement fulfills the IT manager's need? A. SELECT log_date, MAX(calls) FROM call_log B. SELECT log_date, MIN(calls) FROM call_log GROUP BY MIN(calls) C. SELECT log_date, MIN(calls) FROM call log GROUP BY log_date D. SELECT log_date, MIN(calls) FROM call_log 4. An orders table is used as a lookup to an orderdetails table with the orderID column from an orders table as the column used to establish the relationship between the two tables. Which type of deletion will cause a cascading delete between the two tables? A. Deleting all the details for an order deletes the order. B. Deleting an order detail for an order deletes all order details for that order. C. Deleting an order deletes all the details of the order. D. Deleting an order deletes the first detail of that order. 5. Analyze the following statement: SELECT COUNT(*) from employees What will display for results from that statement? A. The number of records in the employees table. B. All the records of the table employees. C. The number of columns in the employees table. D. All the records that contains the character *.