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
-
IMMEDIATE
-
NORMAL
-
FORCE
-
Mounting the database
-
TRANSACTIONAL
E
Correct answer
Explanation
In this option of SHUTDOWN command, all currently active transactions will be allowed to complete.
-
Flash recovery area
-
Recovery through resetlogs
-
RECOVER
-
FORCE
-
PFILE
C
Correct answer
Explanation
This option of STARTUP command is used to perform media recovery when starting the database.
-
Parameter file
-
Password file
-
Instance creation
-
Redo log file
-
SQL work area
D
Correct answer
Explanation
This file contains a record of all changes made in the database.
-
FORCE
-
PFILE
-
RESTRICT
-
Password file
-
Proxy archived log backups
C
Correct answer
Explanation
This option of the STARTUP command is used when you want only users who possess the privilege to access the database.
-
Oracle instance
-
Oracle database
-
Mounting the database
-
Password file
-
Parameter file
A
Correct answer
Explanation
It consists of the memory components of oracle and various background processes.
-
Parameter file
-
Password file
-
Instance creation
-
Data files
-
Stream pool
B
Correct answer
Explanation
This file can be used when you use database authentication.
-
Segment
-
Extent
-
Tablespace
-
Instance creation
-
Java pool
C
Correct answer
Explanation
It can be reorganized, backed up and so forth with minimal impact to other users whose data may be in other thablespaces.
-
Data dictionary cache
-
Stream pool
-
Database buffer cache
-
SQL work area
-
Mounting the database
C
Correct answer
Explanation
Blocks that need to be modified, are modified in memory and are written back to disk periodically.
-
Extent
-
Database block
-
Schema
-
Instance creation
-
Stream pool
B
Correct answer
Explanation
This logical object is the smallest unit of storage in a oracle database.
-
Timezone
-
Timezonedb
-
Dbtimezone
-
Dbtz
C
Correct answer
Explanation
This answer is correct. 'Dbtimezone' is the keyword to get the timezone of the current DB. It gives the current timezone in which the database is existing.
-
MySQL
-
Microsoft access
-
File maker
-
Excel
-
None of the above
D
Correct answer
Explanation
Excel is not a type of database . A database is a data structure that stores organized information. Nearly all e-commerce sites uses databases to store product inventory and customer information.
-
Data security
-
Data validity
-
Data independence
-
Data integrity
-
_
D
Correct answer
Explanation
It refers to maintaining and assuring the accuracy and consistency of data over its entire life-cycle. It is a fundamental component of information security.
-
getDateAndTimeFunctions()
-
getTimeAndDateFunctions()
-
getDateTimeFunctions()
-
getTimeDateFunctions()
-
getAllTimeDateFunctions()
D
Correct answer
Explanation
This is the correct choice. DatabaseMetaData interface in Java contains a method called getTimeDateFunctions() and it retrieves a comma-separated list of time and date functions available with this database.
-
It is a stored query.
-
Replica or image of a table.
-
Changes either in table or in view will reflect in both.
-
It provides restricted access to table.
-
It occupies same storage space as table does.
E
Correct answer
Explanation
It s a stored query and creates virtual columns from table in memory.