Which normal form requires that all attributes in a table contain only atomic, indivisible values, and prohibits multi-valued attributes? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
What type of join produces a Cartesian product, matching every single row of the first table with every single row of the second table?
Correct Answer: Option B
Explanation:
A Cross Join returns the Cartesian product of the two tables, multiplying the total number of rows from the first table by the number of rows in the second table.
A Cross Join returns the Cartesian product of the two tables, multiplying the total number of rows from the first table by the number of rows in the second table.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
What is a subquery in database terminology?
Correct Answer: Option A
Explanation:
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the purpose of the SQL 'CASE' statement?
Correct Answer: Option A
Explanation:
CASE allows for conditional expressions, similar to IF-THEN-ELSE, within SQL statements.
CASE allows for conditional expressions, similar to IF-THEN-ELSE, within SQL statements.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!