Exam 8: Physical Database Design

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"._____________

Which of the following types of file is usually not provided by relational DBMS?

Chose the correct statement regarding memory access time and disk access time:

Which of the following is not an output of physical design?

One of the inputs to the physical database design is the _________________,which are statistics for each table such as the number of rows and unique column values.

Figuer: -Each node of the B-tree can contain at most 4 keys.To insert into the B-tree a record with key = 25,do the following:

Figuer: -Each node of the B-tree can contain at most 4 keys.After inserting into the B-tree a record with key = 62 and a record with key = 85,the B-tree will have the following number of nodes (including the root):

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.

A(n)____________ is a collection of physical records organized for efficient access.

The table EMPLOYEE with primary key = empno uses as hash function empno Mod 100, which gives the physical record number when applied to Empno. The linear probe procedure is used for collision handling. The physical records are created in the order of logical records (= rows) in the table, one physical record for one logical record EMPLOYEE Empno 2011 2012 2211 2311 2312 2313 2317 -To maintain the number of collisions at an adequate level without wasting too much storage,the ratio of used records to the total number of records should be as follows:

During the query optimization process,which phase analyzes your query to ensure that you have not violated language constraints (example: misspelled key words)or misused columns and tables (example: trying to compare columns with incompatible data types)?

During the query optimization process,which phase generates and evaluates access plans and chooses the access plan with the lowest cost?

The ideal Btree structure is wide,i.e.it has many arrows branching from each node,and short,i.e.it has a small number of levels between the root and leaf nodes.

Figuer: -The following operation should be performed in BB:

Which of the following is not true about the difficulty of index selection?

Query binding:

To improve the response time to access and change a database,consumption of all of the resources used by database processing should be minimized,including physical record transfers,main memory and disk space.

Figuer: -What programmer's or user's decision typically will affect the performance of the query?

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.

One of the inputs to the physical database design is the _________________,which are statistics for each form,report and query,such as the tables accessed/updated and the frequency of access/update.