Database MCQ Questions

Post A Question

Classifications:

MCQ Questions Categories:

No collections found!

Constraint checking can be disabled in existing _______________ and _____________ constraints so that any data you modify or add to the table is not checked against the constraint
iconmhmadesk
2022-07-19
icon 1 answers
icon444 Views
icon0 Likes
Isolation of the transactions is ensured by
iconmhmadesk
2022-07-19
icon 1 answers
icon492 Views
icon0 Likes
SNAPSHOT is used for (DBA)
iconmhmadesk
2022-07-19
icon 1 answers
icon548 Views
icon0 Likes
Which of the following is not a property of transactions
iconmhmadesk
2022-07-19
icon 1 answers
icon529 Views
icon0 Likes
What would be the outcome of the below query?
iconmhmadesk
2022-07-19
icon 1 answers
icon557 Views
icon0 Likes
Evaluate the following SQL statements in the given order
iconmhmadesk
2022-07-19
icon 1 answers
icon496 Views
icon0 Likes
A non-correlated subquery can be defined as ______
iconmhmadesk
2022-07-19
icon 1 answers
icon420 Views
icon0 Likes
Which statement is true regarding external tables
iconmhmadesk
2022-07-19
icon 1 answers
icon448 Views
icon0 Likes
In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?
iconmhmadesk
2022-07-19
icon 1 answers
icon456 Views
icon0 Likes
EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in relation to the EMPDET table?
iconmhmadesk
2022-07-19
icon 1 answers
icon378 Views
icon0 Likes
__________ are used to ensure that transactions access each data item in order of the transactions’ ____ if their accesses conflict
iconmhmadesk
2022-07-19
icon 1 answers
icon816 Views
icon0 Likes
A concurrency-control policy such as this one leads to ______ performance, since it forces transactions to wait for preceding transactions to finish before they can start
iconmhmadesk
2022-07-19
icon 1 answers
icon337 Views
icon0 Likes
In concurrency control policy the the lock is obtained on
iconmhmadesk
2022-07-19
icon 1 answers
icon395 Views
icon0 Likes
Show More