Questions
The ____________ data model in DBMS makes use of a set of tables to show data as well as the relationship between the data.
- hierarchical
- relational
- network
- distributed
- IMS
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?
- Vertical fragmentation
- Horizontal partitioning
- Summary data
- Duplicate data
- Functional dependency
Which of the following transparencies in distributed DBMS permits a transaction to be executed either completely or not at all?
- Distribution
- Transaction
- Failure
- Heterogeneity
- Homogeneity
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?
- Object database
- Dimensional
- Post-relational database
- Network data
- Hierarchical data
Which of the following operations on database can be acquired by dividing a table into a number of sub-tables having disjointed columns?
- Mixed fragmentation
- Horizontal fragmentation
- Vertical fragmentation
- Data processor
- Distributed data storage
_____________ is a condition in a relation where an attribute is functionally dependent on another non-key attribute.
- Denormalisation
- Normalisation
- Schema
- Transitive dependency
- BCNF
Which of the following languages is a standard relational database language used for creation, deletion and modification of database tables?
- DML
- DDL
- SQL
- QBE
- ISBL
______________ 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.
- Atomicity
- Consistency
- Isolation
- Durability
- Reliability
In which of the following do two or more replicas sync with each other via a transaction identifier?
- Multimaster
- Master/Slave replication
- Quorum
- Primary key
- Foreign key
In which of the following transaction control commands in SQL is every change performed since the preceding COMMIT statement rejected?
- SELECT
- UPDATE
- ROLLBACK
- COMMIT
- DROP
In which of the following locks in DBMS is only one user permitted to update a specific part of data?
- Shared locks
- Update locks
- Exclusive locks
- Upgrading locks
- Increment locks
______________ normal form in database system states that the left hand side of every non-trivial function or multi-valued dependency is a super key.
- 1 NF
- 2 NF
- 3 NF
- BCNF
- 4 NF
In which of the following classes in parallel machines does every processor have its own memory not accessible directly from other processors?
- Shared memory
- Shared disk
- Shared nothing
- Cache memory
- Shared everything
__________ 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.
- Table scan
- Two-pass algorithm
- Data redundancy
- Shared disk
- NUMA