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

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 relation schemas and a set of integrity constraints.

  1. Relational database

  2. Relational database schema

  3. Relational schema

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

A relational database schema is a set of relation schemas and a set of integrity constraints. A relational database state is a set of relation state such that every relational database state satisfies the integrity constraints specified on relational database schema.

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

The ______ for binary relationship specifies the number of relationship instance that an entity can participate in. 

  1. Timeware based

  2. Computer based

  3. Liveware based

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

Cardinality ratios (computer based) for binary relationship specifies the number of relationship instance that an entity can participate in.

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

Which of the following statements are correct for Relational Data Model (RDM):
a. Relational Data Model (RDM) is the most popular and widely used in actual practice.
b. Relational data model represents the database as collection of relations, which resembles  a table of values. 

  1. Only "a" is correct.

  2. Only "b" is correct.

  3. Both "a" and "b" are correct.

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

The relational data model represents the database as collection of relations, which resembles 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. Among several representational models, Relational Data Model (RDM) is the most popular and widely used in actual practice. 

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

The value of each attribute of a relation must be an indivisible value and drawn out of possible values associated with its ________. 

  1. Entity

  2. Key

  3. Domain

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

The domain is one of the constraints, which can be specified on relational databases. The value of each attribute of a relational must be an indivisible value and drawn out of possible values associated with its domain. The value of an attributed, therefore, must conform to the data type associated with the domain.

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

A ________ state is a set of relation states such that every relational database state satisfies the integrity constraints specified on relational database schema.

  1. Accounting database

  2. Relational database

  3. data management

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

A relational database schema is a set of relation schemas and a set of integrity constraints. A relational database is a set of relation states such that every relational database state satisfies the integrity constraints specified on relational database schema.

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

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

  1. relational data

  2. entity integrity

  3. referential integrity

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

The relational model organizes data into tables (relations) consisting of rows and columns. This structure is the foundation of relational database management systems.

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

The two categories of operations on relational model are ______ and ______.

  1. Insert, Delete

  2. Updates, Retrieval

  3. Updates, Delete

  4. Retrieval, Insert
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A relational database schema is a set relation schemas and integrity constraints. It is a set of relation states such that relational database state satisfies the integrity constraints specified on relational database schema. There are two categories of operations on relational model: updates and retrieval. Update operation are of three basic types i.e. insert, delete and modify. Retrieval operation on relational data model does not cause violation of any integrity constraints.

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

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

  1. Forms

  2. Tables

  3. Pages

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

In database management systems like MS Access, reports are the specific object class designed to present data from tables or queries in a formatted, printable layout.

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

The object class which allows a database designer to create the data tables with their respective field names, data types is called ________.

  1. queries

  2. tables

  3. forms

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

Tables are the fundamental building blocks of a relational database, used to store data in rows and columns with defined field names and data types.

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

_______ are the object class which allows the designer to create an appropriate user interface to formally interact with the back end database, defined by the tables and queries.

  1. Forms

  2. Reports

  3. Pages

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

Forms provide the user interface in a database, allowing users to interact with the underlying data in tables and queries in a structured and user-friendly way.

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

Selecting reports from objects list provided by LHS of Database Window and clicking at New object button of tool bar is step ___ in procedure in access for designing a simple.

  1. 1

  2. 2

  3. 3

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

In standard MS Access procedures for creating a new object, selecting the object type and clicking the New button is the initial step to initiate the creation process.