Computer Knowledge
Database Management Systems
5,344 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
-
JDBC
-
ODBC
-
JDBC driver manager
-
JDBC URL
-
execute()
B
Correct answer
Explanation
The goal of ODBC is to make it possible to access any data from any application, regardless of which DBMS is handling the data.
-
SOCP
-
CATH
-
FSSP
-
SUPERFAMILY
C
Correct answer
Explanation
FSSP (Families of Structurally Similar Proteins) is automatically generated by comparing all protein structures in the PDB database using automated structure alignment algorithms. CATH and SUPERFAMILY involve manual curation or classification. SOCP (if referring to Structural Classification of Proteins) would be SCOP, which is also manual.
-
Bytes
-
Words
-
Fields
-
Database
-
_
C
Correct answer
Explanation
A field is a record that holds unique data which identifies the record from all the other records in a file or database.
-
High level language
-
Query language
-
SQL
-
4GL
-
_
B
Correct answer
Explanation
It is a special-purpose programming language designed for managing data held in a relational database management system.
B
Correct answer
Explanation
Structured Query Language is a special-purpose programming language designed for managing data held in a relational database management system.
-
Data field
-
Data record
-
Data file
-
Database
-
_
A
Correct answer
Explanation
It is the smallest component under which data is entered through data entry. All data fields in the same database have unique names.
-
Data Manager
-
Schema Manager
-
Storage Manager
-
Instance Manager
-
_
C
Correct answer
Explanation
This is a program module that provides the interface between the low-level data stored in a database.
-
DSS
-
OLTP
-
Data warehouse
-
DML
-
_
B
Correct answer
Explanation
In OLTP database, there is detailed and current data, and the schema used to store transactional databases is the entity model.
-
Full media
-
Graphics media
-
Multimedia
-
Hypertext
-
_
C
Correct answer
Explanation
It is the field concerned with the computer-controlled integration of text, graphics, drawings, video, animation and audio.
-
Bits
-
Characters
-
Data field
-
Schema
-
_
C
Correct answer
Explanation
In a database table, a field is a data structure for a single piece of data. Fields are organised into records, which contain all the information.
-
Extent
-
Segment
-
Database
-
Tablespace
-
_
D
Correct answer
Explanation
A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data.
-
LOB
-
Hash cluster
-
Nested table
-
Index cluster
-
_
D
Correct answer
Explanation
In an indexed cluster, Oracle stores together rows having the same cluster key value. Each distinct cluster key value is stored only once in each data block, regardless of the number of tables and rows in which it occurs.
-
Real time data warehouse
-
Federated data warehouse
-
Distributed data warehouse
-
None of these
A
Correct answer
Explanation
This is one of the types of data warehouse. They are updated every time an operational system performs a transaction.
-
Infrastructure specialists
-
OLAP (On-Line Analytical Processing)
-
Data warehouse architect
-
OLTP (On-Line Transaction Processing)
D
Correct answer
Explanation
OLTP (On-Line Transaction Processing) is a system to handle day-to-day business transactions. These systems handle tremendous amount of data daily.
-
OLTP (On-Line Transaction Processing)
-
OLAP (On-Line Analytical Processing)
-
Data warehouse
-
Real time data warehouse
C
Correct answer
Explanation
A data warehouse is a relational database, which is designed for query and analysis rather than for transaction processing.