Home
Current Affairs January 2024

What is the correct answer?

4

Checkpoints are a part of

A. Recovery measures.

B. Security measures.

C. Concurrency measures.

D. uthorization measures.

Correct Answer :

A. Recovery measures.


Related Questions

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

The drawback of shadow paging technique are

A. Commit overhead

B. Data fragmentation

C. Garbage collection

D. All of these

What is the correct answer?

4

Which of the following is not a logical database structure?

A. Chain

B. Network

C. Tree

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

An advantage of the database management approach is

A. data redundancy increases

B. data is dependent on programs

C. data is integrated and can be accessed by multiple programs

D. none of the above

What is the correct answer?

4

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

A. left outer join

B. right outer join

C. full outer join

D. inner join

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

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 keyword to eliminate duplicate rows from the query result in SQL is

A. DISTINCT

B. NO DUPLICATE

C. UNIQUE

D. None of the above

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

Which one is true statement :

A. With finer degree of granularity of locking a high degree of concurrency is possible.

B. Locking prevents non-serializable schedules.

C. Locking cannot take place at field level.

D. An exclusive lock on data item X is granted even if a shared lock is already held on X.

What is the correct answer?

4

A relational database developer refers to a record as

A. an attribute

B. a tuple

C. a criteria

D. a relation

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

What is the correct answer?

4

_____is a full form of SQL.

A. Standard query language

B. Sequential query language

C. Structured query language

D. Server side query language

What is the correct answer?

4

operator is used to compare a value to a list of literals values that have been specified.

A. Like

B. COMPARE

C. BETWEEN

D. IN

What is the correct answer?

4

Tree structures are used to store data in

A. Network model.

B. Relational model.

C. Hierarchical model.

D. File based system.

What is the correct answer?

4

An outstanding functionality of SQL is its support for automatic_____ to the target data.

A. programming

B. navigation

C. functioning

D. notification

What is the correct answer?

4

Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)

A. Create table Employee(EMPNO int, EMPNAME char(10));

B. Create table Employee(EMPNO integer, EMPNAME String(10));

C. Create table Emplo(EMPNO number, EMPNAME string);

D. Create table Emp(EMPNO int, EMPNAME char(10));

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 data type or format is specified for each _________

A. Relation

B. Tuple

C. Database

D. Domain

What is the correct answer?

4

If a transaction T has obtained an exclusive lock on item Q, then T can

A. read Q

B. write Q

C. both read and write Q

D. write Q but not read Q

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

Relations produced from an E-R model will always be

A. First normal form.

B. Second normal form.

C. Third normal form.

D. Fourth normal form.

What is the correct answer?

4

Data independence means

A. data is defined separately and not included in programs.

B. programs are not dependent on the physical attributes of data

C. programs are not dependent on the logical attributes of data

D. both B and C

What is the correct answer?

4

Change Staff table by removing default of Assistant for position column

A. ALTER TABLE Staff ALTER position DROP DEFAULT;

B. ALTER TABLE Staff ALTER position DEFAULT;

C. ALTER TABLE Staff ALTER DROP DEFAULT;

D. MODIFY Staff ALTER position DROP DEFAULT;

What is the correct answer?

4

_____ First proposed the process of normalization.

A. Edgar. W

B. Edward Stephen

C. Edgar F. Codd

D. Edward Codd

What is the correct answer?

4

A transaction is in state after the final statement has been executed.

A. partially committed

B. active

C. committed

D. none of the above

What is the correct answer?

4

Which of the following relational algebraic operations is not from set theory?

A. Union

B. Intersection

C. Cartesian Product

D. Select

What is the correct answer?

4

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 .

What is the correct answer?

4

In E-R Diagram total participation is represented by

A. Double lines

B. Single line

C. Dashed lines

D. Triangle