Home
Current Affairs January 2024

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

Correct Answer :

C. foreign key


Related Questions

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

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

Relationships among relationships can be represented in an-E-R model using

A. Aggregation

B. Association

C. Weak entity sets

D. Weak relationship sets

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 drawback of shadow paging technique are

A. Commit overhead

B. Data fragmentation

C. Garbage collection

D. All of these

What is the correct answer?

4

Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R.

A. It will result in a deadlock situation.

B. It will immediately be rejected.

C. It will immediately be granted.

D. It will be granted as soon as it is released by A .

What is the correct answer?

4

Which normal form is considered adequate for normal relational database design?

A. 2NF

B. 5NF

C. 4NF

D. 3NF

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

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

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

A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an

A. 2NF

B. 3NF

C. BCNF

D. 1NF

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

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

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

DROP is a statement in SQL.

A. Query

B. Embedded SQL

C. DDL

D. DCL

What is the correct answer?

4

In 2NF

A. No functional dependencies (FDs) exist.

B. No multivalued dependencies (MVDs) exist.

C. No partial FDs exist.

D. No partial MVDs exist.

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

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

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

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

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

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

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

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

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

Which of the following relational algebraic operations is not from set theory?

A. Union

B. Intersection

C. Cartesian Product

D. Select

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

Create a table with the following attributes: Employee(EMPNO integer, EMPNAME of 10 characters)

A. Create table Employee(EMPNO int, EMPNAME char(10));

B. Create table Employee(EMPNO integer, EMPNAME String(10));

C. Create table Emplo(EMPNO number, EMPNAME string);

D. Create table Emp(EMPNO int, EMPNAME char(10));

What is the correct answer?

4

The _____ category includes storage media that can be operated on directly by the computers central processing unit.

A. Primary storage

B. Secondary Storage

C. All

D. Tertiary Storage