The ____________ data model in DBMS makes use of a set of tables to show data as well as the relationship between the data.

Which of the following techniques is used for denormalisation in which the records are summarised in some summary columns and the number of records stored in a table is reduced?

Which of the following transparencies in distributed DBMS permits a transaction to be executed either completely or not at all?

Which of the following models is a specialised adaption of the relational model used to represent data in a data warehouse in a way that data can be easily summarised using OLAP queries?

Which of the following operations on database can be acquired by dividing a table into a number of sub-tables having disjointed columns?

_____________ is a condition in a relation where an attribute is functionally dependent on another non-key attribute.

Which of the following languages is a standard relational database language used for creation, deletion and modification of database tables?

______________ rule followed by database software states that two simultaneous transactions cannot interfere with one another and intermediate results within a transaction are not visible to other transactions.

In which of the following do two or more replicas sync with each other via a transaction identifier?

Which of the following is a markup language that defines a set of rules for encoding documents in a format that is both human readable and machine readable?

In which of the following transaction control commands in SQL is every change performed since the preceding COMMIT statement rejected?

In which of the following locks in DBMS is only one user permitted to update a specific part of data?

______________ normal form in database system states that the left hand side of every non-trivial function or multi-valued dependency is a super key.

In which of the following classes in parallel machines does every processor have its own memory not accessible directly from other processors?

__________ is an operation in which data from the operand relations is read into main memory and processed data is read again from the disk to complete the operation.