Meta Data is termed as data about data.

DML means Data Manipulation Language, is used to specify database updates and retrievals like INSERT, SELECT, UPDATE and more.

Sometimes due to the overflow, it causes split in B-tree.

We can also call a view a virtual table because view is a personalized and customized collection of relation formed by using view. View secures the original table and provides us an user requirement table view.

Having is used along with GROUP BY clause to define a condition on the group.

Conspiracy is not an (ACID) property of transaction. The valid properties of transaction are represented in the form of ACID, i.e.

Relational model has inter-related records. In this model, records have relationships.

Relational Algebra is a procedural query language because it describes the procedure to obtain the output and result.

Read only does not allow insert , alter and delete once the transaction is completed, so no modification is made.

OBE is called as Oracle By Example or Query By Example in which query is explained step by step.

The correct answer is Directed Graph, because directed graph favours concurrency control and recovery schema.

Starvation in database is called as poor constructed database, as well as a transaction which never completes its given task. 

It is used for data modification purpose, therefore it is used to maintain the serializability.

Oval represents attribute.

In this, index entry is not created for every value. Each index entry contains a search-key and a pointer to the first record with that search-key value.

There should be wait condition with a cycle. The existence of cycle in wait for graph has a cycle.

 The recovery from transaction failure is done by shadow paging.

Diamond shows relationships.

Savepoint, commit, rollback, set transaction are TCL statements meaning Transaction Control statements which are used to manage the changes made by DML statements.  Savepoint , commit , rollback , set transaction are TCL statements meaning Transaction Control statements which are used to manage the changes made by DML statements. finally 5 option is correct.

Transaction has two phase locking - Growing phase and Shrinking phase. So, this is correct.

With concurrency control, we can restrict the number of possible scheduling.

After deletion, the record is permanently deleted using pack command.

Dense index is an entry which contains the search key and a pointer in the first data record with that search key value.

Union operation eliminates all duplicates from tables just like in set theory UNION.

Rollback is a TCL statement which is used to resolve the problems of Dead lock and recovery of transaction.