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

____________ refers to some aspect of real world situation, for which database is to be designed.

  1. ER Design

  2. Reality

  3. Relational Data Model

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

Reality refers to some aspect of real world situation, for which database is to be designed. In the context of accounting, it is an accounting reality that is to be expressed with complete description.

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

A process of refining a database design through which the possibility of duplicate or redundant data items are reduced or eliminated is _______.

  1. ER design

  2. Refinement

  3. Reality

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

Normalisation is a process of refining a database design through which the possibility of duplicate or redundant data items are reduced or eliminated.

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

Which one of the following is a DataBase Management System?

  1. MS Access

  2. MS Excel

  3. MS Outlook

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

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. 

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

Which of the following has RDBMS?
i. Access
ii. Excel

  1. (i) and (ii)

  2. Only (i)

  3. Only (ii)

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

Microsoft  Excel and Access are Microsoft's two different application software. They both handle tabular data, but there are still many differences between them. Excel is a spreadsheet application program, but Access is a database program. 

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

Each of seven-object classes is contained in the named database file of access with _____ extension.

  1. JPG

  2. MDB

  3. PNG

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

Each seven-object classes is contained in the named database file of access with MDB extension. Whenever this file is opened, a database window, as shown on the next page, opens with all the above object classes available on the left hand side.  

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

______ object class is used to create various reports, the source of information content of which is based on tables, queries or both.

  1. Forms

  2. Reports

  3. Pages

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

Reports object class is used to create various reports, the source of information content of which is based on tables, queries or both. Such reports are designed in access according to the requirement of end-user.

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

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.