Computer Knowledge
Database Management Systems
5,543 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
C
Correct answer
Explanation
The Structured Query Language is the language used by programmers to interact with an RDBMS.
-
Explicit cursor
-
User-defined cursor
-
Implicit cursor
-
User cursor
-
Dynamic cursor
A
Correct answer
Explanation
An explicit cursor is a named pointer to a private SQL area that stores information for processing a specific query or DML statemen
-
sysindexes
-
SYSIBM.SYSINDEXES
-
sysusers
-
sysconstraints
-
sysobjects
A
Correct answer
Explanation
The sysindexes system table stores system -level information about SQL Server indexes.
-
HLOOKUP function
-
VLOOKUP function
-
GETPIVOTDATA function
-
GET function
-
GOT function
B
Correct answer
Explanation
The function merges the two files in sequential and orderly manner and makes a consolidated files at user end.
-
DB2
-
My SQL
-
MS SQL
-
ORACLE
-
MSSQL 2005
D
Correct answer
Explanation
In 1978 oracle version 1 in assembly language as RDBMS launched.
-
Account blocking
-
Account locking
-
Password history
-
Password verification
-
Password matching
C
Correct answer
Explanation
DBMS keeps the track of old password for specified duration of time as mentioned in the policy, and it does not allow the user to reset the same password for that duration.
-
Resource
-
Network Admin
-
System Admin
-
DBA
-
SYSDBA
E
Correct answer
Explanation
SYSDBA is the actual privilege required or given to DBA to create a new database.
-
Execution phase
-
Compilation phase
-
Command file
-
Common language interpreter
-
Duplicate database
A
Correct answer
Explanation
Here, RMAN sends the RPC calls to the target database, monitors their progress and collects the results.
-
Duplicate database
-
Recovery catalog schema
-
Media management application
-
Media management catalog
-
Command file
B
Correct answer
Explanation
RMAN periodically propogates metadata from the target database control file into the recovery catalog schema.
-
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.