Home
Current Affairs January 2024

What is the correct answer?

4

The clause alter table in SQL can be used to

A. add an attribute

B. delete an attribute

C. alter the default values of an attribute

D. all of the above

Correct Answer :

D. all of the above


Related Questions

What is the correct answer?

4

Which of the following relational algebra operations do not require the participating tables to be union-compatible?

A. Union

B. Intersection

C. Difference

D. Join

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

Dependency preservation is not guaranteed in

A. BCNF

B. 3NF

C. PJNF

D. DKNF

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

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

A. left outer join

B. right outer join

C. full outer join

D. inner join

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

The data in the database at a particular moment of time is called the _______

A. Snapshot

B. Dynaset

C. Stateless

D. Stateful

What is the correct answer?

4

Tree structures are used to store data in

A. Network model.

B. Relational model.

C. Hierarchical model.

D. File based system.

What is the correct answer?

4

Which of the following concurrency control schemes is not based on the serializability property?

A. Two - phase locking

B. Graph-based locking

C. Time-stamp based locking

D. None of these .

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

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

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

The normal form that is not necessarily dependency preserving is

A. 2NF

B. 3NF

C. BCNF

D. 4NF

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

The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.

A. OR

B. AND

C. NOT

D. ALL

What is the correct answer?

4

Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are

A. distinct values

B. cannot have NULL

C. both (A) & (B)

D. same as primary key

What is the correct answer?

4

In a relational schema, each tuple is divided into fields called

A. Relations

B. Queries

C. Domains

D. All of the above

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

_____ 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

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

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

A. Entity set

B. File

C. Entity instance

D. Organization

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

Maximum height of a B+ tree of order m with n key values is

A. Logm(n)

B. (m+n)/2

C. Logm/2(m+n)

D. None 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

A ______ module is typically designed so that it will run on a user workstation or personal computer.

A. Software

B. Server

C. Program

D. Client

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

____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

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