DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q41
Which of the following statements are for relational database
  • A Data is represented in rows and columns
  • B The data is stored as B-tree
  • C Index and views are stored in Rows and Columns
  • D None
Answer: Option A
Q42
Find the valid DML statements
  • A Insert, Update, Erase
  • B Insert, Update, Modify
  • C Insert, Delete, Update
  • D None
Answer: Option C
Q43
Which are the following statements are true for primary key
  • A Primary key used for performing check constraints
  • B It can
  • C It can uniquely identify the row
  • D None
Answer: Option C
Q44
Which are the following statements are true for foreign key
  • A Foreign key used for performing check constraints
  • B It can
  • C It can uniquely identify the row
  • D Foreign key maps always to a valid primary key
Answer: Option D
Q45
One of the cause of the failure of file system
  • A Data availability
  • B Fixed records
  • C Sequential records
  • D Lack of security
Answer: Option D
Q46
Transaction control means
  • A Capability to manipulate the database
  • B Capability to commit or rollback
  • C Capability to change the structure of the table
  • D None
Answer: Option B
Q47
Data integrity means
  • A Column to maintain datatype specifies
  • B Column to maintain length
  • C Column to be not NULL
  • D Column to be unique
Answer: Option A
Q48
What is not a feature of Hierarchical model
  • A Child having a parent
  • B Parent having parent
  • C Parent may have any number of Childs
  • D Child having more than one parent
Answer: Option D
Q49
Oracle 8i Here
  • A Interface
  • B Interaction
  • C Internet
  • D none of the above
Answer: Option C
Q50
Locks can be applicable for __________
  • A views
  • B indices
  • C triggers
  • D All of the above
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test