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

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.

Multiple choice

Which of the following is called the security technique(s) while Committing Transactions in Oracle P/L SQL?

  1. It makes the changes permanent and affects the savepoints.

  2. The changes are not final.

  3. The changes are not visible to other users of the database instance.

  4. The newest Database Express Edition issues an implicit COMMIT statement before and after any data definition language (DDL) statement.

  5. The data restoration process will be at one point.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The changes are visible to user, but not to other users of the database instance. It makes the database secure and authenticated.

Multiple choice

Which of the following is the incorrect statement about the P/L SQL package in the database?

  1. A package in a PL/SQL unit is a combination of related programs.

  2. Packages allow you to hide implementation details from client programs.

  3. It does not allow client programs to access the database only by invoking PL/SQL subprograms.

  4. The package subprograms must be qualified with package names when invoked from outside the package.

  5. The package subprograms are arranged in a well defined module for each user.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Many Oracle customers follow this practice strictly, allowing client programs to access the database only by invoking PL/SQL subprograms.