Home
Current Affairs January 2024

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

Correct Answer :

B. Direct


Related Questions

What is the correct answer?

4

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

A. DBMS

B. System

C. Program

D. Software

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

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

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

_____ 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

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

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

A. Union.

B. Set difference.

C. Intersection.

D. All of the above.

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

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

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

It is an abstraction through which relationships are treated as higher level entities

A. Generalization.

B. Specialization.

C. Aggregation.

D. Inheritance.

What is the correct answer?

4

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

A. Logical

B. Physical

C. None

D. Theoretical

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

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

_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS.

A. Star

B. llustar

C. SQL

D. Cygnus

What is the correct answer?

4

An advantage of views is

A. Data security

B. Derived columns

C. Hiding of complex queries

D. All of the above

What is the correct answer?

4

______is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

A. Domain Integrity Constraints

B. Referential Integrity Constraints

C. Domain Constraints

D. Entity Integrity Constraints

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

Relational Algebra does not have

A. Selection operator.

B. Projection operator.

C. Aggregation operators.

D. Division operator.

What is the correct answer?

4

Which of the following aggregate functions does not ignore nulls in its results?.

A. COUNT .

B. COUNT (*)

C. MAX

D. MIN

What is the correct answer?

4

In b-tree the number of keys in each node is than the number of its children.

A. one less

B. same

C. one more

D. half

What is the correct answer?

4

______is a preferred method for enforcing data integrity

A. Constraints

B. Triggers

C. Stored procedure

D. Cursors

What is the correct answer?

4

______contains information that defines valid values that are stored in a column or data type.

A. Default

B. Index

C. Rule

D. View

What is the correct answer?

4

The normal form that is not necessarily dependency preserving is

A. 2NF

B. 3NF

C. BCNF

D. 4NF

What is the correct answer?

4

If an entity can belong to only one lower level entity then the constraint is

A. disjoint

B. partial

C. overlapping

D. single

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

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.

What is the correct answer?

4

Data items grouped together for storage purposes are called a

A. record

B. string

C. title

D. list

What is the correct answer?

4

The one guideline to be followed while designing the database is

A. A database design may be ambiguous.

B. It should avoid/reduce the redundancy.

C. Unrelated data should be in the same table so that updating the data will be easy.

D. An entity should not have attributes.

What is the correct answer?

4

Key to represent relationship between tables is called

A. primary key

B. secondary key

C. foreign key

D. none of the above