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
-
Native-API partly java driver
-
JDBC
-
Native-protocol pure java driver
-
JDBC URL
-
execute()
C
Correct answer
Explanation
This allows a direct call from the client machine to the DBMS server and is a practical solution for intranet access.
-
executeUpdate()
-
JDBC URL
-
JDBC
-
JDBC driver manager
-
JDBC-ODBC Bridge plus ODBC driver
E
Correct answer
Explanation
ODBC binary code and in many cases database client code must be loaded on each client machine that uses JDBC-ODBC Bridge plus ODBC driver.
-
JDBC URL
-
JDBC
-
JDBC-ODBC bridge
-
native-API partly-java driver
-
execute()
C
Correct answer
Explanation
JDBC works on top of ODBC and then we have something called as a JDBC-ODBC bridge to access the database.
-
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.