Which of the following describes the purpose of a snapshot?
A. To create a dynamic data replication
B. To create a synonym
C. To create a
D. To create an image of a database
A database administrator is concerned about transactions in case the system fails. Which of the following properties addresses this concern?
A. Durability
B. Isolation
C. Atomicity
D. Consistency
Which of the following NFs is considered themostpreferable for relational database design?
A. 1 NF
B. 3 NF
C. 4 NF
D. 2NF
A database administrator needs to ensure that a newly installed corporate business intelligence application can access the company's transactional data. Which of the following tasks should the administrator performfirst?
A. Create a new service account exclusively for the business intelligence application.
B. Build a separate data warehouse customized to the business intelligence application's specifications.
C. Set up a nightly FTP data transfer from the database server to the business intelligence application server.
D. Send the business intelligence administrator the approved TNS names file to configure the data mapping.
E. Open a new port on the database server exclusively for the business intelligence application.
A business analyst is using a client table and an invoice table to create a database view that shows clients who have not made purchases yet. Which of the following joins ismostappropriate for the analyst to use to create this database view?
A. INNER JOIN ON Client.Key = Invoice.Key
B. RIGHT JOIN ON Client.Key = Invoice.Key WHERE BY Client.Key ISNOLL
C. LEFT JOIN ON Client.Key = Invoice.Key
D. LEFT JOIN ON Client.Key = Invoice.Key WHEREBY Invoice.Key ISNOLL
Which of the following is a typical instruction that is found on a Linux command-line script and represents a system shell?
A. /bin/bash
B. #/bin/shell
C. >/bin/sh
D. #!/bin/bash
A database administrator would like to create a table named XYZ. Which of the following queries should the database administrator use to create the table?

A. Option A
B. Option B
C. Option C
D. Option D
Which of the following transactions is allowed in a shared lock?
A. Read
B. Update
C. Delete
D. Insert
Which of the following commands when executed will rebuild statistics against user-defined tables in a database?
A. sp_autostats
B. sp_updatestats
C. DBCC UPDATEUSAGE
D. DBCC SHOW_STATISTICS
During a routine audit, a database administrator discovers that the department manager's birthday is next week. The database administrator decides to plan a birthday party for the manager. Which of the following guidelines would the administrator violate by planning the party?
A. PII
B. PCI DSS
C. SOX
D. ANSI