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
-
One-safe
-
Detection of failure
-
Image copy
-
Two-very-safe
-
RAID level 1
D
Correct answer
Explanation
A transaction commits as soon as its commit log record is written to stable storage at the primary and the backup site.
-
RMAN client
-
Client
-
Database server
-
Duplicate database
-
Media management application
A
Correct answer
Explanation
The RMAN client can use Oracle Net to connect to a target database.
-
Duplicate database
-
Media management catalog
-
Database server
-
Standby database
-
Media management application
D
Correct answer
Explanation
If the primary database goes down then you can fail over to the standby database.
-
Proxy archived log backups
-
Automatic datafile creation
-
Media management catalog
-
Duplicate database
-
Oracle flashback database
E
Correct answer
Explanation
You can quickly revert a database to a previous time without restoring datafiles and performing media recovery.
-
Growing phase
-
Compilation phase
-
Shrinking phase
-
Shared mode
-
In-doubt transaction
C
Correct answer
Explanation
During this phase, the locks are only released.
-
Media management catalog
-
Target database
-
Duplicate database
-
Client
-
Media management application
B
Correct answer
Explanation
The work of backup and recovery is performed by server sessions running on the target database.
-
Shared mode
-
Exclusive mode
-
Growing phase
-
Compilation phase
-
Local agents
B
Correct answer
Explanation
Here, the transaction wants edit the data item.
-
Client
-
Commit point site
-
Database server
-
Local coordinator
-
Duplicate database
D
Correct answer
Explanation
A node that must references data on other nodes to complete its part in the distributed transaction.
-
Trigger
<!--?xml:namespace prefix = o /--><o:p></o:p>
-
Procedure
<o:p></o:p>
-
Function
<o:p></o:p>
-
Package
<o:p></o:p>
D
Correct answer
Explanation
A package is a collection of related PL/SQL objects like procedures, functions and triggers created as a single unit. It is used to store related objects in a single file. A package has two parts - Package specification and package body. The specification part contains the declaration of procedure, functions and triggers whereas the body part contains the actual implementation or code of all the subprogram declared in specification part.
-
ASPNETMS
-
ASP.NET Oracle
-
ASPNETDB
-
ASPNETACCESS
-
ASPNET
C
Correct answer
Explanation
This is the data base which is used for adding the product_profile table.
-
Data set
-
Database (itself)
-
SQL
-
DBMS
-
None of the above
A
Correct answer
Explanation
Data set invokes the method Update for changing any specific data base in ASP.Net.
-
Commit
-
Savepoint
-
Rollback
-
Set transaction
-
Grant
E
Correct answer
Explanation
It gives user's access privileges to database. Hence, it is DCL command and not a TCL command.
-
Database writer
-
Stream pool
-
Log writer
-
SQL work area
-
Mounting database
C
Correct answer
Explanation
The contents of redo log buffer are transferred periodically from memory to the online redo log files on disk by the log writer background process.
-
Tablespace
-
Segment
-
Instance creation
-
Database
-
Flash recovery area
A
Correct answer
Explanation
A tablespace is composed of one more datafiles on disk.
-
Data dictionary cache
-
Private SQL area
-
Instance creation
-
SQL work area
-
Read only
A
Correct answer
Explanation
This cache is managed using the least recently used algorithm.