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
-
Registration
-
The java pool
-
Stream pool
-
Redo log buffer
-
Session memory
D
Correct answer
Explanation
The redo entries stored in the redo log buffer are written to an online redo log.
-
Mounting the database
-
Process monitor
-
Checkpoint process
-
Lock manager server
-
Log writer
C
Correct answer
Explanation
This background process is responsible for signaling database writer at the check points and updating all the datafiles, and control files.
-
Large pool
-
The stream pool
-
The java pool
-
Session memory
-
Password file
A
Correct answer
Explanation
This memory component of the SGA provides large memory allocations for Oracle backup and restore operations.
-
Force
-
Instance creation
-
The parameter file
-
The archive file
-
Control file
E
Correct answer
Explanation
The entries such as the database identifier and name, redo log archive infoinformation, etc. are maintained in the control file.
-
Read only
-
Oracle datablock
-
Table
-
View
-
Segment
B
Correct answer
Explanation
A database uses and allocates free database space in oracle data blocks.
-
The archive file
-
Temporary segment
-
Table
-
View
-
Instance creation
B
Correct answer
Explanation
When the segment finishes execution, the extents in the temporary segment are returned to the system.
-
Archiver
-
Lock manager server
-
Log writer
-
Process monitor
-
The archive file
A
Correct answer
Explanation
This background processes copies the online redo log files to archival storage.
-
subordinate entity set
-
dominant entity set
-
compound entity set
-
derived entity set
-
none of these
A
Correct answer
Explanation
This answer is correct. There is no particular reason to explain this answer, because there is a name convention in DBMS. The members of weak entity set are called subordinate entity set. So, this answer is correct.
D
Correct answer
Explanation
This answer is correct. There are 3 types of record based data models. These are :- 1.) Hierarchical model 2.) Network model 3.) Relational model
B
Correct answer
Explanation
There are five types of attributes in a database. These are :- 1.) Simple attribute 2.) Composite attribute 3.) Single-valued attribute 4.) Multivalued attribute 5.) Derived attribute
B
Correct answer
Explanation
This answer is correct. There are seven types of keys in a relational database. These are :- 1.) Primary key 2.) Candidate key 3.) Super key 4.) Foreign key 5.) Alternate key 6 .) Artificial key 7.) Composite key
So, this answer is correct.
-
Composite entity set
-
Weak entity set
-
Strong entity set
-
Derived entity set
-
None of these
B
Correct answer
Explanation
This is the correct answer. The entity set that does not have sufficient attributes to form a primary key, and relies on another for its identification, is called a weak entity set. It does not have a primary key. So, this is correct answer.
C
Correct answer
Explanation
This answer is correct. There are 3 types of data models present in DBMS. These are :- 1.) Object based data model 2.) Record based data model 3.) Physical data model
So, this answer is correct.
-
dominant entity
-
derived entity
-
subordinate entity
-
composite entity
-
none of these
A
Correct answer
Explanation
This answer is correct. There is no particular reason to explain this answer, because there is a name convention in DBMS. The members of strong entity set are called dominant entity set. So, this answer is correct.
B
Correct answer
Explanation
SQL (Structured Query Language) is a special-purpose programming language designed for managing data held in a relational database management system (RDBMS).