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
-
It specifies that Streams memory be allocated from a pool in the SGA .
-
A stream pool can be created automatically.
-
It is used in server memory for all session-specific Java code and data within the JVM.
-
It provides memory synchronization.
-
It is responsible for execution plan in pooled memory.
C
Correct answer
Explanation
This is the task of Java pool in SGA.
-
It stores the most recently used blocks of data.
-
It stores a log of changes made to the database.
-
It contains information such as the parse tree and execution plan for the corresponding statement.
-
It uses a non-shared SQL area to process every unique SQL statement submitted to the database.
-
It is used to store the execution state of the database.
C
Correct answer
Explanation
A shared SQL stores such information and execution plans for all the database statements.
-
The SGA can grow in response to a database administrator statement.
-
The SGA can shrink in response to a database administrator statement, to an Oracle prescribed minimum.
-
The buffer cache and the SGA pools can grow and shrink at runtime.
-
The Dynamic SGA provides external controls for increasing and decreasing Oracle's use of physical memory.
-
The Dynamic control provides controls for the execution of procedures in the database.
E
Correct answer
Explanation
It does not provide such control.
-
These code areas are portions of memory used to store code that is being run or can be run.
-
Software areas are usually static in size.
-
Software areas are read only and can be installed shared or nonshared.
-
The multiple instances of Oracle can use the same Oracle code area with different databases if running on the same computer.
-
It is responsible for running the stored procedures in the database.
E
Correct answer
Explanation
This is the incorrect statement. Software Code Areas works in the management of DBA operations and it does not execute the operations like stored procedures etc.
-
It comprises of several Oracle instances running on multiple clustered computers.
-
RAC uses cluster software to access a shared database that resides on shared disk.
-
It provides system redundancy, near linear scalability and high availability.
-
It provides data synchronization.
-
It contains the information of the database backup.
E
Correct answer
Explanation
Real Application Clusters (RAC) does not have any database backup information.
-
Database administrators occasionally need isolation from concurrent non-database administrator's actions.
-
In this, the execution of data can be performed concurrently for each type of action.
-
One can put the system into quiesced state without disrupting users.
-
The execution of data is managed by this approach.
-
It is used to synchronise the database.
E
Correct answer
Explanation
It is not responsible for any synchronisation.
-
JOIN
-
Union
-
Difference
-
Intersection
-
Cartesian product
A
Correct answer
Explanation
This operator permits the combining of two relations to form a single relation and the processing of relationships existing between the operand relations.
-
Projection
-
Selection
-
JOIN
-
Difference
-
Intersection
A
Correct answer
Explanation
Projection yields a vertical subset of the relation, either to reduce the number of attributes in a resultant relation or to reorder attributes.
-
Library cache
-
Redo log buffer
-
Database buffer cache
-
Process monitor
-
Oracle data block
A
Correct answer
Explanation
This memory component of the SGA contains parsed SQL and execution plans for statements already run against the database.
-
Media management catalog
-
Target database
-
Media management application
-
Data buffer cache
-
Views
B
Correct answer
Explanation
This component of the RMAN environment containing the control files, data files and optional archived redo logs that RMAN backups.
-
Segment
-
Extent
-
Views
-
Indexes
-
Redo log buffer
D
Correct answer
Explanation
These logical structures can be created to increase the performance of data retrieval.
-
Database buffer cache
-
Recovery catalog database
-
Media management catalog
-
Media management application
-
Tablespaces
B
Correct answer
Explanation
You can create this component of the RMAN environment that contains the RMAN metadata for multiple target database.
-
Redo log buffer
-
Database buffer cache
-
Large pool
-
Log writer
-
Oracle datablock
C
Correct answer
Explanation
This memory component of the SGA is an optional area that provides large memory allocations for backup and restore operations.
-
Tablespaces
-
Segment
-
Extent
-
Clusters
-
Process monitor
D
Correct answer
Explanation
In clusters, related rows are physically stored together.
-
Media management application
-
Physical standby database
-
Media management catalog
-
Database buffer cache
-
Views
B
Correct answer
Explanation
This component of the RMAN environment has the same DBID and DB_Name values as the primary database but a different DB UNIQUE NAME.