1033 + Mcqs in Database McqOptions

1.	The physical database design identifies data integrity and security requirements.
A.	True
B.	False
Answer» C.

Discussion

2.	The longest step of database development is database maintenance.
A.	True
B.	False
Answer» B. False

Discussion

3.	Incremental commitment does not allow a project to be easily redirected or to be terminated.
A.	True
B.	False
Answer» C.

Discussion

4.	There are three stages involved when analyzing the initiation of an information systems project.
A.	True
B.	False
Answer» C.

Discussion

5.	The ODMG Object Model supports only unary and binary relationships.
A.	True
B.	False
Answer» B. False

Discussion

6.	MySQL is just as powerful as Oracle and is half the price.
A.	True
B.	False
Answer» C.

Discussion

7.	Java programs are compiled into bytecode.
A.	True
B.	False
Answer» B. False

Discussion

8.	JDBC Type 2 drivers connect to the native API of the DBMS.
A.	True
B.	False
Answer» B. False

Discussion

9.	MySQL surrogate keys are given the property AUTO_INCREMENT.
A.	True
B.	False
Answer» B. False

Discussion

10.	A servlet is a Java program that is invoked via HTTP on the Web server.
A.	True
B.	False
Answer» B. False

Discussion

11.	There is one physical schema for each logical schema.
A.	True
B.	False
Answer» B. False

Discussion

12.	The most important reason for data architecture is reliability.
A.	True
B.	False
Answer» C.

Discussion

13.	The systems development life cycle cannot be used with database implementation.
A.	True
B.	False
Answer» C.

Discussion

14.	Enterprise data modeling typically occurs during information systems planning.
A.	True
B.	False
Answer» B. False

Discussion

15.	A derived attribute is an attribute whose values can be calculated from a related relationship.
A.	True
B.	False
Answer» C.

Discussion

16.	A strong entity is an entity whose existence depends on some other entity type.
A.	True
B.	False
Answer» C.

Discussion

17.	Multiple and binary relationships are the same thing.
A.	True
B.	False
Answer» C.

Discussion

18.	No two attributes of the same entity type should have the same name.
A.	True
B.	False
Answer» B. False

Discussion

19.	A relationship is an association representing the interaction between attributes.
A.	True
B.	False
Answer» C.

Discussion

20.	A binary relationship is a relationship between two or more entities.
A.	True
B.	False
Answer» C.

Discussion

21.	Some business rules cannot be represented in common data modeling notation.
A.	True
B.	False
Answer» B. False

Discussion

22.	A time stamp is a time value that is associated with a data value.
A.	True
B.	False
Answer» B. False

Discussion

23.	A logical representation of the data for an organization or for a business area is known as an entity-relationship model.
A.	True
B.	False
Answer» B. False

Discussion

24.	A null value is assigned when no other value applies.
A.	True
B.	False
Answer» B. False

Discussion

25.	A synonym is two or more attributes that have different names but the same meaning.
A.	True
B.	False
Answer» B. False

Discussion

26.	The primary key in a relation does not need to be underlined.
A.	True
B.	False
Answer» C.

Discussion

27.	In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
A.	True
B.	False
Answer» B. False

Discussion

28.	Normalization is a formal process for deciding which attributes should be grouped together in a relation.
A.	True
B.	False
Answer» B. False

Discussion

29.	During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.
A.	True
B.	False
Answer» B. False

Discussion

30.	An attribute is a person, place, object, event in a user environment.
A.	True
B.	False
Answer» C.

Discussion

31.	Output reports should be included as part of an ERD.
A.	True
B.	False
Answer» C.

Discussion

32.	Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity.
A.	True
B.	False
Answer» B. False

Discussion

33.	Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.
A.	True
B.	False
Answer» C.

Discussion

34.	JSP and ASP not only look alike but their underlying technology is quite similar.
A.	True
B.	False
Answer» C.

Discussion

35.	JDBC Type 1 drivers are JDBC-ODBC bridge drivers.
A.	True
B.	False
Answer» B. False

Discussion

36.	Well-structured relations encourage anomalies of data.
A.	True
B.	False
Answer» C.

