Explore topic-wise MCQs in Engineering.

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.