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 accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

A representational data model through which ER design is transformed into inter-related data tables along with the restriction of rules specified to ensure the consistency and integrity of stored data is _________.

  1. Reality

  2. Relational Data Model

  3. ER design

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

Relational Data Model is a representational data model through which ER design is transformed into inter-related data tables along with the restriction on the form of rules specified to ensure the consistency and integrity of stored data.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

The process of designing a database for accounting is best described through a ________.

  1. Tree diagram

  2. Flow chart

  3. Pictorial presentation

  4. None of the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The process of designing a database for accounting is best described through a flow chart.

 A flowchart can also be defined as a diagrammatic representation of an algorithm, a step-by-step approach to solving a task.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

_____________ is a formal blueprint, with a pictorial presentation, in which Entity Relationship Model concepts are used to represent description of reality.

  1. ER Design

  2. Relational Data Model

  3. Reality

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

A formal blueprint, with a pictorial presentation, in which Entity Relationship Model concepts are used to represent description of reality is known as ER Design.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

Access is functionally available with the following seven-object classes.

  1. Tables, Queries, Forms, Reports, Pages, Macros, Modules

  2. Tables, Queries, Forms, Reports, Page no., Macros, Modules

  3. Tables, Queries, Forms, Reports, Pages, Micros, Modules

  4. Tables, Queries, Forms, Responsibility, Pages, Micros, Modules
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

MS access is one of the popularly used Database Management System (DBMS) to create, store and manage database. Access is functionally available with the following seven-object classes. Each of these object classes is capable of creating their respective object replicas. The seven objects are as follows: Tables, Queries, Forms, Reports, Pages, Macros, Modules.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

__________ is one of the popularly used Database Management System (DBMS) to create, store and manage database. 

  1. MS access

  2. MS excel

  3. MS Word

  4. MS power point
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

MS access is one of the popularly used Database Management System (DBMS) to create, store and manage database. It is also popularly called ACCESS.

Multiple choice accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

The process of generating  accounting reports in access involves which of the following steps?

  1. Designing the report, Identifying accounting information queries, Using the record set of final MDB

  2. Designing the report, Identifying accounting information queries, Using the record set of final SQL

  3. Designing the report, Identifying data analysis, Using the record set of final SQL

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

The process of generating accounting reports in access involves three steps: Designing the report, Identifying the accounting information queries, and finally creating an accounting report by using such queries.

Multiple choice business mathematics and statistics introduction to index number introduction to index numbers index numbers applied statistics

Price relatives computed by chain base method are called: 

  1. Price relatives

  2. Chain indices

  3. Link relatives

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

$\Rightarrow$  Price relatives computed by chain base method are called $Link\,\,relatives.$

$\Rightarrow$  Under this method, the base year’s price does not remain fixed but moves step from year to year. In other words, the immediately preceding year’s price becomes the base year’s price for each of the succeeding years.
$\Rightarrow$  Under this method, the base year’s price does not remain fixed but moves step from year to year. In other words, the immediately preceding year’s price becomes the base year’s price for each of the succeeding years.

$\Rightarrow$  $Chain\, index$ = $\dfrac{Average\, link\, relative\, of\, current\, year \times Chain\, index\, of\, previous\, year}{100}$

Multiple choice

Which of the following is NOT a feature of DynamoDB?

  1. It runs exclusively on Solid State Drives (SSDs).

  2. It is a Relational Database.

  3. It synchronously replicates data across 3 facilities within a Region.

  4. It offers seamless scaling with no downtime.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

DynamoDB is a NoSQL database service, not a relational database. Relational databases are typically managed via Amazon RDS.

Multiple choice biology main natural resources classification of threatened species red data book methods of conservation

Red data book keeps a record of:

  1. endangered plants, animals and other species

  2. endemic plants,animals and other species

  3. extinct plants,animals and other species

  4. imbalanced species

  5. None of these
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Red Data contains a complete list of threatened species of living organisms.

So, the correct option is 'endangered plants, animals and other species'.

Multiple choice biology main natural resources classification of threatened species red data book methods of conservation

What is Red Data Book?

  1. Red coloured book

  2. Book that maintains an international list of all endangered animal and plant species

  3. Book that maintains an international list of all endangered animal species

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

The Red Data Book is a list of endangered species. It is released by ICUN (The International Union for Conservation of Nature). It was first released in 1963.

A Red Data Book contains lists of species whose continued existence is threatened. Species are classified into different categories of perceived risk. Each Red Data Book usually deals with a specific group of animals or plants (reptiles, insects, mosses). They are now being published in many different countries and provide useful information on the threat status of the species. 
The red-listing assessment is a simple logical process to determine the status of the threat to a species based on available information.