Home
Current Affairs January 2024

What is the correct answer?

4

Which two files are used during operation of the DBMS?

A. Query languages and utilities

B. DML and query language

C. Data dictionary and transaction log

D. Data dictionary and query language

Correct Answer :

C. Data dictionary and transaction log


Related Questions

What is the correct answer?

4

Which of the following is a reason to model data?

A. Understand each user's perspective of data

B. Understand the data itself irrespective of the physical representation

C. Understand the use of data across application areas

D. All of the above

What is the correct answer?

4

DBMS helps achieve

A. Centralized control of data

B. Data independence

C. Both A and B

D. Neither A nor B

What is the correct answer?

4

Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are

A. m+n and 0

B. m+n and |m-n|

C. mn and 0

D. mn and m+n

What is the correct answer?

4

What are the desirable properties of a decomposition

A. Partition constraint.

B. Dependency preservation.

C. Redundancy.

D. Security.

What is the correct answer?

4

E-R Modeling is achieved by using ____ diagrams

A. DFD

B. Flowcharts

C. Gantt Charts

D. E-R

What is the correct answer?

4

The graphical representation of a query is .

A. B-Tree

B. graph

C. Query Tree

D. directed graph

What is the correct answer?

4

By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).

A. Vulcanizing

B. Galvanizing

C. Magnetizing

D. Passing UV rays

What is the correct answer?

4

The _____ category includes storage media that can be operated on directly by the computers central processing unit.

A. Primary storage

B. Secondary Storage

C. All

D. Tertiary Storage

What is the correct answer?

4

………………… approach reduces time and effort required for design and lesser risk in database management.

A. Single global database

B. Multiple databases

C. Top-down approach

D. None of the above

What is the correct answer?

4

In multiple granularity of locks SIX lock is compatible with

A. IX

B. IS

C. S

D. SIX

What is the correct answer?

4

Cascading rollback is avoided in all protocol except

A. strict two-phase locking protocol.

B. tree locking protocol

C. two-phase locking protocol

D. validation based protocol.

What is the correct answer?

4

The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree

A. m - 1

B. m + 1

C. m * m

D. m

What is the correct answer?

4

Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are

A. distinct values

B. cannot have NULL

C. both (A) & (B)

D. same as primary key

What is the correct answer?

4

The statement that is executed automatically by the system as a side effect of the modification of the database is

A. backup

B. assertion

C. recovery

D. trigger

What is the correct answer?

4

A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an

A. 2NF

B. 3NF

C. BCNF

D. 1NF

What is the correct answer?

4

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

What is the correct answer?

4

The default level of consistency in SQL is

A. repeatable read

B. read committed

C. read uncommitted

D. serializable

What is the correct answer?

4

The full form of GUI is _________

A. Government Union Internet

B. Graphical Unit Interface

C. Graphical User Interface

D. Graphical University Interface

What is the correct answer?

4

Which of the following ensures the atomicity of the transaction?

A. Transaction management component of DBMS

B. Application Programmer

C. Concurrency control component of DBMS

D. Recovery management component of DBMS

What is the correct answer?

4

In 2NF

A. No functional dependencies (FDs) exist.

B. No multivalued dependencies (MVDs) exist.

C. No partial FDs exist.

D. No partial MVDs exist.

What is the correct answer?

4

A table can have only one

A. Secondary key

B. Alternate key

C. Unique key

D. Primary key

What is the correct answer?

4

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

A. Update Anomaly

B. Insertion Anomaly

C. Redundancy

D. Lost update problem

What is the correct answer?

4

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

What is the correct answer?

4

The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.

A. Clustered

B. Hashed

C. Un-clustered

D. Collision

What is the correct answer?

4

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

A. Lost update problem.

B. Update anomaly.

C. Unrepeatable read.

D. Dirty read.

What is the correct answer?

4

Which of the following is not a characteristic of a relational database model?

A. Table

B. Tree like structure

C. Complex logical relationship

D. Records

What is the correct answer?

4

Which of the following is not comparison operator?

A. <>

B. <

C. =<

D. >=

What is the correct answer?

4

Relational Algebra does not have

A. Selection operator.

B. Projection operator.

C. Aggregation operators.

D. Division operator.

What is the correct answer?

4

Drop Table cannot be used to drop a table referenced by a ______ constraint.

A. Primary Key

B. Local Key

C. Foreign Key

D. Composite Key

What is the correct answer?

4

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.