Introduction To Database Questions and Answers

Q: Hierarchical model is also called

Correct answer: Tree structureThe hierarchical model organises records into a tree: every record type except the root has exactly one parent, and access is by navigating down from the root. That single-parent rule is its limitation - a many-to-many relationship cannot be represented without duplicating data - and it is what the network model, a “plex” or graph structure, was devised to relax.

Q: Relational Algebra is

Correct answer: Procedural query LanguageRelational algebra is procedural: an expression specifies a sequence of operations - select, then project, then join - and so says how the result is to be obtained. Relational calculus and SQL are declarative by contrast.

Q: Key to represent relationship between tables is called

Correct answer: foreign keyA foreign key is a column whose values must appear as a primary key in another table, and that requirement is what represents the relationship between the two. A primary key identifies rows within one table only.

Q: DBMS should provide following feature(s) ______.

Correct answer: All of theseA DBMS must do all three: protect data against a system crash, through logging and recovery; keep the stored information safe, through backup and integrity constraints; and restrict access to authorised users. These are among the central reasons for using a DBMS instead of ordinary files.

Q: The property / properties of a database is / are :

Correct answer: All of the aboveAll three are defining properties. A database is an integrated collection of logically related records; it consolidates what used to be separate files into a common pool; and the data in it is independent of the programs that use it, so the storage can change without rewriting the applications.

Q: What does DDL stand for in SQL ?

Correct answer: Data Definition LanguageDDL comprises the statements that define and alter database structure, such as CREATE, ALTER and DROP. DML, the Data Manipulation Language, covers the statements that work on the rows themselves.

Q: DBMS stands for __________.

Correct answer: Database Management SystemDBMS is Database Management System: the software that stores, retrieves, updates and administers the data, and enforces the rules that keep it consistent.

Q: Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.

Correct answer: TrueBefore the database era, data was held in separate files, each written for one application, and largely on magnetic tape - which allows only sequential access. The consequences were duplicated data, inconsistency between files, and applications that broke whenever a file’s layout changed. Those problems are what databases were invented to solve.

Q: A relational database developer refers to a record as

Correct answer: a tupleIn relational terminology a row is a tuple, a column is an attribute, and the table as a whole is a relation.

81.

Hierarchical model is also called

A.Tree structure
B.Plex Structure
C.Normalize Structure
D.Table Structure

Answer: A

Correct answer: Tree structure

The hierarchical model organises records into a tree: every record type except the root has exactly one parent, and access is by navigating down from the root. That single-parent rule is its limitation - a many-to-many relationship cannot be represented without duplicating data - and it is what the network model, a “plex” or graph structure, was devised to relax.

Discuss in Forum

82.

Relational Algebra is

A.Data Definition Language
B.Meta Language
C.Procedural query Language
D.None of the above

Answer: C

Correct answer: Procedural query Language

Relational algebra is procedural: an expression specifies a sequence of operations - select, then project, then join - and so says how the result is to be obtained. Relational calculus and SQL are declarative by contrast.

Discuss in Forum

83.

Key to represent relationship between tables is called

A.Primary key
B.Secondary Key
C.Foreign Key
D.None of these

Answer: C

Correct answer: foreign key

A foreign key is a column whose values must appear as a primary key in another table, and that requirement is what represents the relationship between the two. A primary key identifies rows within one table only.

Discuss in Forum

84.

DBMS should provide following feature(s) ______.

A.Protect data from system crash
B.All of these
C.Safety of the information stored
D.Authorized access

Answer: B

Correct answer: All of these

A DBMS must do all three: protect data against a system crash, through logging and recovery; keep the stored information safe, through backup and integrity constraints; and restrict access to authorised users. These are among the central reasons for using a DBMS instead of ordinary files.

Discuss in Forum

85.

The property / properties of a database is / are :

A.It is an integrated collection of logically related records.
B.It consolidates separate files into a common pool of data records.
C.Data stored in a database is independent of the application programs using it
D.All of the above

Answer: D

Correct answer: All of the above

All three are defining properties. A database is an integrated collection of logically related records; it consolidates what used to be separate files into a common pool; and the data in it is independent of the programs that use it, so the storage can change without rewriting the applications.

Discuss in Forum

86.

What does DDL stand for in SQL ?

A.Data Definition Language
B.Data Description Logic
C.Dynamic Data Language
D.Database Design Layer

Answer: A

Correct answer: Data Definition Language

DDL comprises the statements that define and alter database structure, such as CREATE, ALTER and DROP. DML, the Data Manipulation Language, covers the statements that work on the rows themselves.

Discuss in Forum

87.

DBMS stands for __________.

A.None of these
B.Database Administrator System
C.Database Basic Management System
D.Database Management System

Answer: D

Correct answer: Database Management System

DBMS is Database Management System: the software that stores, retrieves, updates and administers the data, and enforces the rules that keep it consistent.

Discuss in Forum

88.

Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.

A.True
B.False
C.None of the Above.
D.All of the Above.

Answer: A

Correct answer: True

Before the database era, data was held in separate files, each written for one application, and largely on magnetic tape - which allows only sequential access. The consequences were duplicated data, inconsistency between files, and applications that broke whenever a file’s layout changed. Those problems are what databases were invented to solve.

Discuss in Forum

89.

A relational database developer refers to a record as

A.A criteria.
B.A relation.
C.A tuple.
D.An attribute.

Answer: C

Correct answer: a tuple

In relational terminology a row is a tuple, a column is an attribute, and the table as a whole is a relation.

Discuss in Forum

90.

An advantage of the database management approach is

A.Data is dependent on programs
B.Data redundancy increases.
C.Data is integrated and can be accessed by multiple programs.
D.None of the above

Answer: C

Correct answer: data is integrated and can be accessed by multiple programs

The point of the database approach is that data is held once, in one place, and shared: many programs read the same integrated store instead of each keeping its own file. Redundancy falls rather than rises, and the data becomes independent of the programs.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: Introduction To Database Questions and Answers || Introduction To Database MCQ Questions and Answers || Introduction To Database GK Questions and Answers || Introduction To Database GK MCQ Questions || Introduction To Database Multiple Choice Questions and Answers || Introduction To Database GK || GK on Introduction To Database || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

Introduction To Database Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications