Exam 8: Physical Database Design

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

Query binding indicates how to implement a query as operations on a file.

In the processing of an SQL statement by the DBMS,a parsed query is the output of the code generation task.

Physical records are synonymous to blocks or pages.

An index on a combination of columns is just as flexible as multiple indexes on the individual columns,so either choice would be appropriate.

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

In a Btree structure,the height of the tree determines the number of physical record accesses required to locate a particular key,with the cost of access being less than or equal to the height.

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

______________ is a collection of disks that operates as a single disk.

Figuer: -The restriction operation for RENTALS.PICKUP = 'ERIE' OR RENTALS.PICKUP = 'CARY' Should be performed:

In RAID technology,striping involves the allocation of logical records to different disks.

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

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 retrieve logical record 2312,how many physical records will need to be accessed?

Which of the following is used in establishing table profiles?

A bitmap join index is actually a precomputed join from a column in a parent table to the rows of the child table that join with rows of the parent table.

A database consists of the tables STUDENT (PK = sno, sname, major), COURSE (PK = cno, major, ), OFFERINGS (PK = cno and ofno, ), ENROLLMENT (sno, cno, ofno, grade). All tables satisfy BCNF. Overall_gpa and gpa_in_major are computed for each student. -Which of the following statements is not true when having overall_gpa and gpa_in_major as attributes of the STUDENT table?