Database Management System MCQs

The database system must take special actions to ensure that transactions operate properly without interference from concurrently executing database statements. This property is referred to as

The property of a transaction that persists all the crashes is

Transaction processing is associated with everything below except

The Oracle RDBMS uses the ____ statement to declare a new transaction start and its properties.

____ means that the data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

In SQL, which command is used to issue multiple CREATE TABLE, CREATE VIEW and GRANT statements in a single transaction?

In SQL, the CREATE TABLESPACE is used

Which character function can be used to return a specified portion of a character string?

Which of the following is TRUE for the System Variable $date$?

What are the different events in Triggers?

Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?

Which of the following SQL command can be used to modify existing data in a database table?

When SQL statements are embedded inside 3GL, we call such a program as

_______________ provides option for entering SQL queries as execution time, rather than at the development stage.

The storage structure which do not survive system crashes are ______

Storage devices like tertiary storage, magnetic disk comes under

For a transaction to be durable, its changes need to be written to ________ storage.

The unit of storage that can store one are more records in a hash file organization are

A ______ file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.

A file produced by a spreadsheet

Which of the following are the process of selecting the data storage and data access characteristics of the database?

Which of the following is the oldest database model?

The process of saving information onto secondary storage devices is referred to as

A transaction may not always complete its execution successfully. Such a transaction is termed

If an transaction is performed in a database and committed, the changes are taken to the previous state of transaction by

Each modification done in database transaction are first recorded into the

When the transaction finishes the final statement the transaction enters into

The name of the transaction file shall be provided by the operator and the file that contains the edited transactions ready for execution shall be called

Which of the following is an atomic sequence of database actions?

_______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

DBMS periodically suspends all processing and synchronizes its files and journals through the use of

Which of the following is not a state in transaction?

_______________ joins are SQL server default

The ________________ is essentially used to search for patterns in target string.

Which of the following is/are the Database server functions? i) Data management ii) Transaction management iii) Compile queries iv) Query optimization

To delete a database ___________ command is used

____________ is a combination of two of more attributes used as a primary key

Which of the following is not the function of client?

______________ requires that data should be made available to only authorized users.

Some of the utilities of DBMS are _____________ i) Loading ii) Backup iii) File organization iv) Process Organization

____________ allows individual row operation to be performed on a given result set or on the generated by a selected by a selected statement.

Which s essential a business problem not a data problem:

Which is primarily the result of a thorough understanding of information about an enterprise:

McFadden has defined normalization in his which book___________

The database design prevents some data from being represented due to _______

How many types of insertion anomalies:

Who developed the normalization process:

Which is a bottom-up approach to database design that design by examining the relationship between attributes:

Which is the process of breaking a relation into multiple relations:

Which formal method that locates and analyses relation schemas on the basis of their primary, candidate keys, and the FD’s that are present among the attributes of these schemas: