Questions
Which of the following normal forms in DBMS is the one in which a table contains no partial dependencies?
- 1NF
- 2NF
- 3NF
- 4NF
- BCNF
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?
- Redundancy
- Decomposition
- Update anomalies
- Normalisation
- Functional dependency
Which of the following terms is defined as a set of rows that encode the changes made to a specific base table?
- Query tree
- Delta stream
- Greedy algorithm
- Query optimisation
- Mobile database system
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?
- NUMA
- Scanning tables
- Shared disk
- Two-pass alogorithm
- Table scan
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?
- Inter-partition parallelism
- Intra-partition parallelism
- Shared nothing architecture
- Degree of parallelism
- Parallel I/O
Which of the following tasks in Traditional Query Processing refers to selecting a plan to accomplish a query using available statistics?
- Execution
- Statistics tracking
- Optimisation
- Ripple join
- Eddy
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?
- Object server approach
- Page server approach
- File server approach
- Object clustering
- Heterogeneous operation
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?
- DDL compilers
- Query and DML compilers
- Query and DML optimiser
- Authorisation and security checking
- Query and DML parser
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?
- Growing phase
- Shrinking phase
- Commit phase
- Update lock
- Increment 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?
- Workstations
- Network hardware and software
- Data processor
- Transaction processor
- Replicated data management
Which of the following types of indexing requires that the ordering field of the data file have a distinct value for each record?
- Primary index
- Clustering index
- Secondary index
- Multilevel index
- Dense index
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?
- Relationship
- Entity
- Cardinality
- Attribute
- Degree
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?
- External view
- Conceptual view
- Internal view
- Physical view
- Users view
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?
- Duplicate data
- Summary data
- Horizontal partitioning
- Vertical fragmentation
- Normalisation
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?
- Loss of integrity
- Loss of availability
- Loss of confidentiality
- Loss of data
- Loss of information