DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q81
When using the multiple table to query information , in which clause we specify the names of tables
  • A having
  • B grouping
  • C where
  • D from
Answer: Option D
Q82
With out any join condition the join becomes
  • A eqi join
  • B self join
  • C outer join
  • D Cartesian join
Answer: Option D
Q83
The query given bellow is SELECT E.ENAME=
  • A inner join
  • B outer join
  • C self join
  • D none
Answer: Option C
Q84
The operator which can hold multiple values is
  • A IN
  • B =
  • C >
  • D <
Answer: Option A
Q85
The advantages that using the aliases are
  • A It can used to refer the table
  • B It effectively improve the query performance
  • C It allows to join two tables
  • D None of these
Answer: Option B
Q86
What is true regarding the co-related sub queries
  • A Execution is slow when compared to nested queries
  • B First the outer query and next the inner query executed
  • C Based on inner query result the outer query executes
  • D None of the above
Answer: Option C
Q87
If we delete the record from the table DEPT is
  • A Delete records for the table DEPT
  • B Delete the record from both tables
  • C Referential integrity error occurs
  • D All the above
Answer: Option C
Q88
A person
  • A Record
  • B Database
  • C Byte
  • D Entity
Answer: Option D
Q89
Collectively, a course number, course title, and course description would be called
  • A record
  • B field
  • C file
  • D database
Answer: Option A
Q90
A group of related files makes up
  • A master file
  • B database
  • C entity
  • D attribute
Answer: Option B

📚 More from Database

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