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 is NOT true regarding Program Global Area (PGA)?

  1. It is a non-shared memory.

  2. It is created when a server process is started.

  3. Each server process is allocated One PGA.

  4. Total memory used by all individual PGAs is called total instance PGA memory.

  5. Database initialization parameters are used to set the size of individual PGAs.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

This statement is false. You use database initialization parameters to set the size of the instance PGA, not individual PGAs.

Multiple choice

Which task can a DBA perform using the export/import facility?

  1. Examine log files

  2. CREATE CONTROLFILE

  3. Transport tablespaces between databases

  4. Make a logical backup of the rollback segment tablespace

  5. Determine if platforms are supported and determine endianness
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

This option is correct because the transport tablespaces between databases is a task a DBA can perform using the export/import facility.

Multiple choice

Why should a datafile be set to offline when the database is in MOUNT state?

  1. To minimise downtime

  2. To prevent further corruption of a damaged datafile

  3. To allow automatic recovery of the datafile

  4. To recover it later, when database is in NOARCHIVELOG mode

  5. To maximise uptime
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When the database is in MOUNT state, a datafile is set to offline to allow its automatic recovery.

Multiple choice

A set of dictionary tables is created

  1. every time a tablespace is created

  2. once for an entire database

  3. every time a user is created

  4. when time data is created

  5. Both (1) and (2)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A set of dictionary tables is created once a database is created.

Multiple choice

System datafiles consist of

  1. undo data

  2. temporary data

  3. business data

  4. metadata

  5. permanent data
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

System datafiles consist of metadata.

Multiple choice record management and office equipment business office - meaning, importance, functions and departments office management business organisation business studies office circulars concept of office management

________ stage is concerned with the possible use of filing and indexing system.

  1. Creation

  2. Utilization

  3. Storage

  4. Retrieval
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The storage stage of the record life cycle involves organizing records, which includes the application of filing and indexing systems for efficient future retrieval.

Multiple choice record management and office equipment business office - meaning, importance, functions and departments office management business organisation business studies office circulars concept of office management

Record maintenance is required because _____.

  1. it helps develop efficient procedures for each stage of the cycle

  2. it reduces cost in each stage of the record cycle

  3. it eliminates needless storage of duplicate records

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

Record maintenance is essential for efficiency, cost reduction, and preventing the accumulation of unnecessary or duplicate files, making all listed reasons valid.

Multiple choice business organisation and correspondence bank 2 - accounts maintained by a bank functions and services of banks role of banks in economic development and modes of money transfer accounts and other services

Projections and responses to queries are Information output characteristics associated with ______________________.

  1. Decision Support System (DSS)

  2. Management Information System (MIS)

  3. Executive Support System (ESS)

  4. Transaction Processing System (TPS)
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Projections and responses to queries are Information output characteristics associated with Executive Support System (ESS). Executive Support System is also known as Executive Information System. It helps to provide easy access to internal and external information relevant to organizational goals. It also supports decision-making needs.

Multiple choice business organisation and correspondence bank 2 - accounts maintained by a bank functions and services of banks role of banks in economic development and modes of money transfer accounts and other services

Summary transaction data, high-volume data, and simple models are information inputs characteristic of _________________.

  1. Decision Support System (DSS)

  2. Management Information System (MIS)

  3. Executive Support System (ESS)

  4. Transaction Processing System (TPS)
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Summary transaction data, high-volume data, and simple models are information inputs characteristic of Management Information System(MIS). Management Information System can be defined as an information system which is used for decision-making purpose and for maintaining coordination in the organization. It also helps to visualize the information of the organization.

Multiple choice

Area of knowledge in which an expert system specializes

  1. Knowledge domain

  2. Knowledge base

  3. Knowledge engineer

  4. Theory of Knowledge
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A knowledge domain is the specific field or area of expertise (e.g., medicine, geology) that an expert system is designed to provide advice on.