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
-
Dominant entity
-
Derived entity
-
Subordinate entity
-
Composite entity
-
None of these
A
Correct answer
Explanation
This is the correct answer. 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 is the correct answer.
-
MySql Server
-
Sql Server
-
Weblogic server
-
Postgre SQL server
-
Oracle server
C
Correct answer
Explanation
This is an application server to deploy the applications.
-
RDBMS (Relational Database Management System) stores the data in tabular form.
-
DBMS (Database Management System) does not follow normalization.
-
RDBMS does not support client server architecture.
-
All of the above.
-
Only (1) and (2) are true
D
Correct answer
Explanation
Yes, all the three are the true statements.
-
Oracle
-
SQL server
-
IBM DB2
-
All of the above
-
Only (2) and (3)
D
Correct answer
Explanation
Yes, all of three are supported by Borland Data Provider.
-
enterprise manager
-
third party administration tools
-
SNMP support
-
site autonomy
-
replication transparency
D
Correct answer
Explanation
Site autonomy means that each server participating in a distributed database is administered independently from all other databases.
-
Durability
-
Atomicity
-
Serializability
-
Isolation
-
Concurrency
B
Correct answer
Explanation
This property of transaction management requires that if a transaction is interrupted by a failure its partial results are not at all taken into consideration and the whole operation has to be repeated.
-
Database server
-
Commit point site
-
Local coordinator
-
Global coordinator
-
Client
C
Correct answer
Explanation
This role in distributed transaction refers to a node that is forced to reference data on other nodes to complete its part of the transaction.
-
Oracle flashback database
-
Incrementally updated backups
-
Flash recovery area
-
Disk topology and automatic performance tuning
-
Automatic datafile creation
C
Correct answer
Explanation
This is an area or automatic storage management disk group that serves as the default storage area for files related to recovery.
-
Media management application
-
Duplicate database
-
Standby database
-
Recovery catalog database
-
Media management catalog
A
Correct answer
Explanation
This component of Recovery Manager is a vendor specific application that allows RMAN to backup to a storage system such as tape.
-
Recovery catalog database
-
Standby database
-
Duplicate database
-
Media management application
-
Recovery catalog schema
B
Correct answer
Explanation
This component of Recovery Manager is a copy of the primary database that is updated using archived logs created by the primary database.
-
Select statement
-
Database triggers
-
Cursor
-
Packages
-
Update statement
D
Correct answer
Explanation
This database object in PL/SQL groups together objects and programs into a single entity.
-
Database
-
Relation
-
Active data set
-
Entity
-
Attributes
C
Correct answer
Explanation
Active data set is the data stored in the cursor of a PL/SQL program.
-
Oracle server
-
Oracle instance
-
Oracle database
-
Redo log buffer
-
Database buffer cache
A
Correct answer
Explanation
This object in Oracle consists of physical files and memory components.
-
user
-
background
-
Server processes
-
Session memory
-
SQL work area
B
Correct answer
Explanation
The database writer, log writer and checkpoint processes are background type of processes in Oracle 9i.
-
Physical data level
-
External data level
-
Conceptual data level
-
Both (1) and (2)
-
None of the above
B
Correct answer
Explanation
Yes, this level represents the data as set of relations. It specifies the view of the data at the conceptual level.