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
-
Real time
-
Federated
-
Distributed
-
Archived
-
External
C
Correct answer
Explanation
This is the correct answer.
-
Initial load
-
Incremental load
-
Full refresh
-
Enrichment
-
Selection
C
Correct answer
Explanation
This type of data loading completely erases the contents of one or more tables and reloads it with fresh data.
-
Snowflake schema
-
Star schema
-
Fact constellation
-
Fact tables
-
Foreign key
A
Correct answer
Explanation
Snowflaking is a method of normalizing the dimension tables in a star schema.
-
Physical reads and logical reads
-
Number of rows processed
-
Commit and rollback of SQL statements
-
Providing event data
-
Generate the error information
E
Correct answer
Explanation
SQL Trace Facility does not provide any error generation report.
-
Segment
-
Extent
-
Data block
-
Tablespace
-
Control File
A
Correct answer
Explanation
The segment contains a specific type of database object.
-
It supports XML type tables.
-
The loading is independent of the underlying storage.
-
The data can be loaded in LOBs.
-
SQL*Loader uses direct path loading in case of inheritance of data.
-
This method uses both conventional and direct-path methods.
D
Correct answer
Explanation
SQL*Loader does not support direct-path loading if the data involves inheritance.
-
These are used to track undo information for the database.
-
These are used to copy the redo log files to extend the amount of redo information.
-
These define the rollback commands.
-
These segments determine the status of the server.
-
These are used to check the database connectivity.
A
Correct answer
Explanation
Rollback segments maintain the database stability and undo the information from the database as a security.
-
To keep all the application data in a separate tablespace
-
To enable backup of the database
-
To maintain the database
-
To distribute the data across multiple tablespaces
-
To undo the database
E
Correct answer
Explanation
Additional tablespace cannot be used for any undo operation in the database.
-
It stores temporary data.
-
It sorts the workspace.
-
Every database should have a temporary tablespace.
-
It is used to undo the tablespace used by the database.
-
TEMP tablespace is specified as the default temporary tablespace.
D
Correct answer
Explanation
TEMP cannot undo the tablespace used by the database.
-
SYSAUX
-
SYSTEM
-
TEMP
-
UNDOTBS1
-
USERS
B
Correct answer
Explanation
SYSTEM contains the data dictionary, which is the central set of tables and views used as a read-only reference describing a particular database.
-
Offline
-
Read only
-
Read Write
-
Read
-
Maintenance of datafiles is not possible by any tablespace status
A
Correct answer
Explanation
The user can change the status of Tablespace as Offline to mantain its datafiles.
-
The preconfigured database has basic database structure.
-
The database structure can be expanded.
-
One can create additional redo log groups to expand the redo log capacity in the database.
-
Oracle provides all the alerts related to the database storage while modification.
-
The changes in the database storage do not change the data dictionary and the control file.
E
Correct answer
Explanation
The changes in the database storage reflect the changes in the data dictionary and the control file.
-
Oracle automatically enables auto-tuning of the database.
-
The user can start the database without immediately managing undo.
-
'Undo the database' enables users to view or recover data to a previous point in time.
-
Undo operation for the database can be used for the rollback operation.
-
Undo operation provides read consistency of the database.
C
Correct answer
Explanation
The user is able to view or recover data to a previous point in time after 'undo the database'.
-
It is used to advise on the undo tablespace size.
-
It is used to undo the tablespace.
-
It is used to undo the database.
-
It is used to check the database connection.
-
It is used to manage the database.
A
Correct answer
Explanation
The user can use the undo advisor to advise on the undo tablespace size and the low threshold undo retention setting.
-
The dropped tablespace can be rolled back.
-
The objects and data in it will no longer be available after a tablespace has been dropped.
-
The objects of the dropped tablespaces will be available to the users.
-
These objects of the dropped tablespaces can be recovered.
-
The tablespaces cannot be dropped.
B
Correct answer
Explanation
This is correct and the objects and data cannot be used if anyone drops that tablespace.