In an Entity-Relationship Diagram Ellipses represents

Question

In an Entity-Relationship Diagram Ellipses represents

A. Attributes

B. Weak entity set

C. Relationship sets

D. Multi-valued attributes

Share this question with your friends

Show all Advance DBMS MCQ

Comment

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 is not a constraint on a single relation?

A. check

B. unique

C. not null

D. is duplicate

Discuss this answer

Select the incorrect statement

A. BCNF is stronger than 3NF

B. Relational algebra is a non-procedural language

C. Every conflict serializable schedule is view serializable.

D. none of the above

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

Noiseless channel has ……… types of protocols.

A. 2

B. 3

C. 4

D. 5

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

A transaction which completes successfully is called

A. Granted

B. Committed

C. Compensated

D. Accomplished

Discuss this answer

The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is

A. Normalization

B. Indexing

C. Enforcing referential integrity

D. Enforcing data integrity

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

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

Discuss this answer

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)

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

Data integrity refers to

A. the uniqueness of the data in a database

B. the correctness and completeness of the data in a database

C. the un redundancies of the data in a database

D. Data independence of the database

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

Range variables are designed using the

A. TO clause

B. FROM clause

C. RANGE clause

D. none of the above

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

Which topology requires a central controller or hub?

A. Ring

B. Tree

C. Switch

D. Graph

Discuss this answer

In E-R Diagram weak entity set are represented by

A. Ellipse

B. Dashed ellipse

C. Dashed Rectangle

D. Doubled Rectangle

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

Unwanted energy from source other than the transmitter.

A. Attenuation

B. Distortion

C. Delay

D. Noise

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

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

The control of concurrent execution is left with the

A. operating system

B. controller unit of the kernel

C. concurrency control component of the database system

D. none

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

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

Select the incorrect statement

A. View is derived from other tables.

B. Once a transaction has executed commit work its effect cant be undone by rollback work .

C. The input to the aggregate function avg can be non numeric data types

D. A primary key can never be null.

Discuss this answer

Which of the following is also known as Offline storage ?

A. primary storage

B. secondary storage

C. tertiary storage

D. none of the above

Discuss this answer

The statement in SQL which allows to change the definition of a table is

A. Select

B. Update

C. Create

D. Alter

Discuss this answer

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

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

Accepted Answer

A. Attributes

In an Entity-Relationship Diagram Ellipses represents

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Transaction processing is associated with everything below except

Which of the following is not a constraint on a single relation?

Select the incorrect statement

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

Noiseless channel has ……… types of protocols.

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 transaction which completes successfully is called

The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is

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

Technique(s) used for data recovery after any failure

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 logical schema

Data integrity refers to

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

Range variables are designed using the

Benefit of database normalization is

Which topology requires a central controller or hub?

In E-R Diagram weak entity set are represented by

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

Unwanted energy from source other than the transmitter.

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.

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.

The control of concurrent execution is left with the

Full form of CIDR

Database locking concept is used to solve the problem of

Select the incorrect statement

Which of the following is also known as Offline storage ?

The statement in SQL which allows to change the definition of a table is

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

In which of the following SET concept is used ?

Also checkout

In an Entity-Relationship Diagram Ellipses represents

Correct Answer :

Show all Advance DBMS MCQ

Related Questions

Transaction processing is associated with everything below except

Which of the following is not a constraint on a single relation?

Select the incorrect statement

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

Noiseless channel has ……… types of protocols.

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

A transaction which completes successfully is called

The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is

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

Technique(s) used for data recovery after any failure

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 logical schema

Data integrity refers to

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

Range variables are designed using the

Benefit of database normalization is

Which topology requires a central controller or hub?

In E-R Diagram weak entity set are represented by

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

Unwanted energy from source other than the transmitter.

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.

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.

The control of concurrent execution is left with the

Full form of CIDR

Database locking concept is used to solve the problem of

Select the incorrect statement

Which of the following is also known as Offline storage ?

The statement in SQL which allows to change the definition of a table is

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

In which of the following SET concept is used ?

Also checkout

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

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.