Database Management Questions and Answers

Software Programming : Database Management QUESTIONS AND ANSWERS :: part7 : 6 to 10

Following Software Programming language Entrance Multiple choice objective type questions and answers will help you in Software Programming 2024 examinations :

6.Check pointing when used in conjunction with incremental log reduces the actual recovery time. However, for proper recovery the system must ensure that (choose the correct one)

At the time of check pointing there is no incomplete transaction

If the updates are deferred, at the time of check pointing there is no incomplete transaction

If updates are immediate, at the time of check pointing there is no incomplete transaction

At the time of check pointing there exists an incomplete transaction

All of the above.

7.Embedded SQL means

Using the EMBED key word in a SQL statement

Writing a SQL statement to retrieve data from more than one relation

Writing SQL statements within codes written in a general programming language

Specifying a condition and action to be taken in case the given condition is satisfied in a trigger

Using SQL language constructs like revoke and grant respectively for revoking and granting privileges to users.

8.�When a very large record of a file is allocated to disk blocks, some unused spaces will remain and to utilize this unused space, parts of records can be allocated. Each and every part belongs to a record and is referenced through a pointer.� A record organization which has been distributed as parts among unused spaces of blocks and using a pointer to reference them is called

Blocking factor

Spanned record

Separator

Variable length record

BLOB.

9.�In 1978 committee proposed a generalized framework for database systems and it provides a three_level architecture. The of the architecture defines user views of the database. The defines the physical view of the database. The defines the logical schema of the database.� Which of the following set is suitable to fill the blanks in the above paragraph?

i. ANSI/ARPANET

Conceptual Level

External Level

Internal Level

i. ANSI/SPARC

10.The methodology for documenting databases illustrating the relationship between various entities in the database is

Data flow diagram

State transition diagram

Entity-relationship diagram

Entity sequence diagram

Object model.

More Database Management QUESTIONS AND ANSWERS available in next pages