Event condition action model is related to

Question

Event condition action model is related to

A. Views

B. Cursors

C. Triggers

D. None of these.

Share this question with your friends

Show all Advance DBMS MCQ

Comment

Which of the following extracts its data from the result of an SQL SELECT statement.

A. View

B. Synonym

C. Sequence

D. Transaction

Discuss this answer

When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?

A. first

B. second

C. third

D. fourth

Discuss this answer

View never contains derived columns.

A. True

B. False

C. Cant say

D. none

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

Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer

A. i and ii only

B. ii and iii only

C. ii only

D. i only

Discuss this answer

An operation that will increase the length of a list is

A. insert

B. modify

C. lookup

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

A composite attribute is converted to individual attributes in which of the following normal form ?

A. first

B. Second

C. third

D. fourth

Discuss this answer

Three SQL, DDL, CREATE commands are

A. Schema, Base and Table

B. Schema, Table and View

C. Base, Table and Schema

D. Key, Base and Table

Discuss this answer

The raw facts and figures are:

A. Data

B. Data field

C. DBMS

D. DBASE

Discuss this answer

Event condition action model is related to

A. Views

B. Cursors

C. Triggers

D. None of these.

Discuss this answer

Which of the following is true statement ?

A. SQL permits attribute names to be repeated in the same relation.

B. a SQL query automatically eliminates duplicates.

C. a SQL query will not work if there are no indexes on the relations

D. None of these

Discuss this answer

Full form of CIDR

A. Classful Inter Domain Routing

B. Classless International Domain Routing

C. Classless Inter Domain Routing

D. none of these

Discuss this answer

Mail services are available to network users through the

A. Session layer

B. Presentation layer

C. Application layer

D. Transport layer

Discuss this answer

Volatile storage

A. loses its contents when power is switched off.

B. doesnt loses its contents when power is switched off.

C. creates backup when power is switched off.

D. none

Discuss this answer

An association of several structure of a data base can be expressed graphically by?

A. Tuple

B. Record

C. Relationship

D. Field

Discuss this answer

The access protocol used by traditional Ethernet

A. CSMA/CA

B. CSMA/CD

C. CSMA

D. Token ring

Discuss this answer

What is the max data capacity of STP?

A. 1 Gbps

B. 56 Mbps

C. 100 Mbps

D. 256 Mbps

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

The transaction consists of all statements executed between

A. the begin transaction and end transaction

B. the start transaction and end transaction

C. the begin transaction and finish transaction

D. none of the above.

Discuss this answer

Which of the following statements is not true about two tier client server database architecture?

A. SQL statements are processed on tier server

B. SQL statements may be processed on some of the clients

C. Business logic is mostly processed on clients

D. Business logic may be processed on the server

Discuss this answer

Which of the following is not an Aggregate function?

A. Min

B. Max

C. Select

D. Avg

Discuss this answer

Radio frequencies below ............. are more suitable for omnidirectional applications.

A. 300MHz

B. 1GHz

C. 5GHz

D. 10 GHz

Discuss this answer

The union of primary keys of a related entity becomes …………. Of a relation.

A. primarykey

B. superkey

C. candidatekey

D. foreignkey

Discuss this answer

Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.

A. Gray

B. White

C. Blue

D. Black

Discuss this answer

Benefit of database normalization is

A. smaller number of tables

B. higher query processing efficiency

C. reduced I/O for most queries

D. reduced data redundancy

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

Primary storage

A. magnetic disk

B. magnetic tape

C. juke box

D. cache

Discuss this answer

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

A. Noise

B. Delay distortion

C. Attenuation distortion

D. Dispersion

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

Accepted Answer

C. Triggers

Event condition action model is related to

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Which of the following extracts its data from the result of an SQL SELECT statement.

When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?

View never contains derived columns.

A logical schema

Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer

An operation that will increase the length of a list is

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

A composite attribute is converted to individual attributes in which of the following normal form ?

Three SQL, DDL, CREATE commands are

The raw facts and figures are:

Event condition action model is related to

Which of the following is true statement ?

Full form of CIDR

Mail services are available to network users through the

Volatile storage

An association of several structure of a data base can be expressed graphically by?

The access protocol used by traditional Ethernet

What is the max data capacity of STP?

Database locking concept is used to solve the problem of

The transaction consists of all statements executed between

Which of the following statements is not true about two tier client server database architecture?

Which of the following is not an Aggregate function?

Radio frequencies below ............. are more suitable for omnidirectional applications.

The union of primary keys of a related entity becomes …………. Of a relation.

Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.

Benefit of database normalization is

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

Primary storage

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

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

Also checkout

Event condition action model is related to

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Which of the following extracts its data from the result of an SQL SELECT statement.

When all attributes in a relation tuple are not functionally dependent only on the key attribute. Which of the following normalization is needed?

View never contains derived columns.

A logical schema

Repeaters operate ini) Physical layerii) Datalink layeriii) Transport layeriv) Network layer

An operation that will increase the length of a list is

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

A composite attribute is converted to individual attributes in which of the following normal form ?

Three SQL, DDL, CREATE commands are

The raw facts and figures are:

Event condition action model is related to

Which of the following is true statement ?

Full form of CIDR

Mail services are available to network users through the

Volatile storage

An association of several structure of a data base can be expressed graphically by?

The access protocol used by traditional Ethernet

What is the max data capacity of STP?

Database locking concept is used to solve the problem of

The transaction consists of all statements executed between

Which of the following statements is not true about two tier client server database architecture?

Which of the following is not an Aggregate function?

Radio frequencies below ............. are more suitable for omnidirectional applications.

The union of primary keys of a related entity becomes …………. Of a relation.

Thermal noise is often referred to as ............... noise, because it affects uniformly the different frequencies.

Benefit of database normalization is

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

Primary storage

.................. occurs due to velocity of propagation the frequency varies. Thus various frequency components of a signal arrive at the receiver at different times.

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

Also checkout

Repeaters operate in
i) Physical layer
ii) Datalink layer
iii) Transport layer
iv) Network layer

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

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