Advanced DBMS
Advanced topics in Database Management Systems including data models, SQL optimization, transactions, recovery, and data warehousing concepts.
Questions
DBMS permits each record to be comprised of numerous records of parent as well as child thus generating a network structure is
- hierarchical model
- network model
- relational model
- object-relational model
- object model
Which of the following objects in DBMS is a conceptual representation that captivates the relations' real meaning with the data items?
- Database client
- Database server
- Database
- Data model
- CODASYL
Which of the following advantages in Object-Relational databases allows to utilize the relationships among data so as to gather related records effortlessly?
- Flexibility
- Reusability
- Managing relationships
- Abstraction
- Cost
Which of the following languages is used in SQL to define the structure of the table?
- DML
- DDL
- Assembly language
- Low level language
- High level language
Which of the following methodologies is used to optimize a group of SQL queries altogether with the help of common sub-expressions to save cost and time?
- Greedy algorithm
- Mobile database system
- Multi-query optimisation
- Query tree
- Join operation
Which of the following techniques used for denormalization is the one in which the database table is split by rows?
- Duplicate data
- Summary data
- Horizontal partitioning
- Vertical fragmentation
- Primary key
_________ occurs in DBMS when inconsistencies arise due to the removal of record from a relation.
- Modification anomaly
- Insertion anomaly
- Deletion anomaly
- Update anomaly
- Exit anomaly
Which of the following tasks performed by transaction manager has the liability to interfere and terminate one or more transactions to allow others to continue?
- Logging
- Concurrency control
- Deadlock resolution
- Primary key
- Foreign key
Which of the following transaction recovery methods is an operation where all the updated buffers are written to the disk by the DBMS?
- Database checkpoint
- Database buffers
- Write-ahead protocol
- Redundant transaction logs
- Lock table
___________ files in Oracle contain specific format about the containing objects.
- Flat
- Dump
- Redo log
- Metadata
- Data mining
Which of the following joins in relational algebra records from both the files P and Q are hashed to a single hash file by utilising the same function on the join attributes M of X and N of Y as hash keys?
- Nested loop join
- Single loop join
- Sort merge join
- Hash join
- Equi join
Which of the following forms of data in data staging component involves many forms of combining pieces of data from the different sources?
- Data extraction
- Data transformation
- Data loading
- Archived data
- External data
____________ data warehouses have the components distributed across a number of physical databases.
- Real time
- Federated
- Distributed
- Archived
- External
Which of the following types of data loading in data warehouse is the one that completely erases the contents of one or more tables and reloads it with a fresh data?
- Initial load
- Incremental load
- Full refresh
- Enrichment
- Selection
Which of the following schemas is the one used for normalizing the dimension tables in a star schema?
- Snowflake schema
- Star schema
- Fact constellation
- Fact tables
- Foreign key