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

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.

Multiple choice commercial studies computerised accounting system accounting systems - manual and computerized difference between manual and computerised accounting meaning and importance of computerised accounting system

An interactive link or a dialog between the user and database-oriented software through which the user communicates to the back-end database is ___________________.

  1. Back-end Database

  2. Front-end Interface

  3. Data Processing

  4. Reporting System
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Front-end Interface is an interactive link or a dialog between the user and database-oriented software through which the user communicates to the back-end database.

Multiple choice economics introduction to statistical method and econometrics estimating angles ict, investigations and problem solving-1 terms used in statistics

The statistical data are of two types. These types are

  1. technical data and presentation data

  2. primary data and secondary data

  3. primary data and personal data

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

Consider the statically data,

There are two types of statically data,

1-An advantage of using primary data is that researchers are collecting information for the specific purposes of their study. In essence, the questions the researchers ask are tailored to elicit the data that will help them with their study. Researchers collect the data themselves, using surveys, interviews and direct observations.

2-There are several types of secondary data. They can include information from the national population census and other government information collected by Statistics Canada. One type of secondary data that’s used increasingly is administrative data. This term refers to data that is collected routinely as part of the day-to-day operations of an organization, institution or agency. There are any number of examples: motor vehicle registrations, hospital intake and discharge records, workers’ compensation claims records, and more.

Hence this is the answer.

Multiple choice economics introduction to statistical method and econometrics estimating angles ict, investigations and problem solving-1 terms used in statistics

The statistical data are of two types. These types are

  1. technical data and presentation data

  2. primary data and secondary data

  3. primary data and personal data

  4. none of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The statistical data are two type .These are

1.Primary data-The primary data is the first hand  information that collect and published by the organisation.
2.Secondary Data-The secondary data is the second hand information that is already collected by someone for some purpose. 

Multiple choice accountancy accounting using data base management system (dbms) applications of dbms in generating accounting information accounting and database management system accounting and database system

A collection of records pertaining to one of the main subjects of an information system, such as customers, employees, products and vendors is known as ___________.

  1. Master File

  2. Transaction File

  3. Master data management

  4. Customer File
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A master file is a collection of records that contains relatively permanent data about entities like customers, employees, or products, which is used across multiple transactions.

Multiple choice maths data handling analysis analysis of frequency distributions analysing data collection of data and presentation of data

Data can be classified as :

  1. Primary

  2. Secondary

  3. Both

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

Data is classified as both primary and the secondary data.


Primary data is the data which is collected for the first time.
Secondary data is the data which are collected by someone else and passed through the statistical process.