Home
Current Affairs January 2024

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

Correct Answer :

C. Domain


Related Questions

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

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.

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

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

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

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

In SQL the word natural can be used with

A. inner join

B. full outer join

C. right outer join

D. all of the above

What is the correct answer?

4

When an E-R diagram is mapped to tables, the representation is redundant for

A. weak entity sets

B. weak relationship sets

C. strong entity sets

D. strong relationship sets

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

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

Dependency preservation is not guaranteed in

A. BCNF

B. 3NF

C. PJNF

D. DKNF

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

Processed data is called _____

A. Raw data

B. Source

C. Information

D. Useful data

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

A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems.

A. None

B. Multi

C. Single

D. Concurrent

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

Grant and revoke are _____ statements.

A. TCL

B. DCL

C. DDL

D. DML

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

For using a specific database …………… command is used.

A. use database

B. database name use

C. Both A & B

D. None of them

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

_____ 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

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

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

_____ 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

____specifies a search condition for a group or an aggregate.

A. GROUP BY Clause

B. HAVING Clause

C. FROM Clause

D. WHERE Clause

What is the correct answer?

4

_____ database is used to provide statistical information or summaries of values based on various criteria.

A. Statistical

B. Mathematical

C. Normalized

D. Un normalized

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

The normalization was first proposed by .

A. Code

B. Codd

C. Boyce Codd

D. Boyce

What is the correct answer?

4

Checkpoints are a part of

A. Recovery measures.

B. Security measures.

C. Concurrency measures.

D. uthorization measures.