Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

ifele letter (a, b, c, d) of the correct answer from the list provided. the 1. I

ID: 3855671 • Letter: I

Question

ifele letter (a, b, c, d) of the correct answer from the list provided. the 1. In RAID level 5 a) ol c) the data blocks are spread over separate drives and are duplicated. the array requires a minimum of two drives and is known as a striped array the data and the parity data are striped across separate drives. array requires a minimum of five drives and is known as duplexing. 2. Which comm a) RESTORE b) BACKUP c) COMMIT d) ROLLBACK h command(s) is used to restore the contents of a table to their original values? On the server side, the DBMS environment must be properly configured to respond to clients requests in the fastest way possible, while making optimum use of existing resources. The activities required to achieve that goal are commonly referred to as tuning. a) client and server b) database c) SQL performance d) DBMS performance 3. The a) DATE b) INT c) TINYINT d) CHAR (15) 4. 4. Thedata type is considered compatible with VARCHAR (35) data type is considered compatible with 5. security breaches include database access by computer wiruses and by hackers whose actions are designed to destroy or alter data. a) Dangerous b) Preserving c) Corrupting d) Authorized 6. If there is not index, the DBMS will perform a scan. a) loop b) range c) row ID table access d) full table

Explanation / Answer

1) C .(the data and the priority data are striped across separate drives )

2) D (ROLL BACK)

3) D (DBMS performance)

4) D (CHAR(15))

5) C (corrupting)

6) D (full table )

7) C (drop table )

8) B (subquery)

9) B (restricts the selection of grouped rows based on a condition)

10) D (17)