Database Concepts (UGC/NET)
Description: Database | |
Number of Questions: 15 | |
Created by: Trisha Prashad | |
Tags: Database Data Base Management Systems |
Which of the following program variables in DBMS software program is used to copy the current record from the buffer to a program variable in the user program?
Which of the following levels of RAID uses a single parity disk relying on the disk controller to give information about which disk has been failed?
Which of the following terms in parallel database refers to the total number of parallel execution servers for a single operation?
The type of join in relation algebra used to join a table to itself if the table were two tables and temporarily renaming at least one table in the SQL statement is called
Which of the following objects in relational data model is/are a basic unit of data consisting of rows and columns having name, datatype and width information specified at the time of creation?
Which of the following costs in query execution is the cost pertaining to the number of memory buffers needed during query execution?
Which of the following is a process of converting higher normal forms to lower normal forms with the objective of getting faster access to a database?
The situation in internal hashing when the hash field value of a record that is being inserted hashes to an address that already contains a different record is called
Which of the following types of characteristics for transaction recovery states that the transaction operations do not update the physical database instantly?
Which of the following terms in DBMS is considered as complex in multi-database systems due to the supposition of autonomy?
Which of the following approaches in OODBMS architecture is the one in which the client processes of OODBMS have an interaction with a network file service for reading and writing database pages?
Which of the following integrity constraints in database is also called attribute integrity that allows size values, right data type and null status, etc?
In which of the following phases in execution of transaction is the serialisability of the schedule verified by contrasting read and write sets of transactions to the read/write sets of simultaneous transactions?
Which of the following locks in DBMS are also known as row-level locks where the client uses the row by means of the SELECT FOR UPDATE statement?
Which of the following terms in OODBMS is considered as the unit of transfer from server to client?