Home › Quizzes › Database Management Systems Fundamentals

Database Management Systems Fundamentals

Core concepts and architecture of database management systems including data models, transactions, SQL, and storage

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following levels of data abstraction describes what data is stored in the database and the relationship among those data?

  1. Physical level
  2. Logical level
  3. View level
  4. Extract level
  5. Input level
Question 2 Multiple Choice (Single Answer)

Which of the following data structures in DBMS stores the database itself?

  1. Data dictionary
  2. Indices
  3. Statistical data
  4. Data files
  5. DML compiler
Question 3 Multiple Choice (Single Answer)

Which of the following query processor components in DBMS converts DML statements embedded in an application program to normal procedure calls in the host language?

  1. DML compiler
  2. DDL interpreter
  3. Embedded DML precompiler
  4. Query evaluation engine
  5. Data dictionary
Question 4 Multiple Choice (Single Answer)

An entity in A is associated with at most one entity in B and an entity in B is associated with atmost one entity in A. This relationship is called which of the following?

  1. One to many
  2. One to one
  3. Many to one
  4. Many to many
  5. Everyone to many
Question 5 Multiple Choice (Single Answer)

Which of the following geometrical figures is used in an E-R diagram to denote derived attributes?

  1. Rectangles
  2. Ellipses
  3. Diamonds
  4. Dashed ellipses
  5. Lines
Question 6 Multiple Choice (Single Answer)

Which of the following forms of database is a text that is enriched with links that point to other documents?

  1. CASE database
  2. Multimedia database
  3. Hypertext database
  4. CAD database
  5. Office database
Question 7 Multiple Choice (Single Answer)

Which of the following commands in SQL is a predicate expressing a condition that we wish the database always to satisfy?

  1. Triggers
  2. Cursor
  3. Procedure
  4. Assertion
  5. Create Table
Question 8 Multiple Choice (Single Answer)

Which of the following data storage components in DBMS ensures that the database remains in a consistent state despite system failures, and that concurrent transaction executions proceed without conflicting?

  1. Authorisation and Integrity manager
  2. File manager
  3. Buffer manager
  4. Transaction manager
  5. Area manager
Question 9 Multiple Choice (Single Answer)

Which of the following file organisations is the one in which any record can be placed anywhere in the file where there is space for the record?

  1. Sequential file organisation
  2. Heap file organisation
  3. Hashing file organisation
  4. Clustering file organisation
  5. Index file organisation
Question 10 Multiple Choice (Single Answer)

The state after a transaction has been rolled back and the database has been restored to its state prior to the start of the transaction is which of the following?

  1. Commit
  2. Active
  3. Abort
  4. Failed
  5. Stop
Question 11 Multiple Choice (Single Answer)

Which of the following factors in the technique of indexing and hashing is the time taken to insert a new data item as well as the time it takes to update the index structure?

  1. Access types
  2. Insertion time
  3. Access time
  4. Deletion time
  5. Space overhead
Question 12 Multiple Choice (Single Answer)

Which of the following clauses of select command corresponds to the selection predicate of the relational algebra?

  1. Select
  2. From
  3. Where
  4. And
  5. Like
Question 13 Multiple Choice (Single Answer)

Which of the following levels of RAID technology in memory management consist of block-interleaved parity organisation that stores blocks just like in regular disks without striping them across disks?

  1. RAID level 0
  2. RAID level 1
  3. RAID level 4
  4. RAID level 2
  5. RAID level 3
Question 14 Multiple Choice (Single Answer)

In an Entity-Relationship structure if an attribute might have different number of values for the entity within the entity set then such attributes are called

  1. Simple attributes
  2. Multivalued attributes
  3. Null attributes
  4. Derived attributes
  5. Composite attributes
Question 15 Multiple Choice (Single Answer)

Which of the following data models in DBMS are used in describing data at the logical and view levels?

  1. E-R Model
  2. Object-Oriented Model
  3. Record-Based Logical Model
  4. Network Model
  5. Hierarchical Model
← Back to Quizzes