Data Manipulation Language DML) is not to

Question

Data Manipulation Language DML) is not to

A. Create information table in the Database

B. Insertion of new information into the Database

C. Deletion of information in the Database

D. Modification of information in the Database

Share this question with your friends

Show all Advance DBMS MCQ

Comment

The class based addressing is known as

A. Classless addressing

B. Classful addressing

C. Classified addressing

D. Classical addressing

Discuss this answer

Tertiary storage

A. magnetic tape

B. juke box

C. optical disk

D. All of the above

Discuss this answer

FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer

A. i and ii only

B. ii and iii only

C. i and iii only

D. iii and iv only

Discuss this answer

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

A. i and ii only

B. ii and iii only

C. i and iii only

D. All i, ii iii

Discuss this answer

Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.

A. i and ii only

B. ii and iii only

C. i and iii only

D. i only

Discuss this answer

Usenet is also known as

A. Newsgroups

B. 10Km to 1Km

C. 10^3Km to 100Km

D. 100M to 10M

Discuss this answer

Aggregate functions are also called

A. serial functions

B. non-serial functions

C. row functions

D. column functions

Discuss this answer

Generalization is a

A. top-down approach.

B. bottom-up approach.

C. left-right approach.

D. none of the above

Discuss this answer

The ability to modify the conceptual schema without causing any change to the application program is known as

A. Physical data independence

B. Logical data independence

C. External data independence

D. Static data

Discuss this answer

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

Discuss this answer

UML is stands for

A. Universal Modeling Language

B. Unified Modeling Language

C. United Modeling Language

D. Uni Modeling Language

Discuss this answer

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

A. Thermal

B. Intermodulation

C. Cross talk

D. Impulse

Discuss this answer

Only one communication channel is needed rather than n channels to transmit data between two communicating devices

A. parallel

B. serial

C. analog

D. digital

Discuss this answer

Database locking concept is used to solve the problem of

A. Lost Update

B. Uncommitted Dependency

C. Inconsistent Data

D. All of the above

Discuss this answer

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

Discuss this answer

A logical schema

A. is the entire database.

B. is a standard way of organizing information into accessible parts.

C. describes how data is actually stored on disk.

D. both A) and C)

Discuss this answer

A table that displays data redundancies yields ____________ anomalies

A. Insertion

B. Deletion

C. Update

D. All of the above

Discuss this answer

Which of the following layer uses trailer of the frame for error detection?

A. Transport layer

B. Network layer

C. Datalink layer

D. None of these

Discuss this answer

In the architecture of a database system external level is the

A. physical level.

B. logical level.

C. conceptual level

D. view level.

Discuss this answer

A functional dependency between two or more non-key attributes is called

A. Transitive dependency

B. Partial transitive dependency

C. Functional dependency

D. Partial functional dependency

Discuss this answer

Which of the following are the properties of entities?

A. Groups

B. Table

C. Attributes

D. Switchboards

Discuss this answer

View never contains derived columns.

A. True

B. False

C. Cant say

D. none

Discuss this answer

Count function in SQL returns the number of

A. values.

B. distinct values.

C. groups.

D. columns.

Discuss this answer

RAID

A. Redundant Arrays of Independent Disks

B. Redundant Arrays of Independent Drives

C. Redundant Arrays of Interconnected Drives

D. Redundant Arrays of Interconnected Disks

Discuss this answer

Functional dependencies are generalization of

A. Relation dependencies

B. Data dependencies

C. key dependencies

D. none of the above

Discuss this answer

Data Manipulation Language DML) is not to

A. Create information table in the Database

B. Insertion of new information into the Database

C. Deletion of information in the Database

D. Modification of information in the Database

Discuss this answer

In E-R diagram Generalization is represented by

A. Circle

B. Rectangle

C. Hyperbola

D. Triangle

Discuss this answer

Secondary storage

A. magnetic disk

B. magnetic tape

C. juke box

D. cache

Discuss this answer

QBE

A. Query By Execution

B. Query By Example

C. Query By Extraction

D. None of the above.

Discuss this answer

A relation is said to be in ………. If it doesnt contain partial dependency

A. 1NF

B. 2NF

C. 3NF

D. BCNF

Discuss this answer

Accepted Answer

A. Create information table in the Database

Data Manipulation Language DML) is not to

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

The class based addressing is known as

Tertiary storage

FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.

Usenet is also known as

Aggregate functions are also called

Generalization is a

The ability to modify the conceptual schema without causing any change to the application program is known as

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

UML is stands for

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

Only one communication channel is needed rather than n channels to transmit data between two communicating devices

Database locking concept is used to solve the problem of

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

A logical schema

A table that displays data redundancies yields ____________ anomalies

Which of the following layer uses trailer of the frame for error detection?

In the architecture of a database system external level is the

A functional dependency between two or more non-key attributes is called

Which of the following are the properties of entities?

View never contains derived columns.

Count function in SQL returns the number of

RAID

Functional dependencies are generalization of

Data Manipulation Language DML) is not to

In E-R diagram Generalization is represented by

Secondary storage

QBE

A relation is said to be in ………. If it doesnt contain partial dependency

Also checkout

Data Manipulation Language DML) is not to

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

The class based addressing is known as

Tertiary storage

FDDI protocol operates ini) Transport layerii) Network layeriii) Datalink layeriv) Physical layer

Extended Entity Relationship model consists of which of the followingi) Specializationii) Generalizationiii) Categorization

Select the correcti) A timestamp-based scheduler cant produce live lockii) Aggregate functions cant appear with HAVING clause.iii) Isolation is a property of database transaction.

Usenet is also known as

Aggregate functions are also called

Generalization is a

The ability to modify the conceptual schema without causing any change to the application program is known as

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

UML is stands for

............... noise is caused by the random motion of the electrons in a wire and is avoidable.

Only one communication channel is needed rather than n channels to transmit data between two communicating devices

Database locking concept is used to solve the problem of

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

A logical schema

A table that displays data redundancies yields ____________ anomalies

Which of the following layer uses trailer of the frame for error detection?

In the architecture of a database system external level is the

A functional dependency between two or more non-key attributes is called

Which of the following are the properties of entities?

View never contains derived columns.

Count function in SQL returns the number of

RAID

Functional dependencies are generalization of

Data Manipulation Language DML) is not to

In E-R diagram Generalization is represented by

Secondary storage

QBE

A relation is said to be in ………. If it doesnt contain partial dependency

Also checkout

FDDI protocol operates in
i) Transport layer
ii) Network layer
iii) Datalink layer
iv) Physical layer

Extended Entity Relationship model consists of which of the following
i) Specialization
ii) Generalization
iii) Categorization

Select the correct
i) A timestamp-based scheduler cant produce live lock
ii) Aggregate functions cant appear with HAVING clause.
iii) Isolation is a property of database transaction.

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