Advanced DBMS (UGC/NET)
Description: DBMS | |
Number of Questions: 15 | |
Created by: Gagan Singh | |
Tags: DBMS Data Base Management Systems |
Which of the following normal forms in DBMS is the one in which a table contains no partial dependencies?
Which of the following terms in DBMS refers to the replacement of relation schema by two or more relational schemas, all of which contain a subset of the attributes of the relation?
Which of the following terms is defined as a set of rows that encode the changes made to a specific base table?
Which of the following operations in DBMS is the one in which data from the operand relations is read into the main memory and processed in some way out to the disk, and read again from the disk to complete the operation?
Which of the following forms of parallelism relates to the capacity to break up a query into various parts across various partitions of a partitioned database which may be on one single machine or several machines?
Which of the following tasks in Traditional Query Processing refers to selecting a plan to accomplish a query using available statistics?
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 DBMS software modules verify parse queries, DML retrieval statements and database update statements and also check the catalog to verify whether all the schema names referenced in these statements are valid?
Which of the following phases in locking scheduler is the one in which all locks are released by a transaction and one cannot attain any new lock?
Which of the following components of distributed database management system should be there with every data requesting workstation so as to receive and process the request for data, both local and remote?
Which of the following types of indexing requires that the ordering field of the data file have a distinct value for each record?
Which of the following components in E-R notation describes the entity to which it is associated and is particularly used to classify any entity?
Which of the following views in Three Schema Architecture is the information model of the enterprise and contains the view of the whole enterprise without any concern for the physical implementation?
Which of the following techniques used for denormalisation is the one in which the database table is split by rows, due to which the number of records per table will be reduced?
Which of the following losses in database refers to making objects non-available to a human user or a program to which they have a legitimate right?