Computer Knowledge
Database Management Systems
5,344 Questions
Database Management Systems (DBMS) form the core framework for data storage, retrieval, and security in modern software applications. Concepts such as the E-R model, backup planning, SQL integration, and big data architecture are essential for computer knowledge sections. This hub offers a comprehensive set of practice questions to master DBMS fundamentals and advanced database operations.
E-R Model ConceptsBackup and RecoverySQL Server UpgradesJDBC and ODBCBig Data CharacteristicsData VirtualizationOracle Database
Database Management Systems Questions
-
Revoke
-
Grant
-
Role
-
Synonym
-
View
C
Correct answer
Explanation
This statement in Oracle is a group of privileges that are collected together and granted to users.
-
Semantic data model
-
Data flow model
-
Object model
-
None of these
B
Correct answer
Explanation
Data-flow model is a way of showing how data is processed by a system. The notation used in this model represents functional processing, data stores and data movements between functions.
-
client-server model
-
abstract machine model
-
repository model
-
none of these
C
Correct answer
Explanation
A system model based on a shared database is called as repository model.
-
Data-flow model
-
Entity-relation model
-
Structural model
-
Object-oriented model
B
Correct answer
Explanation
An entity-relation model is used to describe the logical data structures being used.
-
Transformation
-
Preprocessing
-
Data mining
-
None of these
B
Correct answer
Explanation
This is the data cleansing stage where certain information is removed, which is deemed unnecessary and may slow down queries.
-
Drill-Down
-
Consolidation
-
Slicing and dicing
-
None of these
B
Correct answer
Explanation
This OLAP database servers analytical involves the aggregation of data such as simple roll-ups or complex expressions, involving inter-related data.
-
Consolidation
-
Drill-Down
-
Slicing and Dicing
-
None of these
C
Correct answer
Explanation
Slicing and Dicing refers to the ability to look at the database from different viewpoints.
-
Fast
-
Analysis
-
Shared
-
Multidimensional
A
Correct answer
Explanation
This characteristic of OLAP means that the system is targeted to deliver most responses to users within about five seconds with the simplest analyses taking no more than one second and very few taking more than 20 seconds.
-
Analysis
-
Multidimensional
-
Shared
-
None of these
A
Correct answer
Explanation
This means that the system can cope with any business logic and statistical analysis, which is relevant for the application and the user.
-
Process monitor
-
Database writer
-
Log writer
-
Lock manager server
-
Mounting the database
B
Correct answer
Explanation
At specific times, all modified database buffers in the SGA are written to the datafiles by the database writer.
-
Redo log file
-
The parameter file
-
The archive file
-
Instance creation
-
Abort
A
Correct answer
Explanation
The information in a redo log file is used to recover the database from a media failure.
-
Registration
-
The java pool
-
The stream pool
-
Session memory
-
Database buffer cache
E
Correct answer
Explanation
This memory component of the SGA contains modified blocks and clean or unchanged blocks.
-
Recover
-
Segments
-
Views
-
Tablespace
-
Tables
D
Correct answer
Explanation
A database is divided into logical storage units is called tablespace.
-
Lock manager server
-
Opening the database
-
System monitor
-
Process monitor
-
Log writer
C
Correct answer
Explanation
With real application, the system monitor process of one instance can perform instance recovery for instances.
-
Datafiles
-
The archive file
-
The parameter file
-
Instance creation
-
Read only
A
Correct answer
Explanation
The data of logical database storage structures such as tables and indexes are physically stored in the datafiles.