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 statistics vital statistics and official statistics guiding rules for tabulation vital statistics textual and tabular presentation of data

Tabulation of data makes the presentation of facts and figures ___________.

  1. more simplified

  2. more understandable

  3. Both a&b

  4. It is lengthy and occupies space
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Tabulation simplifies complex data and makes it more understandable by organizing it into a clear, readable format.

Multiple choice statistics vital statistics and official statistics guiding rules for tabulation vital statistics textual and tabular presentation of data

_______ of data refers to the table where data are classified on the basis of single characteristics.

  1. Complex Tabulation

  2. Reference Tabulation

  3. Simple Tabulation

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

Simple tabulation involves classifying data based on a single characteristic. Complex tabulation involves two or more characteristics.

Multiple choice economics data different types of data planning and collecting data primary and secondary data

________ is the data, which is collected for the first time by investigators.

  1. Published data

  2. Primary Data

  3. Processed data

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

Primary data is the data, which is collected for the first time by investigators. It s also known as raw data. It is the first-hand information. It refers to the collection of data for a specific purpose.

Multiple choice evs look, learn and experience matter: states, classification and properties study of matter general introduction: importance and scope of chemistry

The property that we use for classifying things depends on the ___________ of the classification.

  1. grouping

  2. purpose

  3. information

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

Things are always classified to make 

(i)easy identification of things.
(ii)Can know all properties of group if we know about one element in the group.
The property that we use  for classifying things depend on the purpose of classification.

Multiple choice elements of accounts overview of computerised accounting system accounting software concepts and types of computerized accounting system types of accounting software

________ ensures the accuracy and reliability of input data by comparing the same with some predetermined standards or known as  data.

  1. Data validation

  2. Data entry

  3. Storage

  4. Processing and revaluation
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data validation ensures the accuracy and reliability of input data by comparing the same with some predetermined standards or known as data. This validation is performed by error detecting and error correction procedures. 

Multiple choice elements of accounts overview of computerised accounting system accounting software concepts and types of computerized accounting system types of accounting software

Data validation ensures the accuracy and reliability of input data by comparing the same with some predetermined standards or known data.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data validation ensures the accuracy  and reliability of input data by comparing the same with some predetermined standards or known data. This verification is performed by error detection and error correction procedures.

Multiple choice elements of accounts overview of computerised accounting system accounting software concepts and types of computerized accounting system types of accounting software

______________ ensures the accuracy and reliability of input data by comparing the same with some predetermined standards or known data.

  1. Data Entry

  2. Data Validation

  3. Processing and Revalidation

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

Data validation is the process of ensuring that data is clean, correct, and useful. It involves checking input against predefined rules or standards to prevent errors.

Multiple choice elements of accounts overview of computerised accounting system accounting software concepts and types of computerized accounting system types of accounting software

Under ___________, reports can be prepared on the basis of the required information content according to decision usefulness of the report.

  1. storage

  2. information

  3. reporting

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

Reporting is the phase in an information system where data is organized and presented in a format useful for decision-making.

Multiple choice commercial applications generally accepted accounting principles (gaap) acccounting cycle meaning, need and objectives of accounting accounting process

________ is concerned with the systematic analysis of the recorded data with a view to group transactions or entries of one nature at one place.

  1. Summarizing

  2. Analysis

  3. Classifying

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

Classification is concerned with the systematic analysis of the recorded data with a view to group transactions or entries of one nature at one place. The work of classification is done in the book called "ledger". This book contains on different pages individual account heads under which all financial transactions of similar nature are collected.