DBMS MCQ Question and Answer

DBMS MCQ Question and Answer
41. Which of the following statements are for relational database
  • Data is represented in rows and columns
  • The data is stored as B-tree
  • Index and views are stored in Rows and Columns
  • None
Show Answer
42. Find the valid DML statements
  • Insert, Update, Erase
  • Insert, Update, Modify
  • Insert, Delete, Update
  • None
Show Answer
43. Which are the following statements are true for primary key
  • Primary key used for performing check constraints
  • It can
  • It can uniquely identify the row
  • None
Show Answer
44. Which are the following statements are true for foreign key
  • Foreign key used for performing check constraints
  • It can
  • It can uniquely identify the row
  • Foreign key maps always to a valid primary key
Show Answer
45. One of the cause of the failure of file system
  • Data availability
  • Fixed records
  • Sequential records
  • Lack of security
Show Answer
46. Transaction control means
  • Capability to manipulate the database
  • Capability to commit or rollback
  • Capability to change the structure of the table
  • None
Show Answer
47. Data integrity means
  • Column to maintain datatype specifies
  • Column to maintain length
  • Column to be not NULL
  • Column to be unique
Show Answer
48. What is not a feature of Hierarchical model
  • Child having a parent
  • Parent having parent
  • Parent may have any number of Childs
  • Child having more than one parent
Show Answer
49. Oracle 8i Here
  • Interface
  • Interaction
  • Internet
  • none of the above
Show Answer
50. Locks can be applicable for __________
  • views
  • indices
  • triggers
  • All of the above
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test