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 applications generally accepted accounting principles (gaap) distinction between accounting and book-keeping distinction between book-keeping and accounting meaning and objectives of accounting

Book keeping is mainly concerned with which of the following features?

  1. It is concerned with financial data recording.

  2. It is concerned with designing the systems of recording, classifying and summarizing the recorded data.

  3. It is concerned with data interpreting for internal and external users.

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

Book keeping and accounting terms are normally used as interchangeably but actually this is not the case. Book keeping is basically concerned with recording of a transaction in books of account of any business. It is to be noted that only financial data are to be recorded.

Multiple choice trend analysis tools for financial analysis analysis of financial statements financial statement analysis accountancy

Financial data can be made more comprehensive by _______________.

  1. Charts

  2. Graphs

  3. Diagrams

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

Financial analysis can be made more comprehensive by charts, graphs and diagrams. It will be more comprehensive as all the elements will be covered and will be easier for the users of the financial statements to understand the same. 

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

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

The data type describing the types of values (such as text value, numeric values, data values, currency value, etc.) that can appear in each column is called a ________, which is a set of indivisible values.

  1. Tuple

  2. Domain

  3. Attriibute

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

The data type describing the types of values (such as text value, numeric values, data values, currency value, etc.) that can appear in each column is called a domain. A domain is a set of indivisible values.

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

A __________ is a set of tuples wherein each tuple is an ordered list of values corresponding to attributes of relation.

  1. Data

  2. Relation

  3. Database

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

A relation represents an entity type. A relation (or relation state) is a set of tuples wherein each tuple is an ordered list of values corresponding to attributes of relation.

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

Each row of a table is called a _________, in relational data model.

  1. Data record

  2. Data table

  3. Data system

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

The relational data model represents the database as collection of relations, which resembles a table of values (or data table). The table name and column names are used to help in interpreting the meaning of values in each row. Each row of a table is called a data record.