Wait-for graph is used for

Question

Wait-for graph is used for

A. detecting view serializability.

B. detecting conflict serializability.

C. deadlock prevention

D. deadlock detection

Share this question with your friends

Show all DBMS MCQ

Comment

A relational database developer refers to a record as

A. an attribute

B. a tuple

C. a criteria

D. a relation

Discuss this answer

For correct behaviour during recovery, undo and redo operation must be

A. Commutative

B. Associative

C. idempotent

D. distributive

Discuss this answer

The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.

A. Clustered

B. Hashed

C. Un-clustered

D. Collision

Discuss this answer

Processed data is called _____

A. Raw data

B. Source

C. Information

D. Useful data

Discuss this answer

The normal form that is not necessarily dependency preserving is

A. 2NF

B. 3NF

C. BCNF

D. 4NF

Discuss this answer

As per equivalence rules for query transformation, selection operation distributes over

A. Union.

B. Set difference.

C. Intersection.

D. All of the above.

Discuss this answer

SQL server stores index information in the _____system table

A. system indexes

B. syst indexes

C. sys indexes

D. sysind

Discuss this answer

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

A. left outer join

B. right outer join

C. full outer join

D. inner join

Discuss this answer

Relational Algebra does not have

A. Selection operator.

B. Projection operator.

C. Aggregation operators.

D. Division operator.

Discuss this answer

Drop Table cannot be used to drop a table referenced by a ______ constraint.

A. Primary Key

B. Local Key

C. Foreign Key

D. Composite Key

Discuss this answer

The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.

A. Data Manipulation

B. Data Definition

C. Data Control

D. None

Discuss this answer

The cost of reading and writing temporary files while evaluating a query can be reduced by

A. building indices

B. pipelining

C. join ordering

D. none of the above

Discuss this answer

A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be

A. the pin code

B. the last name

C. the compound key first name and last name

D. Tr from next page

Discuss this answer

Grant and revoke are _____ statements.

A. TCL

B. DCL

C. DDL

D. DML

Discuss this answer

Maximum height of a B+ tree of order m with n key values is

A. Logm(n)

B. (m+n)/2

C. Logm/2(m+n)

D. None of these

Discuss this answer

E-R Modeling is achieved by using ____ diagrams

A. DFD

B. Flowcharts

C. Gantt Charts

D. E-R

Discuss this answer

The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.

A. OR

B. AND

C. NOT

D. ALL

Discuss this answer

Data items grouped together for storage purposes are called a

A. record

B. string

C. title

D. list

Discuss this answer

Which is the best file organization when data is frequently added or deleted from a file?

A. Sequential

B. Direct

C. Index sequential

D. None of the above

Discuss this answer

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

A. View

B. Order by

C. Group by

D. Having

Discuss this answer

The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.

A. Regular

B. Irregular

C. None

D. Weak

Discuss this answer

Change Staff table by removing default of Assistant for position column

A. ALTER TABLE Staff ALTER position DROP DEFAULT;

B. ALTER TABLE Staff ALTER position DEFAULT;

C. ALTER TABLE Staff ALTER DROP DEFAULT;

D. MODIFY Staff ALTER position DROP DEFAULT;

Discuss this answer

HSAM stands for ……….

A. Hierarchic Standard Access Method

B. Hierarchic Sequential Access Method

C. Hierarchic Sequential and Method

D. Hierarchic Standard and Method

Discuss this answer

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

A. i-only

B. ii-only

C. Both of them

D. None of them

Discuss this answer

Which of the following is not a logical database structure?

A. Chain

B. Network

C. Tree

D. Relational

Discuss this answer

The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

A. Procedural DML.

B. Non-Procedural DML.

C. Procedural DDL.

D. Non-Procedural DDL.

Discuss this answer

_____clause is an additional filter that is applied to the result.

A. Select

B. Order by

C. Group-by

D. Having

Discuss this answer

In an ER model,_____ is described in the database by storing its data.

A. Entity

B. Attribute

C. Relationship

D. Notation

Discuss this answer

Which of the following is not a consequence of non-normalized database?

A. Update Anomaly

B. Insertion Anomaly

C. Redundancy

D. Lost update problem

Discuss this answer

Which of the following is not a characteristic of a relational database model?

A. Table

B. Tree like structure

C. Complex logical relationship

D. Records

Discuss this answer

Accepted Answer

D. deadlock detection

Wait-for graph is used for

Correct Answer :

Show all DBMS MCQ

Related Questions

A relational database developer refers to a record as

For correct behaviour during recovery, undo and redo operation must be

The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.

Processed data is called _____

The normal form that is not necessarily dependency preserving is

As per equivalence rules for query transformation, selection operation distributes over

SQL server stores index information in the _____system table

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

Relational Algebra does not have

Drop Table cannot be used to drop a table referenced by a ______ constraint.

The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.

The cost of reading and writing temporary files while evaluating a query can be reduced by

A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be

Grant and revoke are _____ statements.

Maximum height of a B+ tree of order m with n key values is

E-R Modeling is achieved by using ____ diagrams

The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.

Data items grouped together for storage purposes are called a

Which is the best file organization when data is frequently added or deleted from a file?

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.

Change Staff table by removing default of Assistant for position column

HSAM stands for ……….

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values

Which of the following is not a logical database structure?

The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

_____clause is an additional filter that is applied to the result.

In an ER model,_____ is described in the database by storing its data.

Which of the following is not a consequence of non-normalized database?

Which of the following is not a characteristic of a relational database model?

Also checkout

Wait-for graph is used for

Correct Answer :

Show all DBMS MCQ

Related Questions

A relational database developer refers to a record as

For correct behaviour during recovery, undo and redo operation must be

The ______ indexes are forced to store only record IDs in the data structure and require at least one additional I/O Operation to retrieve the actual record.

Processed data is called _____

The normal form that is not necessarily dependency preserving is

As per equivalence rules for query transformation, selection operation distributes over

SQL server stores index information in the _____system table

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in

Relational Algebra does not have

Drop Table cannot be used to drop a table referenced by a ______ constraint.

The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist.

The cost of reading and writing temporary files while evaluating a query can be reduced by

A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be

Grant and revoke are _____ statements.

Maximum height of a B+ tree of order m with n key values is

E-R Modeling is achieved by using ____ diagrams

The ____ operator joins two or more conditions and displays rows only if that rows data satisfies all conditions specified.

Data items grouped together for storage purposes are called a

Which is the best file organization when data is frequently added or deleted from a file?

The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is

The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E.

Change Staff table by removing default of Assistant for position column

HSAM stands for ……….

Which of the syntax is correct for insert statement? i) insert into values ii) insert into (column list) values

Which of the following is not a logical database structure?

The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is

_____clause is an additional filter that is applied to the result.

In an ER model,_____ is described in the database by storing its data.

Which of the following is not a consequence of non-normalized database?

Which of the following is not a characteristic of a relational database model?

Also checkout

Which of the syntax is correct for insert statement?
i) insert into values
ii) insert into (column list) values