What is a synonym in database terms? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Database Management System (DBMS) Questions
Question #1
Report Error
Any set of one or more attributes that collectively allow us to uniquely identify tuples in a relation is termed as a what?
Correct Answer: Option A
Explanation:
A Super Key is any set of attributes within a table that can uniquely identify a row. A candidate key is a minimal super key.
A Super Key is any set of attributes within a table that can uniquely identify a row. A candidate key is a minimal super key.
This question belongs to:
Computer
Database Management System (DBMS)
Question #2
Report Error
Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement?
Correct Answer: Option A
Explanation:
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.
This question belongs to:
Computer
Database Management System (DBMS)
Question #3
Report Error
Which of the following is a type of lock in a database?
Correct Answer: Option A
Explanation:
Shared locks allow multiple transactions to read a resource, while exclusive locks allow only one transaction to write.
Shared locks allow multiple transactions to read a resource, while exclusive locks allow only one transaction to write.
This question belongs to:
Computer
Database Management System (DBMS)
No comments yet. Be the first to start the discussion!