Question 1

Using the index matching rules on a table with indexes created on columns C1,C2,C3,and C4,list the column(s)that would be matched if the WHERE clause contained the conditions "C2 = 10 AND C3 = 15 AND C4 = 4"._____________

Accepted Answer

The answer of Using the index matching rules on a...

Question 2

A(n)______________________ is a tree that encodes decisions about file structures to access individual tables,the order of joining tables,and the algorithm to join tables.

Accepted Answer

The answer of A(n)______________________ is a tree that encodes decisions...

Question 3

In Btree file structures,the physical record size,the key size and the pointer size determine node capacity.How many <key,pointer> pairs can be stored in a node if the physical record size is 1024 bytes,the key size is 8 bytes,and the pointer size is 8 bytes? __________

Accepted Answer

The answer of In Btree file structures,the physical record size,the...

Question 4

When a condition in the WHERE clause of a query references a column that has been indexed,the DBMS performs an operation known as ____________________ to determine if the index can be used.

Accepted Answer

The answer of When a condition in the WHERE clause...

Question 5

In a(n)_________________ file,the most popular variation of the Btree,all keys are stored redundantly in the leaf nodes.

Accepted Answer

The answer of In a(n)_________________ file,the most popular variation of...

Question 6

A(n)_________________ index references the rows of a child table that join with rows of the parent table containing the column.

Accepted Answer

The answer of A(n)_________________ index references the rows of a...

Question 7

A dominant RAID architecture which uses both data and error-correcting pages to improve reliability is ____________.

Accepted Answer

The answer of A dominant RAID architecture which uses both...

Question 8

One of the dominant RAID architectures,___________ involves a full mirror or redundant array of disks,on which each physical record is written to both arrays in parallel.

Accepted Answer

The answer of One of the dominant RAID architectures,___________ involves...

Question 9

In a ____________ index,the order of the data records is unrelated to the index order.

Accepted Answer

The answer of In a ____________ index,the order of the...

Question 10

The process of associating a query with an access plan is known as ____________________.

Accepted Answer

The answer of The process of associating a query with...

Question 11

A(n)________________ is a situation that occurs when a hash function assigns the same physical record address to more than one key in a file.

Accepted Answer

The answer of A(n)________________ is a situation that occurs when...

Question 12

A popular tree-shaped file structure used by many DBMSs that demonstrates good performance on both sequential searches and key searches is a(n)________________.

Accepted Answer

The answer of A popular tree-shaped file structure used by...

Question 13

List three characteristics of a Btree file structure that lend themselves to the possible meaning of the B in the name: _________________________

Accepted Answer

The answer of List three characteristics of a Btree file...

Question 14

In a ____________ index,the order of the data records is close to the index order.

Accepted Answer