Home
Current Affairs January 2024

What is the correct answer?

4

The language used in application programs to request data from the DBMS is referred to as the

A. DML

B. DDL

C. VDL

D. SDL

Correct Answer :

A. DML


Related Questions

What is the correct answer?

4

Select the incorrect statement(s)
i) Shared locks are compatible with each other.
ii) A relation which is in 3NF may have redundancy due to composite keys.
iii) A table in a database can have multiple indexes.

A. i only

B. ii, only

C. ii, iii only

D. none of the above

What is the correct answer?

4

Mail services are available to network users through the

A. Session layer

B. Presentation layer

C. Application layer

D. Transport layer

What is the correct answer?

4

Which of the following Key is used to represent relationship between the tables?

A. Primary key

B. Secondary Key

C. Foreign Key

D. None of these

What is the correct answer?

4

A relation which is in 3NF is

A. in 1NF also

B. in 2NF also

C. free from transitive dependencies

D. All of these

What is the correct answer?

4

What is the result of the following SQL statement ?
SELECT A.emp_Name, B.ph_num
FROM emp A LEFT OUTER JOIN phone B
ON A. emp_ID = B.emp_ID

A. A list of employees phone number

B. A list of all employees that have spouses, with phone number included in the list

C. A list of all employees names, including the phone number if they have one

D. Two lists : One list of employees, the other of phone numbers

What is the correct answer?

4

Attenuation can be also expressed in decibel dB) and commonly used because.
i) Signal strengths often fall off logarithmically
ii) Cascade losses and gains can be calculated with simple additions and subtractions

A. i only

B. ii only

C. Both A and B

D. None of the above

What is the correct answer?

4

…………… is responsible for using that the database remains in a consistent state despite system failure.

A. Storage manager

B. Admin

C. Transaction manager

D. none of the above

What is the correct answer?

4

Unwanted energy from source other than the transmitter.

A. Attenuation

B. Distortion

C. Delay

D. Noise

What is the correct answer?

4

A transaction which completes successfully is called

A. Granted

B. Committed

C. Compensated

D. Accomplished

What is the correct answer?

4

Which of the following is a classical approach to database design?

A. Left Right approach

B. Right Left approach

C. Top Down approach

D. Bottom Up approach

What is the correct answer?

4

In an Entity-Relationship Diagram Ellipses represents

A. Attributes

B. Weak entity set

C. Relationship sets

D. Multi-valued attributes

What is the correct answer?

4

An advantage of the database management approach is

A. data is dependent on programs.

B. data redundancy increases.

C. data is integrated and can be accessed by multiple programs.

D. none of the above.

What is the correct answer?

4

DBMS utility which allows to reconstruct the correct state of database from the backup and history of transactions

A. Backup

B. Recovery

C. Grant

D. Troubleshooting

What is the correct answer?

4

UML is stands for

A. Universal Modeling Language

B. Unified Modeling Language

C. United Modeling Language

D. Uni Modeling Language

What is the correct answer?

4

The race condition occurs when

A. Two concurrent processes attempt to interact with each other.

B. Two concurrent processes interact with different data files.

C. Two concurrent processes attempt to hold a data item .

D. none of the above.

What is the correct answer?

4

Technique(s) used for data recovery after any failure

A. Logging

B. Recovery manager

C. Both A and B are true

D. Both A and B are false

What is the correct answer?

4

The ________ states that a foreign key must either match a primary key value in another relation or it must be null.

A. entity integrity rule

B. referential integrity constraint

C. composite attribute

D. action assertion

What is the correct answer?

4

A data manipulation command the combines the records from one or more tables is called

A. SELECT

B. PROJECT

C. JOIN

D. PRODUCT

What is the correct answer?

4

The physical path over which a message travels

A. Thermal

B. Medium

C. Protocol

D. Impulse

What is the correct answer?

4

By default a user who has been granted some form of authorization

A. is allowed to pass them to others

B. is not allowed to pass them to others

C. may be or may not be allowed to pass them to others

D. none

What is the correct answer?

4

The physical location of a record is determined by a mathematical formula that transforms
a file key into a record location is :

A. B-Tree File

B. Hashed File

C. Indexed File

D. Sequential file.

What is the correct answer?

4

The command used to delete a particular column in a relation

A. UPDATE

B. DROP

C. ALTER

D. DELETE

What is the correct answer?

4

In a Hierarchical model records are organized as

A. Graph.

B. List.

C. Links.

D. Tree.

What is the correct answer?

4

Which of the following is also known as Offline storage ?

A. primary storage

B. secondary storage

C. tertiary storage

D. none of the above

What is the correct answer?

4

The language used in application programs to request data from the DBMS is referred to as the

A. DML

B. DDL

C. VDL

D. SDL

What is the correct answer?

4

If the .................... is too much, the receiver may not be able to detect the signal at all or the signal may fall below the noise level.

A. Noise

B. Delay

C. Dispersion

D. Attenuation

What is the correct answer?

4

Size of source and destination address in IP header

A. 4 bits

B. 8 bits

C. 12 bits

D. 32 bits

What is the correct answer?

4

DBMS helps achieve

A. Data independence

B. Centralized control of data

C. Neither A) nor B)

D. both A) and B)

What is the correct answer?

4

A fragmentation is categorized in

A. 1 part

B. 2 part

C. 3 part

D. 4 part

What is the correct answer?

4

A data dictionary contains:
i) The name of all fields in all files.
ii) The data type of all fields in all files.
iii) The width of all fields in all files.

A. only i)

B. only i) and ii)

C. only ii) and iii)

D. i) ii) iii)