Correct Answer is: none of these

Correct Answer is: is the entire database.

Correct Answer is: Open Database Connectivity.

involves modelling independent of the DBMS.

needs data volume and processing frequencies to determine the size of the database.

is designing the relational model.

is a standard way of organizing information into a accessible part

describe how data is actually stored on disk

is a standard way of organizing information into accessible parts.

describes how data is actually stored on disk.

DBMS MCQ Multiple Choice Questions Answers

Q: 61. The full form of DDL is

Correct Answer is: Data Definition Language

Q: 62. In E-R Diagram derived attribute are represented by

Correct Answer is: Dashed ellipse

Q: 65. Which of the following is a comparison operator in SQL?

Correct Answer is: All of the above

Q: 70. Conceptual design

Correct Answer is: involves modelling independent of the DBMS.

Q: 71. The relational model feature is that there

Correct Answer is: is much more data independence than some other database models.

Q: 74. The property / properties of a database is / are :

Correct Answer is: All of the above.

Q: 79. SET concept is used in :

Correct Answer is: Network Model

Q: 80. Which of the following is record based logical model?

Correct Answer is: Network Model

61. The full form of DDL is

Dynamic Data Language
Detailed Data Language
Data Definition Language
Data Derivation Language

62. In E-R Diagram derived attribute are represented by

Ellipse
Dashed ellipse
Rectangle
Triangle

63. In E-R Diagram relationship type is represented by

Ellipse
Dashed ellipse
Rectangle
Diamond

64. In E-R diagram generalization is represented by

Ellipse
Dashed ellipse
Rectangle
Triangle

65. Which of the following is a comparison operator in SQL?

Equals To
LIKE
BETWEEN
All of the above

66. Which database level is closest to the users?

External
Internal
Physical
Conceptual

67. In a Hierarchical model records are organized as

Graph.
List.
Links.
Tree.

68. The method in which records are physically stored in a specified order according to a keyfield in each record is

hash.
direct.
sequential.
all of the above.

69. The database schema is written in

HLL
DML
DDL
DCL

70. Conceptual design

is a documentation technique.
needs data volume and processing frequencies to determine the size of the database.
involves modelling independent of the DBMS.
is designing the relational model.

71. The relational model feature is that there

is no need for primary key data.
is much more data independence than some other database models.
are explicit relationships among records.
are tables with many dimensions.

72. A logical schema

is the entire database
is a standard way of organizing information into a accessible part
describe how data is actually stored on disk
none of these

73. A logical schema

is the entire database.
is a standard way of organizing information into accessible parts.
describes how data is actually stored on disk.
both B and C

74. The property / properties of a database is / are :

It is an integrated collection of logically related records.
It consolidates separate files into a common pool of data records.
Data stored in a database is independent of the application programs using it.
All of the above.

75. A table joined with itself is called

Join
Self Join
Outer Join
Equi Join

76. A B-tree of order m has maximum of _____________ children

m
m+1
m-1
m/2

77. Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is:

mn
m+n
(m+n)/2
2(m+n)

78. The way a particular application views the data from the database that the applicationuses is a

module.
relational model.
schema.
sub schema.

79. SET concept is used in :

Network Model
Hierarchical Model
Relational Model
None of these

80. Which of the following is record based logical model?

Network Model
Object oriented model
E-R Model
None of these

81. In case of entity integrity, the primary key may be

not Null
Null
both Null & not Null.
any value.

82. In the relational modes, cardinality is termed as:

Number of tuples.
Number of attributes.
Number of tables.
Number of constraints.

83. ODBC stands for

Object Database Connectivity.
Oral Database Connectivity.
Oracle Database Connectivity.
Open Database Connectivity.

84. The language which has recently become the defacto standard for interfacing applicationprograms with relational database system is

Oracle.
SQL.
DBase.
4GL.

85. A primary key is combined with a foreign key creates

Parent-Child relation ship between the tables that connect them.
Many to many relationship between the tables that connect them.
Network model between the tables that connect them.
None of the above.

86. A primary key if combined with a foreign key creates

Parent-Child relationship between the tables that connect them.
Many to many relationship between the tables that connect them.
Network model between the tables that connect them.
None of the above.

87. Which are the two ways in which entities can participate in a relationship?

Passive and active
Total and partial
Simple and Complex
All of the above

88. In the architecture of a database system external level is the

physical level.
logical level.
conceptual level
view level.