Home
Current Affairs January 2024

What is the correct answer?

4

In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by

A. jamming

B. password

C. documentation

D. record lock

Correct Answer :

D. record lock


Related Questions

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

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

SQL server stores index information in the _____system table

A. system indexes

B. syst indexes

C. sys indexes

D. sysind

What is the correct answer?

4

Which of the following constitutes a basic set of operations for manipulating relational data?

A. Predicate calculus

B. Relational calculus

C. Relational algebra

D. SQL

What is the correct answer?

4

By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1).

A. Vulcanizing

B. Galvanizing

C. Magnetizing

D. Passing UV rays

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

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

In b-tree the number of keys in each node is than the number of its children.

A. one less

B. same

C. one more

D. half

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

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

DFD stands for

A. Data Flow Document

B. Data File Diagram

C. Data Flow Diagram

D. Non of the above

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

According to the levels of abstraction, the schema at the intermediate level is called

A. Logical schema.

B. Physical schema.

C. Subschema.

D. None of the above.

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

The rule that a value of a foreign key must appear as a value of some specific table is called a

A. Referential constraint.

B. Index.

C. Integrity constraint.

D. Functional dependency.

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

Change Staff table by removing default of Assistant for position column

A. ALTER TABLE Staff ALTER position DROP DEFAULT;

B. ALTER TABLE Staff ALTER position DEFAULT;

C. ALTER TABLE Staff ALTER DROP DEFAULT;

D. MODIFY Staff ALTER position DROP DEFAULT;

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

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

A table can have only one

A. Secondary key

B. Alternate key

C. Unique key

D. Primary key

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

What is a disjoint less constraint?

A. It requires that an entity belongs to no more than one level entity set.

B. The same entity may belong to more than one level.

C. The database must contain an unmatched foreign key value.

D. An entity can be joined with another entity in the same level entity set.

What is the correct answer?

4

Relations produced from an E-R model will always be

A. First normal form.

B. Second normal form.

C. Third normal form.

D. Fourth normal form.

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

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

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 two files are used during operation of the DBMS?

A. Query languages and utilities

B. DML and query language

C. Data dictionary and transaction log

D. Data dictionary and query language

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 data models defined by ANSI/SPARC architecture are

A. Conceptual, physical and internal

B. Conceptual, view and external

C. Logical, physical and internal

D. Logical, physical and view

What is the correct answer?

4

The part of a database management system which ensures that the data remains in a consistent state is

A. authorization and integrity manager

B. buffer manager

C. transaction manager

D. file manager