Introduction To Database Questions and Answers

Q: The XML family of standards is very important in database processing today.

Correct answer: TrueXML matters in database processing as the standard way of moving structured data between systems that share no common database: web services, business-to-business exchange, configuration and document storage. Most DBMS products now store and query XML directly, and the family of related standards - XPath, XSLT, XML Schema - goes with it.

Q: Long form of DBA is ______________.

Correct answer: Database AdministratorDBA stands for Database Administrator - the person responsible for a database’s structure, security, backup and recovery, performance and users. The role is distinct from that of the developers who write the applications above it.

Q: Which of the following is considered as DBMS ?

Correct answer: All of theseOracle, FoxPro and Access are all database management systems - enterprise, legacy PC and desktop respectively. They differ in scale and capability, not in kind.

Q: Which of the following is an advantage of view?

Correct answer: All of the aboveA view gives all three. Security: users can be granted access to the view and not to the underlying table, so they see only certain rows or columns. Derived columns: a view can compute values that are not stored. Simplicity: a complex join can be defined once and then queried as though it were a single table.

Q: In a database, data is stored in spreadsheets which have rows and columns.

Correct answer: FalseData is stored in tables (relations), which have rows and columns. A spreadsheet also has rows and columns, but that resemblance is superficial: a table has a defined structure, typed columns, keys, and relationships to other tables, and is managed by a DBMS that enforces all of it.

Q: It is better to use files than a DBMS when there are

Correct answer: Stringent real-time requirementsA DBMS adds layers - query processing, locking, logging - and with them latency that is hard to bound. Where an application must guarantee a response within a few microseconds, direct file access is more predictable. The other two options are arguments for a DBMS, not against: concurrent access and complex relationships are exactly what it exists to manage.

Q: Which of the following products implemented the CODASYL DBTG model?

Correct answer: IDMSIDMS implemented the CODASYL DBTG network model, the dominant pre-relational approach, in which records are linked by explicit sets and navigated pointer by pointer. It is still in use on mainframes. DB2 is relational; dBase-II and R:base were PC products.

Q: The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.

Correct answer: FalseThe one ranked hardest to use is Oracle, not SQL Server. SQL Server sits between Access and Oracle: an enterprise product, but a more approachable one to administer.

101.

A primary key if combined with a foreign key creates

A.Parent-Child relationship between the tables that connect them.
B.Many to many relationship between the tables that connect them.
C.Network model between the tables that connect them.
D.None of the above.

Answer: A

Correct answer: Parent-Child relationship between the tables that connect them.

A foreign key must match a primary key in another table, which makes that table the parent and this one the child. The result is a one-to-many relationship, and it lets the DBMS enforce referential integrity: no child row may refer to a parent that does not exist.

Discuss in Forum

102.

The XML family of standards is very important in database processing today.

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

Answer: A

Correct answer: True

XML matters in database processing as the standard way of moving structured data between systems that share no common database: web services, business-to-business exchange, configuration and document storage. Most DBMS products now store and query XML directly, and the family of related standards - XPath, XSLT, XML Schema - goes with it.

Discuss in Forum

103.

Long form of DBA is ______________.

A.Database Application
B.None of these
C.Database Admin
D.Database Administrator

Answer: D

Correct answer: Database Administrator

DBA stands for Database Administrator - the person responsible for a database’s structure, security, backup and recovery, performance and users. The role is distinct from that of the developers who write the applications above it.

Discuss in Forum

104.

Which of the following is considered as DBMS ?

A.Oracle
B.Foxpro
C.All of these
D.Access

Answer: C

Correct answer: All of these

Oracle, FoxPro and Access are all database management systems - enterprise, legacy PC and desktop respectively. They differ in scale and capability, not in kind.

Discuss in Forum

105.

Which of the following is an advantage of view?

A.Data security
B.Derived columns
C.Hiding of complex queries
D.All of the above

Answer: D

Correct answer: All of the above

A view gives all three. Security: users can be granted access to the view and not to the underlying table, so they see only certain rows or columns. Derived columns: a view can compute values that are not stored. Simplicity: a complex join can be defined once and then queried as though it were a single table.

Discuss in Forum

106.

In a database, data is stored in spreadsheets which have rows and columns.

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

Answer: B

Correct answer: False

Data is stored in tables (relations), which have rows and columns. A spreadsheet also has rows and columns, but that resemblance is superficial: a table has a defined structure, typed columns, keys, and relationships to other tables, and is managed by a DBMS that enforces all of it.

Discuss in Forum

107.

It is better to use files than a DBMS when there are

A.Stringent real-time requirements
B.Multiple users wish to access the data
C.Complex relationships among data
D.All of the above.

Answer: B

Correct answer: Stringent real-time requirements

A DBMS adds layers - query processing, locking, logging - and with them latency that is hard to bound. Where an application must guarantee a response within a few microseconds, direct file access is more predictable. The other two options are arguments for a DBMS, not against: concurrent access and complex relationships are exactly what it exists to manage.

Discuss in Forum

108.

Which of the following products implemented the CODASYL DBTG model?

A.IDMS
B.DB2
C.dBase-II
D.R:base

Answer: A

Correct answer: IDMS

IDMS implemented the CODASYL DBTG network model, the dominant pre-relational approach, in which records are linked by explicit sets and navigated pointer by pointer. It is still in use on mainframes. DB2 is relational; dBase-II and R:base were PC products.

Discuss in Forum

109.

The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.

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

Answer: B

Correct answer: False

The one ranked hardest to use is Oracle, not SQL Server. SQL Server sits between Access and Oracle: an enterprise product, but a more approachable one to administer.

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