Home
Current Affairs January 2024

What is the correct answer?

4

The normal form that is not necessarily dependency preserving is

A. 2NF

B. 3NF

C. BCNF

D. 4NF

Correct Answer :

A. 2NF


Related Questions

What is the correct answer?

4

______defines the structure of a relation which consists of a fixed set of attribute-domain pairs.

A. Instance

B. Program

C. Schema

D. Super Key

What is the correct answer?

4

The cost of reading and writing temporary files while evaluating a query can be reduced by

A. building indices

B. pipelining

C. join ordering

D. none of the above

What is the correct answer?

4

What is data integrity?

A. It is the data contained in database that is non redundant.

B. It is the data contained in database that is accurate and consistent.

C. It is the data contained in database that is secured.

D. It is the data contained in database that is shared.

What is the correct answer?

4

In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by

A. jamming

B. password

C. documentation

D. record lock

What is the correct answer?

4

In a relational schema, each tuple is divided into fields called

A. Relations

B. Queries

C. Domains

D. All of the above

What is the correct answer?

4

A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.

A. Sub

B. Parent

C. Candidate

D. Super

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

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

Which of the following addressing modes permits relocation without any change over in the code?

A. Indirect addressing

B. Indexed addressing

C. PC relative addressing

D. Base register addressing

What is the correct answer?

4

According to the levels of abstraction, the schema at the intermediate level is called

A. Logical schema.

B. Physical schema.

C. Subschema.

D. None of the above.

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

In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :

A. Operationally, if Y is deleted, so is X

B. existence is dependent on Y.

C. Operationally, if X is deleted, so is Y.

D. Operationally, if X is deleted, & remains the same.

What is the correct answer?

4

Which of the following is not a recovery technique?

A. Deferred update

B. Immediate update

C. Two-phase commit

D. Shadow paging

What is the correct answer?

4

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

What is the correct answer?

4

HSAM stands for ……….

A. Hierarchic Standard Access Method

B. Hierarchic Sequential Access Method

C. Hierarchic Sequential and Method

D. Hierarchic Standard and Method

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

DROP is a statement in SQL.

A. Query

B. Embedded SQL

C. DDL

D. DCL

What is the correct answer?

4

_____ is a utility to capture a continuous record of server activity and provide auditing capability.

A. SQL server Profile

B. SQL server wizard.

C. SQL server service manager

D. SQL server setup

What is the correct answer?

4

The set of all values that can be taken by the attribute is called as _______ of the attribute.

A. Tuple

B. Cardinality

C. Degree

D. Domain

What is the correct answer?

4

Shadow paging has

A. no redo

B. no undo

C. redo but no undo

D. neither redo nor undo

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

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

Which is the best file organization when data is frequently added or deleted from a file?

A. Sequential

B. Direct

C. Index sequential

D. None of the above

What is the correct answer?

4

Immediate database modification technique uses

A. Both undo and redo.

B. Undo but no redo.

C. Redo but no undo.

D. Neither undo nor redo.

What is the correct answer?

4

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

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

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

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

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

A logical schema

A. is the entire database

B. Describes how data is actually stored on disk.

C. is a standard way of organizing information into accessible parts.

D. All of the above