Home
Current Affairs January 2024

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

Correct Answer :

B. a tuple


Related Questions

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

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

Union operator is a :

A. Unary Operator

B. Ternary Operator

C. Binary Operator

D. Not an operator

What is the correct answer?

4

A _____ is used to define overall design of the database

A. code

B. data definition language

C. application program

D. schema

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

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

_____ 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 values of the attribute describes a particular

A. Entity set

B. File

C. Entity instance

D. Organization

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

Data items grouped together for storage purposes are called a

A. record

B. string

C. title

D. list

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

The relational model is based on the concept that data is organized and stored in two-dimensional tables called ______

A. Fields

B. Records

C. Relations

D. Keys

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

E-R Modeling is achieved by using ____ diagrams

A. DFD

B. Flowcharts

C. Gantt Charts

D. E-R

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

The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple.

A. Primary

B. Foreign

C. Candidate

D. Alternate

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 ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.

A. Data Manipulation

B. Data Definition

C. Data Control

D. None

What is the correct answer?

4

Protection of data from unauthorized Disclosure results in loss of _______

A. Integrity

B. Availability

C. Confidentiality

D. Discretionary Security

What is the correct answer?

4

In an ER diagram the ___shape specifies the Attibute and a ____ shape specifies the primary key attribute.

A. Oval; An oval with an underlined attribute

B. Circle; A circle with bolded attribute inside it

C. Diamond; A bolded attribute

D. Square; An attribute within the square

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

_____ 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

For correct behaviour during recovery, undo and redo operation must be

A. Commutative

B. Associative

C. idempotent

D. distributive

What is the correct answer?

4

Which of the following is not a consequence of non-normalized database?

A. Update Anomaly

B. Insertion Anomaly

C. Redundancy

D. Lost update problem

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

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

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

Which one is correct statement?
Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) C

A. (i) and (ii)

B. (iv) only

C. (i) and (iv)

D. (ii) and (iii)

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

______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