DBMS is a collection of _____ that enables user to create and maintain a database.

Question

DBMS is a collection of _____ that enables user to create and maintain a database.

A. Keys

B. Program

C. Translators

D. Language Activity

Share this question with your friends

Show all DBMS MCQ

Comment

Which of the following is true for network structure?

A. It is a physical representation of the data.

B. It allows many to many relationship.

C. It is conceptually simple.

D. It will be the dominant database of the future.

Discuss this answer

The graphical representation of a query is .

A. B-Tree

B. graph

C. Query Tree

D. directed graph

Discuss this answer

The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.

A. Data Manipulation

B. Data Definition

C. Data Control

D. None

Discuss this answer

The _______ is a set of programs to use and / or modify this data.

A. DBMS

B. System

C. Program

D. Software

Discuss this answer

______is a preferred method for enforcing data integrity

A. Constraints

B. Triggers

C. Stored procedure

D. Cursors

Discuss this answer

Which of the following concurrency control schemes is not based on the serializability property?

A. Two - phase locking

B. Graph-based locking

C. Time-stamp based locking

D. None of these .

Discuss this answer

Protection of data from unauthorized Disclosure results in loss of _______

A. Integrity

B. Availability

C. Confidentiality

D. Discretionary Security

Discuss this answer

As per equivalence rules for query transformation, selection operation distributes over

A. Union.

B. Set difference.

C. Intersection.

D. All of the above.

Discuss this answer

The normalization was first proposed by .

A. Code

B. Codd

C. Boyce Codd

D. Boyce

Discuss this answer

A table can have only one

A. Secondary key

B. Alternate key

C. Unique key

D. Primary key

Discuss this answer

The transactions like adding an employee, enrolling a student in a course are examples of _______

A. Logical

B. Physical

C. None

D. Theoretical

Discuss this answer

What are the desirable properties of a decomposition

A. Partition constraint.

B. Dependency preservation.

C. Redundancy.

D. Security.

Discuss this answer

Which of the following is not comparison operator?

A. <>

B. <

C. =<

D. >=

Discuss this answer

If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is

A. M:N

B. M:1

D. 1:M

Discuss this answer

A data type or format is specified for each _________

A. Relation

B. Tuple

C. Database

D. Domain

Discuss this answer

Wait-for graph is used for

A. detecting view serializability.

B. detecting conflict serializability.

C. deadlock prevention

D. deadlock detection

Discuss this answer

A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.

A. Direct

B. Indirect

C. Existence

D. No

Discuss this answer

If the closure of an attribute set is the entire relation then the attribute set is a

A. superkey

B. candidate key

C. primary key

D. not a key

Discuss this answer

Precedence graphs help to find a

A. Serializable schedule.

B. Recoverable schedule.

C. Deadlock free schedule.

D. Cascadeless schedule.

Discuss this answer

Which of the following is not a consequence of non-normalized database?

A. Update Anomaly

B. Insertion Anomaly

C. Redundancy

D. Lost update problem

Discuss this answer

Which of the following is not a recovery technique?

A. Deferred update

B. Immediate update

C. Two-phase commit

D. Shadow paging

Discuss this answer

Which of the following is not a consequence of concurrent operations?

A. Lost update problem.

B. Update anomaly.

C. Unrepeatable read.

D. Dirty read.

Discuss this answer

The part of a database management system which ensures that the data remains in a consistent state is

A. authorization and integrity manager

B. buffer manager

C. transaction manager

D. file manager

Discuss this answer

Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.

A. 1:1

B. 1: Many

C. Many: One

D. Many : Many

Discuss this answer

_____is a full form of SQL.

A. Standard query language

B. Sequential query language

C. Structured query language

D. Server side query language

Discuss this answer

Which normal form is considered adequate for normal relational database design?

A. 2NF

B. 5NF

C. 4NF

D. 3NF

Discuss this answer

_____ database is used to provide statistical information or summaries of values based on various criteria.

A. Statistical

B. Mathematical

C. Normalized

D. Un normalized

Discuss this answer

The collection of information stored in a database at a particular moment is called as ......

A. schema

B. instance of the database

C. data domain

D. independence

Discuss this answer

The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.

A. Schema

B. Tuple

C. Domain

D. Relational

Discuss this answer

Manager salary details are hidden from the employee .This is

A. Conceptual level data hiding.

B. External level data hiding.

C. Physical level data hiding.

D. None of these.

Discuss this answer

Accepted Answer

B. Program

DBMS is a collection of _____ that enables user to create and maintain a database.

Correct Answer :

Show all DBMS MCQ

Related Questions

Which of the following is true for network structure?

The graphical representation of a query is .

The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.

The _______ is a set of programs to use and / or modify this data.

______is a preferred method for enforcing data integrity

Which of the following concurrency control schemes is not based on the serializability property?

Protection of data from unauthorized Disclosure results in loss of _______

As per equivalence rules for query transformation, selection operation distributes over

The normalization was first proposed by .

A table can have only one

The transactions like adding an employee, enrolling a student in a course are examples of _______

What are the desirable properties of a decomposition

Which of the following is not comparison operator?

If both the functional dependencies : X�Y and Y�X hold for two attributes X and Y then the relationship between X and Y is

A data type or format is specified for each _________

Wait-for graph is used for

A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE.

If the closure of an attribute set is the entire relation then the attribute set is a

Precedence graphs help to find a

Which of the following is not a consequence of non-normalized database?

Which of the following is not a recovery technique?

Which of the following is not a consequence of concurrent operations?

The part of a database management system which ensures that the data remains in a consistent state is

Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation.

_____is a full form of SQL.

Which normal form is considered adequate for normal relational database design?

_____ database is used to provide statistical information or summaries of values based on various criteria.

The collection of information stored in a database at a particular moment is called as ......

The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint.

Manager salary details are hidden from the employee .This is

Also checkout