Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q511: What is the most commonly used form of merging two tables in a database?
- A: Cartesian product
- B: Join
- C: Self join
- D: Subquery
View Answer
B
Q512: In an Inner Join, rows from two tables are joined based on:
- A: The same primary key
- B: The same table
- C: A common attribute with the same value
- D: Different data types
View Answer
C
Q513: In SQL, which command is used to grant privileges to users?
- A: GRANT
- B: REVOKE
- C: INSERT
- D: SELECT
View Answer
A
Q514: In a Right Outer Join, rows from which table appear in the result even if there is no match?
- A: The left table
- B: The right table
- C: Both tables
- D: None
View Answer
B
Q515: The common attribute in Inner Join must have the same _______ in both tables.
- A: Name
- B: Domain
- C: Size
- D: Primary Key
View Answer
B
Q516: A semi join allows you to:
- A: Know the matching rows of both tables
- B: Know the rows of one table involved
- C: Know the PK of both tables
- D: Perform outer join
View Answer
B
Q517: In a Full Outer Join, rows without a match from both tables ______.
- A: Appear once
- B: Are discarded
- C: Are repeated
- D: Are excluded
View Answer
A
Q518: In a self join, a table is joined with _______.
- A: Another table
- B: Itself
- C: The parent table
- D: A child table
View Answer
B
Q519: Which command is used to withdraw privileges from a user in SQL?
- A: SELECT
- B: REVOKE
- C: GRANT
- D: DELETE
View Answer
B
Q520: What SQL command would you use to display all records where the cgpa is higher than the highest cgpa in the BCS program?
- A: SELECT * FROM student WHERE cgpa >
- B: SELECT MAX(cgpa) FROM student
- C: SELECT * FROM student WHERE prName =
- D: SELECT * FROM program WHERE cgpa =
View Answer
A