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 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.

Multiple choice elements of accounts using computerised accounting system grouping and codification of accounting steps in installation of cas accounting information system

Which are the various steps involved in designing accounting reports from accounting data? 

  1. Definition of objective, Structure of the report, Querying with the database, finalising the report

  2. Definition of data, Structure of the data, Querying with the database, finalising data

  3. Definition of data, Structure of the report, Querying with the database, finalising report

  4. Definition of objective, Structure of the data, Querying with the database, finalising data
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The various steps involved in designing accounting reports from accounting data are as follows:
1) Definition of objective: The objective of the report must be clearly defined.
2) Structure of the report: The information to be contained therein and the style of presentation.
3) Querying with the database: The accounting information queries must be clearly defined and methodology to be adopted while interacting with the database.
4) Finalising the report.

Multiple choice elements of accounts using computerised accounting system grouping and codification of accounting steps in installation of cas accounting information system

When the related information is summarized to meet a particular need, it is called as a _________.

  1. statement

  2. summary

  3. database

  4. report
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When the related information is summarized to meet a particular need, it is called as a Report. The content and design of the reports is expected to vary depending up on the level to which it is submitted and decision to made on the basis of the report. Hence, a report must be effective and efficient to the user and should substantiate the decision-making process.

Multiple choice elements of accounts computerised accounting system accounting systems - manual and computerized difference between manual and computerised accounting meaning and importance of computerised accounting system

___________ is one of the four basic requirements under use of computers in any database oriented application, where an integrated set of objects constitute the report.

  1. Front-end Interface

  2. Reporting System

  3. Back-end Database

  4. Data Processing
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Steps involved in designing accounting reports :-

1.Definition of objectives 

2.Structure of the report 

3.Querying with the database

4.Finalizing the report 

Therefore Reporting System is an integrated set of objects that constitute the report.

Multiple choice

What is a Record or Row?

  1. Single Data

  2. A Column

  3. A Field

  4. A set of data
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In a database table, a row (or record) represents a single, complete entry containing data for all the defined fields (columns) in that table.

Multiple choice

Databases are made up of ?

  1. Databases

  2. Tables

  3. Categories

  4. Different Types
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A relational database is organized into tables, which store data in rows and columns.

Multiple choice

What does SQL Stand for?

  1. Server Query Language

  2. Structured Query Language

  3. Some Qute Language

  4. Sticky Query Language
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SQL is an acronym that stands for Structured Query Language, the standard language for managing relational databases.