Discussion

37.	A foreign key may be null and still adhere to the referential integrity constraint.
A.	True
B.	False
Answer» B. False

Discussion

38.	Even though Java is machine-independent, JSPs are not.
A.	True
B.	False
Answer» C.

Discussion

39.	Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.
A.	True
B.	False
Answer» B. False

Discussion

40.	Java bytecode is machine-specific code.
A.	True
B.	False
Answer» C.

Discussion

41.	If a relation is in third normal form, it does not need to be in second normal form.
A.	True
B.	False
Answer» C.

Discussion

42.	The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
A.	True
B.	False
Answer» B. False

Discussion

43.	Apache Web server does not support servlets.
A.	True
B.	False
Answer» B. False

Discussion

44.	An applet is a Java bytecode program that is sent to the user via HTTP and is invoked using the HTTP protocol on the user's computer.
A.	True
B.	False
Answer» B. False

Discussion

45.	With JSP, the coding is done in Java and only in Java.
A.	True
B.	False
Answer» B. False

Discussion

46.	MySQL is pronounced "my See-quel."
A.	True
B.	False
Answer» C.

Discussion

47.	MySQL maintains metadata in the database meta_sql.
A.	True
B.	False
Answer» C.

Discussion

48.	JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.
A.	True
B.	False
Answer» B. False

Discussion

49.	JDBC stands for Java Database Connectivity
A.	True
B.	False
Answer» B. False

Discussion

50.	Sun defines four JDBC driver types.
A.	True
B.	False
Answer» B. False

Discussion

Explore topic-wise MCQs in Testing Subject.

The physical database design identifies data integrity and security requirements.

The longest step of database development is database maintenance.

Incremental commitment does not allow a project to be easily redirected or to be terminated.

There are three stages involved when analyzing the initiation of an information systems project.

The ODMG Object Model supports only unary and binary relationships.

MySQL is just as powerful as Oracle and is half the price.

Java programs are compiled into bytecode.

JDBC Type 2 drivers connect to the native API of the DBMS.

MySQL surrogate keys are given the property AUTO_INCREMENT.

A servlet is a Java program that is invoked via HTTP on the Web server.

There is one physical schema for each logical schema.

The most important reason for data architecture is reliability.

The systems development life cycle cannot be used with database implementation.

Enterprise data modeling typically occurs during information systems planning.

A derived attribute is an attribute whose values can be calculated from a related relationship.

A strong entity is an entity whose existence depends on some other entity type.

Multiple and binary relationships are the same thing.

No two attributes of the same entity type should have the same name.

A relationship is an association representing the interaction between attributes.

A binary relationship is a relationship between two or more entities.

Some business rules cannot be represented in common data modeling notation.

A time stamp is a time value that is associated with a data value.

A logical representation of the data for an organization or for a business area is known as an entity-relationship model.

A null value is assigned when no other value applies.

A synonym is two or more attributes that have different names but the same meaning.

The primary key in a relation does not need to be underlined.

In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.

Normalization is a formal process for deciding which attributes should be grouped together in a relation.

During logical database design, the conceptual data model is transformed into a logical data model which describes the data in terms of a specific data management technology.

An attribute is a person, place, object, event in a user environment.

Output reports should be included as part of an ERD.

Cardinality specifies the number of instances of one entity that can be associated with each instance of another entity.

Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.

JSP and ASP not only look alike but their underlying technology is quite similar.

JDBC Type 1 drivers are JDBC-ODBC bridge drivers.

Well-structured relations encourage anomalies of data.

A foreign key may be null and still adhere to the referential integrity constraint.

Even though Java is machine-independent, JSPs are not.

Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.

Java bytecode is machine-specific code.

If a relation is in third normal form, it does not need to be in second normal form.

The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.

Apache Web server does not support servlets.

An applet is a Java bytecode program that is sent to the user via HTTP and is invoked using the HTTP protocol on the user's computer.

With JSP, the coding is done in Java and only in Java.

MySQL is pronounced "my See-quel."

MySQL maintains metadata in the database meta_sql.

JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.

JDBC stands for Java Database Connectivity

Sun defines four JDBC driver types.