DECLARE is a(an)

Question

DECLARE is a(an)

A. executable statement.

B. declarative statement.

C. Ordered file

D. none of the above

Share this question with your friends

Show all Advance DBMS MCQ

Comment

The overall design of a database is called

A. Subschema of the database

B. Schema of the database

C. Structure of the database

D. View of the database

Discuss this answer

An entity set which have sufficient attributes to form a primary key

A. Tree structure

B. Subtree structure

C. Strong entity set

D. Table structure

Discuss this answer

A relation that has no partial dependencies is in which normal form

A. First

B. Second

C. Third

D. BCNF

Discuss this answer

The attribute that can be divided into other attributes is called

A. Simple Attribute

B. Composite Attribute

C. Multi-valued Attribute

D. Derived Attribute

Discuss this answer

Transaction processing is associated with everything below except

A. producing detail, summary, or exception reports.

B. recording a business activity.

C. confirming an action or triggering a response.

D. maintaining data.

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

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

Aggregate functions are also called

A. serial functions

B. non-serial functions

C. row functions

D. column functions

Discuss this answer

The access protocol used by traditional Ethernet

A. CSMA/CA

B. CSMA/CD

C. CSMA

D. Token ring

Discuss this answer

Which one of the following is provided by a data dictionary ?

A. User data

B. Database structure data

C. Sorted data

D. Functional data

Discuss this answer

In RDBMS, Data is presented as a collection of

A. Relation

B. Table

C. Attribute

D. Entity

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

Triggers are also called

A. active rules

B. passive rules

C. inferences

D. none of the above

Discuss this answer

In ………… paging we make copy of the current page table.

A. physical

B. logical

C. shadow

D. duplicate

Discuss this answer

In which of the following SET concept is used ?

A. Network Model

B. Hierarchical Model

C. Relational Model

D. None of these

Discuss this answer

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

The syntax to select all column from the table is

A. select all from tablename

B. select * from tablename

C. select from tablename

D. none of these

Discuss this answer

A fragmentation is categorized in

A. 1 part

B. 2 part

C. 3 part

D. 4 part

Discuss this answer

Datalog is

A. procedural query language

B. nonprocedural query language

C. scan(), write()

D. none of the above

Discuss this answer

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

Discuss this answer

In this data model each record can hae more than one parent

A. Hierarchical model

B. E-R model

C. Network based model

D. none of these

Discuss this answer

Which command is used to cancel privileges granted through the GRANT command ?

A. CANCEL

B. OVER

C. STOP

D. REVOKE

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

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

Which one of the following statements is false?

A. The data dictionary is normally maintained by the database administrator.

B. Data elements in the database can be modified by changing the data dictionary.

C. The data dictionary contains the name and description of each data element.

D. The data dictionary is a tool used exclusively by the database administrator.

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

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

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

Discuss this answer

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

Discuss this answer

Accepted Answer

B. declarative statement.

DECLARE is a(an)

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

The overall design of a database is called

An entity set which have sufficient attributes to form a primary key

A relation that has no partial dependencies is in which normal form

The attribute that can be divided into other attributes is called

Transaction processing is associated with everything below except

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

Which of the following is not an Aggregate function?

Which of the following is true statement ?

Aggregate functions are also called

The access protocol used by traditional Ethernet

Which one of the following is provided by a data dictionary ?

In RDBMS, Data is presented as a collection of

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

Triggers are also called

In ………… paging we make copy of the current page table.

In which of the following SET concept is used ?

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

The syntax to select all column from the table is

A fragmentation is categorized in

Datalog is

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

In this data model each record can hae more than one parent

Which command is used to cancel privileges granted through the GRANT command ?

Full form of CIDR

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

Which one of the following statements is false?

UML is stands for

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

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.

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.

Also checkout

DECLARE is a(an)

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

The overall design of a database is called

An entity set which have sufficient attributes to form a primary key

A relation that has no partial dependencies is in which normal form

The attribute that can be divided into other attributes is called

Transaction processing is associated with everything below except

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

Which of the following is not an Aggregate function?

Which of the following is true statement ?

Aggregate functions are also called

The access protocol used by traditional Ethernet

Which one of the following is provided by a data dictionary ?

In RDBMS, Data is presented as a collection of

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

Triggers are also called

In ………… paging we make copy of the current page table.

In which of the following SET concept is used ?

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

The syntax to select all column from the table is

A fragmentation is categorized in

Datalog is

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

In this data model each record can hae more than one parent

Which command is used to cancel privileges granted through the GRANT command ?

Full form of CIDR

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

Which one of the following statements is false?

UML is stands for

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

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.

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.

Also checkout

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.