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

Multiple choice classification of computer introduction to the information age physics

In functional composition, what is done with data flow diagrams _____________.

  1. Is ignored

  2. Is portioned according to the "closeness" of data grams and data storage s items

  3. Is partitioned according to the logical "closeness" of the actigrams

  4. Bother a and c
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In functional composition, what is done with data flow diagrams Is ignored and partitioned according to the logical "closeness" of the actigrams.

Flow diagrams in general are usually designed using simple symbols such as a rectangle, an oval or a circle depicting a processes, data stored or an external entity, and arrows are generally used to depict the data flow from one step to another. A DFD usually comprises of four components.

A data flow diagram (DFD) is a graphical representation of the "flow" of data through an information system, modelling its process aspects. A DFD is often used as a preliminary step to create an overview of the system without going into great detail, which can later be elaborated.

A context diagram is a top level (also known as "Level 0") data flow diagram. It only contains one process node ("Process 0") that generalizes the function of the entire system in relationship to external entities. DFD Layers. Draw data flow diagrams can be made in several nested layers.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

In relational data model column header is called as_________.

  1. domain

  2. tuple

  3. relation

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

In the relational data model, a column header represents an attribute of the entity. Since 'attribute' is not listed as an option, 'None of the above' is the correct choice.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

A column header is called an __________, in relational data model.

  1. Domain

  2. Tuple

  3. Attribute

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

In relational data model, the table name and column names are used to help in interpreting the meaning of values in each row. All values in a column, which belong to a particular domain, are of same data type. A column header is called an attribute.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

In database, the ___________ implies that distinct tables have been logically organised and the purpose is to reduce or eliminate redundancy (or duplicity) and also to facilitate better data access.

  1. Shared property

  2. Integrated property

  3. Intellectual property

  4. Both B and C
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Database has two important properties (or characteristics): one is integrated and second is shared. Integrated property implies that distinct data tables have been logically organised. The purpose is to reduce or eliminate redundancy (or duplicity) and also to facilitate better data access.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

The ________ represents the database as collection of relations, which resembles a table of values (or data table).

  1. Relational data model

  2. ER model

  3. Data model

  4. Both A and B
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A relational database is a type of database that stores and provides access to data points that are related to one another. Relational databases are based on the relational model, an intuitive, straightforward way of representing data in tables.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

A row is called a _________, in relational data model.

  1. Domain

  2. Tuple

  3. Attribute

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

The relational data model represents a table of values (or data table). Each row of the table, therefore, represents a collection of related data values and hence typically corresponds to real world entity or relationship. Formally, a row is called a tuple.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

In database, __________ means that all those who are authorised to use data/information have access to relevant data.

  1. Shared property

  2. Integrated property

  3. Intellectual property

  4. Both A and B
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Database has two important properties (or characteristics): one is integrated and second is shared. The shared property means that all those who are authorised to use data/information have access to relevant data.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

__________ refers to data that have been processed and organised in a form, which is suitable for decision-making.

  1. Data

  2. Database

  3. Information

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

Information refers to data that have been processed and organised in a form, which is suitable for decision-making, The raw data processed in accordance with decision usefulness of a decision-maker becomes information.

Multiple choice accountancy application of electronic spreadsheet in accounting introduction and importance of ms excel micosoft office rational data model (rdm)

Among several representational models, __________ is the most popular and widely used in actual practice.

  1. ER Model

  2. Relational Data Model

  3. Data Model

  4. Both ER Model and Relational Data Model
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Among several representational models, Relational Data Model (RDM) is the most popular and widely used in actual practice. It represents the database as collection of relations, which resembles a table of values (or data table).