DBMS MCQ Question and Answer

DBMS MCQ Question and Answer
81. When using the multiple table to query information , in which clause we specify the names of tables
  • having
  • grouping
  • where
  • from
Show Answer
82. With out any join condition the join becomes
  • eqi join
  • self join
  • outer join
  • Cartesian join
Show Answer
83. The query given bellow is SELECT E.ENAME=
  • inner join
  • outer join
  • self join
  • none
Show Answer
84. The operator which can hold multiple values is
  • IN
  • =
  • >
  • <
Show Answer
85. The advantages that using the aliases are
  • It can used to refer the table
  • It effectively improve the query performance
  • It allows to join two tables
  • None of these
Show Answer
86. What is true regarding the co-related sub queries
  • Execution is slow when compared to nested queries
  • First the outer query and next the inner query executed
  • Based on inner query result the outer query executes
  • None of the above
Show Answer
87. If we delete the record from the table DEPT is
  • Delete records for the table DEPT
  • Delete the record from both tables
  • Referential integrity error occurs
  • All the above
Show Answer
88. A person
  • Record
  • Database
  • Byte
  • Entity
Show Answer
89. Collectively, a course number, course title, and course description would be called
  • record
  • field
  • file
  • database
Show Answer
90. A group of related files makes up
  • master file
  • database
  • entity
  • attribute
Show Answer
Database
Questions and Answers for Competitive Exams Various Entrance Test