Database Concepts (UGC/NET)
Comprehensive quiz covering database management system concepts including normalization, transactions, parallel processing, OODBMS, and integrity constraints for UGC/NET exam preparation
Questions
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?
- Open
- Reset
- Find
- Read
- Delete
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?
- RAID level 0
- RAID level 2
- RAID level 1
- RAID level 3
- RAID level 4
Which of the following terms in parallel database refers to the total number of parallel execution servers for a single operation?
- Intra-query parallelism
- Shared disk architecture
- Degree of parallelism
- Range partitioning
- Data partitioning
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
- inner join
- left join
- full join
- self join
- cartesian join
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?
- Views
- Synonyms
- Tables
- Sequence
- Indices
Which of the following costs in query execution is the cost pertaining to the number of memory buffers needed during query execution?
- Memory usage cost
- Storage cost
- Computation cost
- Communication cost
- Access cost
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?
- Normalisation
- Denormalisation
- Horizontal fragmentation
- Partial dependency
- BCNF
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
- open addressing
- chaining
- multiple hashing
- collision
- address space
Which of the following types of characteristics for transaction recovery states that the transaction operations do not update the physical database instantly?
- Deferred update
- Write ahead protocol
- Write-through
- Database buffers
- Cascading rollback
Which of the following terms in DBMS is considered as complex in multi-database systems due to the supposition of autonomy?
- Work flow systems
- Global read protocol
- Transaction management
- Local read protocol
- Recoverability
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?
- File server approach
- Page server approach
- Object server approach
- Distributed Client-Server approach
- Object clustering
Which of the following integrity constraints in database is also called attribute integrity that allows size values, right data type and null status, etc?
- Referential integrity
- Domain integrity
- Entity integrity
- Trigger
- DDL
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?
- Read
- Write
- Validate
- Start
- Fin
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?
- Exclusive locks
- Update locks
- Shared locks
- Upgrading locks
- Increment locks
Which of the following terms in OODBMS is considered as the unit of transfer from server to client?
- Class
- Attributes
- Object
- Inheritance
- Encapsulation