Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 31
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
Correct Answer:
B
Chapter: 31
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)
Correct Answer:
B
Chapter: 31
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
Correct Answer:
B
Chapter: 31
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
Correct Answer:
B
Chapter: 31
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
Correct Answer:
B
Chapter: 31
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
Correct Answer:
B
Chapter: 31
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
Correct Answer:
B
Chapter: 32
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
Correct Answer:
B
Chapter: 32
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
Correct Answer:
A
Chapter: 32
Q530:
What tool is being used for data manipulation language in the lecture?
A. MySQL
B. Oracle
C. SQL Server
D. PostgreSQL
Correct Answer:
C
Chapter: 32
Q531:
Application programs are written to perform tasks for whom?
A. Developers
B. Organizations
C. External clients
D. Marketing teams
Correct Answer:
B
Chapter: 32
Q532:
What is an effective user interface expected to do?
A. Help users accomplish tasks
B. Increase server performance
C. Minimize code errors
D. Reduce the database size
Correct Answer:
A
Chapter: 32
Q533:
What are the two main types of user interfaces?
A. Text-based and CLI
B. Text-based and GUI
C. CLI and Graphical
D. Web-based and CLI
Correct Answer:
B
Chapter: 32
Q534:
Which of the following is NOT a user interface type mentioned?
A. Graphical User Interface (GUI)
B. Command Line Interface (CLI)
C. Text-based Interface
D. Mobile App Interface
Correct Answer:
D
Chapter: 32
Q535:
Forms are most commonly associated with which type of interface?
A. Command Line
B. Text-based
C. Graphical User Interface (GUI)
D. None of the above
Correct Answer:
C
Chapter: 32
Q536:
What is an example of a form used in web-based applications?
A. Non-browser form
B. HTML-based form
C. Command-based form
D. CLI-based form
Correct Answer:
B
Chapter: 32
Q537:
Which of the following is a key characteristic of an effective interface?
A. Forces users to adapt
B. Matches users' work processes
C. Requires frequent training
D. Increases the complexity
Correct Answer:
B
Chapter: 32
Q538:
What type of users appreciate keyboard shortcuts the most?
A. Beginners
B. Intermediate users
C. Experts
D. Developers
Correct Answer:
C
Chapter: 32
Q539:
Which users are most likely to use the index in online help?
A. Beginners
B. Intermediate users
C. Experts
D. Administrators
Correct Answer:
B
Chapter: 32
Q540:
What is a benefit of user-friendly interfaces in a system?
A. Reduces the need for documentation
B. Reduces database size
C. Increases SQL query speed
D. Adds complexity to the system
Correct Answer:
A