Advanced Database Systems
Covers advanced database concepts including system architecture, parallel and distributed databases, data warehousing, transaction management, and query optimization.
Questions
Which of the following server systems in database system architecture allows clients to interact with the servers by making request to read or update data in units, such as files or pages?
- Transaction server
- Data server
- Query server
- System server
- Operational server
Which of the following issue in parallel systems refers to the rate at which transactions are submitted and increases the size of the database proportional to the transaction rate?
- Batch scaleup
- Transaction scaleup
- Data caching
- Multiprogramming
- Throughput
Which of the following objects in data warehouse is similar to the data dictionary or the data catalog in a DBMS?
- Data marts
- Metadata component
- Tuples
- Attributes
- Schema
Which of the following data models is DBMS and defines the problem, rather than the solution, from the business point of view?
- Conceptual data model
- Logical data model
- Physical data model
- User data model
- Internal data model
Which of the following DBMS software modules processes and checks the specification of a database schema in the data definition language and stores that description in the catalog?
- Query and DML parser and verifier
- Query and DML compilers
- DDL compilers
- Query and DML optimizer
- Transaction control commands
Which of the following types of storage in database system allows information residing in volatile storage to not survive during system crashes?
- Volatile storage
- Non-volatile storage
- Stable storage
- Backup storage
- Flash memory
Which of the following properties of database system ensures that even after a transaction is sucessfully complete, the changes it has made to the database persist, even if there are system failures?
- Atomicity
- Consistency
- Isolation
- Durability
- Accuracy
Which of the following advantages of building distributed database enables a user to retain a degree of control over data that is stored locally?
- Sharing data
- Availability
- Autonomy
- Speed
- Accuracy
Which of the following cost components in query execution is the cost of performing in-memory operations on the data buffers during query execution?
- Storage cost
- Memory usage cost
- Communication cost
- Computation cost
- Access cost
Which of the following types of data partitioning strategy in parallel systems is the one in which one or more attributes from the given relations schema are designated as the partitioning attributes?
- Round-robin
- Hash partitioning
- Range partitioning
- Open partitioning
- Closed partitioning
Which of the following architectural model in parallel machines is the one in which all the processors share a common memory?
- Shared memory
- Shared disk
- Shared nothing
- Hierarchical
- ER model
Which of the following errors in transaction failure is the one in which the system has entered an undesirable state, as a result of which a transaction cannot continue with its normal execution?
- Logical error
- System crash
- System error
- Disk failure
- Compiler error
Which of the following form of interconnection network in parallel systems is the one in which components are arranged as nodes in a grid and each component is connected to all adjacent components in the grid?
- Bus
- Hypercube
- Mesh
- Ring
- Token-passing
Which of the following modeling in data warehouses represents business processes within the enterprise and serves as a blueprint for operational database systems?
- E-R data modeling
- Dimensional modeling
- Logical data model
- Physical data model
- External data model
Which of the following transaction states in DBMS signals that the transaction has ended unsuccessfully and that any changes or effects that the transaction may have applied to the database must be undone?
- Begin_Transaction
- End_Transaction
- Commit_Transaction
- Rollback
- Stop_Transaction