Home
Current Affairs January 2024

What is the correct answer?

4

Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.

A. Functional dependency

B. Multi-valued dependency

C. Transitive dependency

D. Partial dependency

Correct Answer :

B. Multi-valued dependency


Related Questions

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 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

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 normal form that is not necessarily dependency preserving is

A. 2NF

B. 3NF

C. BCNF

D. 4NF

What is the correct answer?

4

Precedence graphs help to find a

A. Serializable schedule.

B. Recoverable schedule.

C. Deadlock free schedule.

D. Cascadeless schedule.

What is the correct answer?

4

Wait-for graph is used for

A. detecting view serializability.

B. detecting conflict serializability.

C. deadlock prevention

D. deadlock detection

What is the correct answer?

4

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

A. View

B. Order by

C. Group by

D. Having

What is the correct answer?

4

Relational Algebra is

A. Data Definition Language .

B. Meta Language

C. Procedural query Language

D. None of the above

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

What is the correct answer?

4

The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______

A. Volatile

B. Non - Volatile

C. Logical

D. Physical

What is the correct answer?

4

Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.

A. RAM

B. Flash

C. Hard Disk

D. Secondary

What is the correct answer?

4

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

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

What will be the number of columns and rows respectively obtained for the operation, A- B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows

A. 4,0

B. 0,0

C. 4,5

D. 8,5

What is the correct answer?

4

The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.

A. Regular

B. Irregular

C. None

D. Weak

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

Which of the following statement on the view concept in SQL is invalid?

A. All views are not updateable

B. The views may be referenced in an SQL statement whenever tables are referenced.

C. The views are instantiated at the time they are referenced and not when they are defined.

D. The definition of a view should not have GROUP BY clause in it.

What is the correct answer?

4

Given the following relation S(SNO,SNAME,CITY) write a query to update the value of CITY to KANPUR for the supplier S1.

A. UPDATE S CITY = KANPUR WHERE SNO=S1

B. UPDATE S SET CITY = KANPUR FOR SNO=S1

C. UPDATE S SET CITY = KANPUR WHERE SNO=S1

D. UPDATE S RENAME CITY = KANPUR WHERE SNO=S1

What is the correct answer?

4

In SQL, testing whether a subquery is empty is done using

A. DISTINCT

B. UNIQUE

C. NULL

D. EXISTS

What is the correct answer?

4

In an E-R diagram double lines indicate

A. Total participation.

B. Multiple participation.

C. Cardinality N.

D. None of the above.

What is the correct answer?

4

Isolation of the transactions is ensured by

A. Transaction management

B. Application programmer

C. Concurrency control

D. Recovery management

What is the correct answer?

4

Whenever two independent one-to-many relationships are mixed in the same relation, a __________ arises.

A. Functional dependency

B. Multi-valued dependency

C. Transitive dependency

D. Partial dependency

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

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

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

_____ command can be used to modify a column in a table

A. alter

B. update

C. set

D. create

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

The metadata is created by the

A. DML compiler

B. DML pre-processor

C. DDL interpreter

D. Query interpreter

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