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

Multiple choice

Which of the following phases in Oracle is said to be the node, which after receiving notice from the global coordinator that all nodes have committed, erases status information about this transaction from the commit site?

  1. Commit phase

  2. Prepare phase

  3. Forget phase

  4. Prepared phase

  5. Abort phase
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This phase in Oracle is said to be the node which after receiving notice from the global coordinator that all nodes have committed, the commit point site erases status information about this transaction.

Multiple choice

Which of the following features in distributed database is the one which allows the NLS (Natural Language Support) settings of the client, the transparency gateway and the non-Oracle data source to be either the same or a subset of the Oracle database server?

  1. Distributed Query Optimization

  2. Client/Server Environment

  3. Homogeneous Distributed Environment

  4. Remote Procedure Calls

  5. Heterogeneous Distributed Environment
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

This feature in distributed database is the one which allows the NLS (Natural Language Support) settings of the client, the transparency gateway and the non-Oracle data source to be either the same or a subset of the Oracle database server.

Multiple choice

Which of the following metadata in DBMS is concerned with the information system characteristics that include ETL process metadata, back room metadata and transformation metadata?

  1. Business metadata

  2. Operational metadata

  3. Technical metadata

  4. Hybrid metadata

  5. Target metadata
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This metadata in DBMS is concerned with the information system characteristics that include ETL process metadata, back room metadata and transformation metadata.

Multiple choice

Which of the following data quality tools used in data warehouse provides a single environment that seamlessly integrates data quality within the data integration process?

  1. Informatics

  2. Oracle 10g warehouse builder

  3. SAS (Statistical Analysis System)

  4. MySAP business intelligence

  5. Data profiling
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This tool used in data warehouse provides a single environment that seamlessly integrates data quality within the data integration process.

Multiple choice

Which of the following methods in ResultSetMetaData interface retrieves the designated column's database-specific type name?

  1. getColumnName(int column)

  2. getColumnType(int column)

  3. getColumnTypeName(int column)

  4. getColumnNameType(int column)

  5. getColTypeName(int column)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

getColumnTypeName(int column) method is present in ResultSetMetaData interface and it retrieves the designated column's database-specific type name. So, this answer is correct.

Multiple choice

The access time refers to

  1. time required to locate date

  2. time required to retrieve stored data

  3. both 1 and 2

  4. none of these
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Access time is the total time taken to locate the data and then retrieve it from the storage medium.

Multiple choice

PARAM is a

  1. DBMS package

  2. Super computer

  3. Programming language

  4. Parallel random access memory

  5. None of these
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Option (2) is correct.

Multiple choice

The raw facts are called

  1. data

  2. information

  3. problem

  4. all the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data refers to raw, unorganized facts and figures, which become information after processing.

Multiple choice

The processed data is called

  1. result

  2. meta data

  3. information

  4. all the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Information is defined as processed, organized, and structured data that is meaningful to the user.