RDBMS

RDBMS

15 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following databases in RDBMS contains data assisting needs of middle management to monitor and control business activities by effective and efficient management of men, machines and money?

  1. Strategic planning database
  2. Control database
  3. Operational database
  4. Single global database
  5. Storage database
Question 2 Multiple Choice (Single Answer)

Which of the following modules in transaction model moves data between memory and disk using some page replacement policy?

  1. Recovery manager
  2. Scheduler
  3. Buffer manager
  4. Transaction manager
  5. Area manager
Question 3 Multiple Choice (Single Answer)

Which of the following approaches in database design starts with enterprise level model preparing data model for the entire application domain?

  1. Bottom-up approach
  2. Top-down approach
  3. Multiple database approach
  4. Step-down approach
  5. Project approach
Question 4 Multiple Choice (Single Answer)

Which of the following forms of indexes in index sequential files contains one anchor per cylinder and is stored in separate areas?

  1. Track index
  2. Cylinder index
  3. Master index
  4. Cluster index
  5. Primary index
Question 5 Multiple Choice (Single Answer)

Which of the following HDBMS (Hierarchical DBMS) modules processes HSQL query statement and translates them into intermediate tree representation containing algebraic operations?

  1. Terminal interface
  2. Schema processor
  3. Query processor
  4. Query optimiser and Access planner
  5. Query Execution module
Question 6 Multiple Choice (Single Answer)

Which of the following utilities of DBMS refers to dumping entire database on tapes for recovery from media failures, may be online or offline?

  1. Loading
  2. Performance monitoring
  3. File reorganisation
  4. Backup
  5. Schema
Question 7 Multiple Choice (Single Answer)

Which of the following structures of the database consists of datafiles, redo log files and control files?

  1. Database block
  2. Extent
  3. Segment
  4. Physical structure
  5. Schema
Question 8 Multiple Choice (Single Answer)

Which of the following parameters in evaluating performance of a file organisation specifies what percentage of records are added, modified and deleted over a period of time?

  1. Hit ratio
  2. Access keys
  3. Volatility
  4. Frequency
  5. Response time
Question 9 Multiple Choice (Single Answer)

Which of the following objects in Oracle is a set of tables and views that are used as a read only reference about the database?

  1. Tuple
  2. Cardinality
  3. Data dictionary
  4. Schema
  5. Member methods
Question 10 Multiple Choice (Single Answer)

Which of the following operators in relational algebra, selects a subset of tuples of the relation that satisfy a select condition?

  1. Project
  2. Select
  3. Cartesian product
  4. Join
  5. Divide
Question 11 Multiple Choice (Single Answer)

Which of the following forms of normalisation states that non-key attributes are functionally dependent on the key attributes?

  1. 1 NF
  2. 2 NF
  3. 3 NF
  4. BCNF
  5. 5 NF
Question 12 Multiple Choice (Single Answer)

Which of the following forms of data integrity refers to the range of valid entries for a given column?

  1. Referential integrity
  2. Entity integrity
  3. Domain integrity
  4. Select
  5. Semi-Join
Question 13 Multiple Choice (Single Answer)

Which of the following files in physical data organisation of data storage devices holds instances of many different record types?

  1. Homogeneous file
  2. Master file
  3. Non-Homogeneous file
  4. Transaction file
  5. Reference file
Question 14 Multiple Choice (Single Answer)

Which of the following layer decomposes the distributed calculus query into an algebraic query on global relations?

  1. Data localisation
  2. Global query optimisation
  3. Query decomposition
  4. Local query optimisation
  5. Query processor
Question 15 Multiple Choice (Single Answer)

Which of the following method is used to store varying length records in the database which allocate maximum length required by a field and use spaces/null for shorter values?

  1. Using pointers
  2. Combined method
  3. Reserved space
  4. B-Tree
  5. Chaining method