Home › Quizzes › DBMS

DBMS

these questions are very useful for public sector exams like gail bel sail etc

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

In relational model, a tuple is equivalent to _________.

  1. record
  2. field
  3. file
  4. database
  5. table
Question 2 Multiple Choice (Single Answer)

Which of the following is/are the main objective(s) of database systems?

  1. To eliminate data redundancy
  2. To establish relationship between files
  3. To manage file access
  4. To make data access complex
  5. Only 1, 3 and 4
Question 3 Multiple Choice (Single Answer)

In which of the following data types are addresses considered?

  1. Numeric field
  2. Data field
  3. Relational field
  4. Alpha numeric
  5. Only 1 and 4
Question 4 Multiple Choice (Single Answer)

Managers salary is hidden from the employee. Which of the following options better explain(s) this?

  1. Conceptual level data hiding
  2. Physical level data hiding
  3. External level data hiding
  4. Only 1 and 3
  5. Logical level data hiding
Question 5 Multiple Choice (Single Answer)

A database environment has all of the following, except:

  1. Users
  2. Tables
  3. Database
  4. Separate files
  5. Data
Question 6 Multiple Choice (Single Answer)

Relations from ER model will always be in

  1. 1 NF
  2. 2 NF
  3. 3 NF
  4. BC NF
  5. 4 NF
Question 7 Multiple Choice (Single Answer)

What does 'A' stand for in acid properties?

  1. Abort
  2. Alike
  3. Atomic
  4. Attribute
  5. Action
Question 8 Multiple Choice (Single Answer)

Which of the following describes a logical schema?

  1. Entire database
  2. Organising data
  3. Storing of data on disk
  4. Revising the file structure
  5. Shows only user specific data
Question 9 Multiple Choice (Single Answer)

What is/are the properties of sequential file organisation?

  1. A pointer points to the next record in order.
  2. Indexes are required to represent stored records.
  3. A tree structure is used to represent multi level index.
  4. If the order is lost, the file has to be re-organised.
  5. Only 1 and 4.
Question 10 Multiple Choice (Single Answer)

A functional dependency x- > y is trivial, if _______________.

  1. y is a subset of x
  2. y is a proper subset of x
  3. x is a subset of y
  4. x is a proper subset of y
  5. only 1 and 2
Question 11 Multiple Choice (Single Answer)

A transparent DBMS ___________.

  1. cannot hide sensitive data
  2. keeps its logical structure hidden
  3. keeps its physical structure hidden
  4. can hide sensitive data
  5. is highly safe
Question 12 Multiple Choice (Single Answer)

A network structure represents

  1. physical structure of data
  2. many to many relationship
  3. logical representation of data
  4. a database of future
  5. designing of database
Question 13 Multiple Choice (Single Answer)

Which of the following is/are concurrency control mechanism(s)?

  1. Optimistic
  2. Pessimistic
  3. Commit
  4. Alter
  5. Only (1) and (2)
Question 14 Multiple Choice (Single Answer)

What does an ellipse represent in E R model?

  1. Entity set
  2. Attribute
  3. Relationship
  4. Derived attribute
  5. Primary key
Question 15 Multiple Choice (Single Answer)

What is/are the type(s) of DML?

  1. Procedural
  2. Relational
  3. Network model
  4. Non-procedural
  5. Only 1 and 4
← Back to Quizzes