Which wildcard character is used with the SQL LIKE operator to represent zero, one, or multiple characters? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Which type of JOIN combines all rows from the left table and all rows from the right table, filling in NULLs wherever a match is missing on either side?
Correct Answer: Option D
Explanation:
A Full Outer Join combines the behavior of both Left and Right Outer Joins, returning all rows from both tables and applying NULL values where matches do not exist.
A Full Outer Join combines the behavior of both Left and Right Outer Joins, returning all rows from both tables and applying NULL values where matches do not exist.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
To be in Second Normal Form (2NF), a relation must already satisfy First Normal Form (1NF) and must completely eliminate what type of dependency?
Correct Answer: Option B
Explanation:
Second Normal Form (2NF) requires that the table is in 1NF and that no non-prime attribute is partially dependent on any candidate key (meaning no partial dependency exists).
Second Normal Form (2NF) requires that the table is in 1NF and that no non-prime attribute is partially dependent on any candidate key (meaning no partial dependency exists).
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
What is the purpose of the SQL 'DEFAULT' constraint?
Correct Answer: Option C
Explanation:
DEFAULT assigns a default value to a column if an INSERT statement does not specify a value.
DEFAULT assigns a default value to a column if an INSERT statement does not specify a value.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!