Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which of the following is not a type of database model?
Correct Answer: Option D
Explanation:
Flat-file is not a database model; it is a simple file containing records. Hierarchical, Network, Relational, and Object-oriented are database models.
Flat-file is not a database model; it is a simple file containing records. Hierarchical, Network, Relational, and Object-oriented are database models.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which of the following is a valid way to join three tables in SQL?
Correct Answer: Option B
Explanation:
Both syntaxes are valid: explicit JOIN syntax and implicit comma join with WHERE conditions.
Both syntaxes are valid: explicit JOIN syntax and implicit comma join with WHERE conditions.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the difference between an inner join and an outer join?
Correct Answer: Option A
Explanation:
Inner join returns rows where the join condition matches. Outer join (left, right, full) returns unmatched rows as well with NULLs.
Inner join returns rows where the join condition matches. Outer join (left, right, full) returns unmatched rows as well with NULLs.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!