Call Us: US - +1 845 478 5244 | UK - +44 20 7193 7850 | AUS - +61 2 8005 4826

A(n) _______________ uses 0s and 1s to represent the existence of a value or condition. [removed] a. B-tree index [removed] b. bitmap index [removed] c. hash index [removed] d. reverse index

_____________ database systems are optimized to store large portions (if not all) of the database in primary (RAM) storage rather than secondary (disk) storage.

[removed]a. In-sync 
[removed]b. In-memory 
[removed]c. All of these choices are correct. 
[removed]d. None of these choices are correct.

In simple terms, the DBMS processes queries in ________ phase(s).

[removed]a. four 
[removed]b. one 
[removed]c. two 
[removed]d. three

Which of the following phase is where the DBMS analyzes the SQL query and chooses the most efficient access/execution plan?

[removed]a. Fetching 
[removed]b. Parsing 
[removed]c. Execution 
[removed]d. Compiling

RAID level _______________ is when the data and the parity are striped across separate drives, providing good read performance and fault tolerance via parity data.

[removed]a. 1 
[removed]b. 5 
[removed]c. 0 
[removed]d. 3

Optimizer ______ are special instructions for the optimizer that are embedded inside the SQL command text.

[removed]a. hints 
[removed]b. costs 
[removed]c. facts 
[removed]d. rules

Which of the following is NOT one of the steps you would follow when formulating a query?

[removed]a. Determine how to join the tables 
[removed]b. Identify the source tables 
[removed]c. Determine the order in which to display the output 
[removed]d. Determine the query output