Crowdly
Add to Chrome
DMBS.ig
Looking for DMBS.ig test answers and solutions? Browse our comprehensive collection of verified answers for DMBS.ig at moodle.cs.ubbcluj.ro.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Least Recently Used (LRU) is always a better replacement strategy for buffer pages compared to Most Recently Used (MRU)
0%
0%
View this question
Each edge of the precedence graph represents a transaction
0%
0%
View this question
The "phantom" problem is a situation where a transaction performs a query that returns a certain set of records, and then in another part of the transaction, the same query is run again and returns a different set of records due to inserts or deletions performed by another transaction between those two queries.
100%
0%
View this question
'HAVING' clause in SQL is used to filter records before any groupings are made
50%
50%
View this question
SQL queries can be nested within other queries.
100%
0%
View this question
The "ORDER BY" clause is used to sort the result set of a query in ascending order by default.
0%
0%
View this question
In Clustered B+ trees sorting, each data page is accessed only once.
0%
0%
View this question
A virtual machine instance can have sizes in the order of gigabytes or even terabytes
0%
0%
View this question
SQL Server Reporting Services (SSRS) is used for creating and deploying reports.
0%
0%
View this question
Transactions can never be rolled back to undo changes made if an error occurs during their execution.
0%
100%
View this question