Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.

Question

Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.

A. RAM

B. Flash

Correct Answer :

B. Flash

Share this question with your friends

Show all DBMS MCQ

Comment

The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______

Discuss this answer

The statement that is executed automatically by the system as a side effect of the modification of the database is

A. backup

Discuss this answer

A table can have only one

Discuss this answer

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

Discuss this answer

In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :

Discuss this answer

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

A. Table

Discuss this answer

In SQL the word natural can be used with

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.

B. Hashed

Discuss this answer

A _____ is used to define overall design of the database

A. code

D. schema

Discuss this answer

The collection of information stored in a database at a particular moment is called as ......

A. schema

Discuss this answer

A ______ module is typically designed so that it will run on a user workstation or personal computer.

B. Server

D. Client

Discuss this answer

In 2NF

Discuss this answer

In SQL, testing whether a subquery is empty is done using

B. UNIQUE

C. NULL

D. EXISTS

Discuss this answer

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

Discuss this answer

The default level of consistency in SQL is

Discuss this answer

Relations produced from an E-R model will always be

Discuss this answer

Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are

Discuss this answer

In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by

Discuss this answer

The drawback of shadow paging technique are

Discuss this answer

The normal form that is not necessarily dependency preserving is

A. 2NF

B. 3NF

C. BCNF

D. 4NF

Discuss this answer

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

B. Direct

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.

C. None

D. Weak

Discuss this answer

_____ database is used to provide statistical information or summaries of values based on various criteria.

Discuss this answer

DBMS is a collection of _____ that enables user to create and maintain a database.

A. Keys

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

Discuss this answer

A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.

A. Sub

B. Parent

D. Super

Discuss this answer

Which of the following constitutes a basic set of operations for manipulating relational data?

D. SQL

Discuss this answer

Grant and revoke are _____ statements.

A. TCL

B. DCL

C. DDL

D. DML

Discuss this answer

The set of all values that can be taken by the attribute is called as _______ of the attribute.

A. Tuple

C. Degree

D. Domain

Discuss this answer

The transactions like adding an employee, enrolling a student in a course are examples of _______

C. None

Discuss this answer

Answer 1

C. Hard Disk

Answer 2

D. Secondary

Answer 3

A. Volatile

Answer 4

B. Non - Volatile

Answer 5

C. Logical

Answer 6

D. Physical

Answer 7

B. assertion

Answer 8

C. recovery

Answer 9

D. trigger

Answer 10

A. Secondary key

Answer 11

B. Alternate key

Answer 12

C. Unique key

Answer 13

D. Primary key

Answer 14

A. left outer join

Answer 15

B. right outer join

Answer 16

C. full outer join

Answer 17

D. inner join

Answer 18

A. Operationally, if Y is deleted, so is X

Answer 19

B. existence is dependent on Y.

Answer 20

C. Operationally, if X is deleted, so is Y.

Answer 21

D. Operationally, if X is deleted, & remains the same.

Answer 22

B. Tree like structure

Answer 23

C. Complex logical relationship

Answer 24

D. Records

Answer 25

A. inner join

Answer 26

B. full outer join

Answer 27

C. right outer join

Answer 28

D. all of the above

Answer 29

A. Clustered

Answer 30

C. Un-clustered

Answer 31

D. Collision

Answer 32

B. data definition language

Answer 33

C. application program

Answer 34

B. instance of the database

Answer 35

C. data domain

Answer 36

D. independence

Answer 37

A. Software

Answer 38

C. Program

Answer 39

A. No functional dependencies (FDs) exist.

Answer 40

B. No multivalued dependencies (MVDs) exist.

Answer 41

C. No partial FDs exist.

Answer 42

D. No partial MVDs exist.

Answer 43

A. DISTINCT

Answer 44

A. Primary Key

Answer 45

B. Local Key

Answer 46

C. Foreign Key

Answer 47

D. Composite Key

Answer 48

A. repeatable read

Answer 49

B. read committed

Answer 50

C. read uncommitted

Answer 51

D. serializable

Answer 52

A. First normal form.

Answer 53

B. Second normal form.

Answer 54

C. Third normal form.

Answer 55

D. Fourth normal form.

Answer 56

A. m+n and 0

Answer 57

B. m+n and |m-n|

Answer 58

C. mn and 0

Answer 59

D. mn and m+n

Answer 60

A. jamming

Answer 61

B. password

Answer 62

C. documentation

Answer 63

D. record lock

Answer 64

A. Commit overhead

Answer 65

B. Data fragmentation

Answer 66

C. Garbage collection

Answer 67

D. All of these

Answer 68

A. Sequential

Answer 69

C. Index sequential

Answer 70

D. None of the above

Answer 71

A. Regular

Answer 72

B. Irregular

Answer 73

A. Statistical

Answer 74

B. Mathematical

Answer 75

C. Normalized

Answer 76

D. Un normalized

Answer 77

B. Program

Answer 78

C. Translators

Answer 79

D. Language Activity

Answer 80

B. ii-only

Answer 81

C. Both of them

Answer 82

D. None of them

Answer 83

C. Candidate

Answer 84

A. Predicate calculus

Answer 85

B. Relational calculus

Answer 86

C. Relational algebra

Answer 87

B. Cardinality

Answer 88

A. Logical

Answer 89

B. Physical

Answer 90

D. Theoretical

Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.

Correct Answer :

Show all DBMS MCQ

Related Questions

The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______

The statement that is executed automatically by the system as a side effect of the modification of the database is

A table can have only one

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

In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :

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

In SQL the word natural can be used with

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 _____ is used to define overall design of the database

The collection of information stored in a database at a particular moment is called as ......

A ______ module is typically designed so that it will run on a user workstation or personal computer.

In 2NF

In SQL, testing whether a subquery is empty is done using

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

The default level of consistency in SQL is

Relations produced from an E-R model will always be

Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are

In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by

The drawback of shadow paging technique are

The normal form that is not necessarily dependency preserving is

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

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.

_____ database is used to provide statistical information or summaries of values based on various criteria.

DBMS is a collection of _____ that enables user to create and maintain a database.

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

A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.

Which of the following constitutes a basic set of operations for manipulating relational data?

Grant and revoke are _____ statements.

The set of all values that can be taken by the attribute is called as _______ of the attribute.

The transactions like adding an employee, enrolling a student in a course are examples of _______

Also checkout

Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile.

Correct Answer :

Show all DBMS MCQ

Related Questions

The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______

The statement that is executed automatically by the system as a side effect of the modification of the database is

A table can have only one

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

In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect :

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

In SQL the word natural can be used with

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 _____ is used to define overall design of the database

The collection of information stored in a database at a particular moment is called as ......

A ______ module is typically designed so that it will run on a user workstation or personal computer.

In 2NF

In SQL, testing whether a subquery is empty is done using

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

The default level of consistency in SQL is

Relations produced from an E-R model will always be

Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are

In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by

The drawback of shadow paging technique are

The normal form that is not necessarily dependency preserving is

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

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.

_____ database is used to provide statistical information or summaries of values based on various criteria.

DBMS is a collection of _____ that enables user to create and maintain a database.

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

A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key.

Which of the following constitutes a basic set of operations for manipulating relational data?

Grant and revoke are _____ statements.

The set of all values that can be taken by the attribute is called as _______ of the attribute.

The transactions like adding an employee, enrolling a student in a course are examples of _______

Also checkout

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