22.

23.

24.

25.

26.

27.

Which of the following is false?

(A)
(0)
(0

(0)

Ensuring durability is the responsibility of recovery management component
Ensuring Isolation is the responsibility of concurrency management

Ensuring atomicity and consistency is the responsibility of recovery management
component

None of the above

SQL Server allows for Transact-SQL stored procedures, triggers, and batches to refer to
tables that don’t exist at compile time. This ability is called

(A)
(0

Deferred Name Resolution (B) Deferred Name Permissions

ndeferred Name Resolution ൯) 1706161706 Name Permissions

Which-one of the following statements about normal forms is FALSE?

(A)
(0)
(0
(0)

BCNF is a stronger form of normalization than 3NF

Loss less, dependency — preserving decomposition into BCNF is always possible
Lossless, dependency — preserving decomposition into 3 NF is always possible
Any relation with two attributes is BCNF

Which of the following is false?

(A)
(0)
(0
(0)

B+ tree is used to store data in secondary memory
B + tree is having the same performance as that of indexed sequential file
B+ tree allows rapid random access as well as rapid sequential access

B + tree is a balanced tree

Which of the following statements are True

@

൬
(ii)
(11)
(A)
(0

GIS deals with spatial data spatial data
Barometric pressure is a geographic field

Ramanujan space is related to GIS

Tessellations partition the study space into cells and assign a value to each cell
(i), Gi) and (iii) (B) (ii), (iii) and (iv)
(i), 61) and (iv) (D) (0, Gi) and (iv)

CAP theorem in NoSQL stands for

(A)
(0)

Consistency, Availability, Partition tolerance
Concurrency, Availability, Partition
Consistency, Accuracy, Precision
Concurrency, Atomicity, Partition tolerance

7 098/2022
[P.T.0.]