Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q521: In which type of outer join do rows from the left table without a match appear in the result?
- A: Right Outer Join
- B: Left Outer Join
- C: Full Outer Join
- D: Inner Join
View Answer
B
Q522: The privilege to update a specific column in SQL can be granted using which keyword?
- A: INSERT(column-name)
- B: UPDATE(column-name)
- C: REFERENCES
- D: GRANT(column-name)
View Answer
B
Q523: The REVOKE command with the CASCADE keyword:
- A: Revokes privileges for all users
- B: Revokes privileges granted by the user
- C: Grants privileges to a role
- D: Grants privileges back to the owner
View Answer
B
Q524: What is the result of a self join operation on the same table with a common attribute?
- A: Duplicate rows
- B: Joins the same table
- C: Merges different columns
- D: Creates duplicate tables
View Answer
B
Q525: The SQL command to implement a semi join is:
- A: SELECT * FROM COURSE, PROGRAM
- B: SELECT distinct p.prName FROM program
- C: INSERT * FROM COURSE
- D: DELETE * FROM PROGRAM
View Answer
B
Q526: Which of the following is a valid example of an Inner Join in SQL?
- A: SELECT * FROM course
- B: SELECT * FROM COURSE INNER JOIN
- C: DELETE * FROM COURSE
- D: GRANT * FROM COURSE
View Answer
B
Q527: Fill in the blank: A nested query is also called a _______ in SQL.
- A: Semi join
- B: Subquery
- C: Self join
- D: Right join
View Answer
B
Q528: What is the goal of conceptual database design?
- A: To provide data storage
- B: To analyze the application
- C: To create SQL queries
- D: To define hardware requirements
View Answer
B
Q529: Which of the following is stored in tables in a relational database?
- A: All data
- B: User interface
- C: Form design
- D: User input
View Answer
A
Q530: What tool is being used for data manipulation language in the lecture?
- A: MySQL
- B: Oracle
- C: SQL Server
- D: PostgreSQL
View Answer
C