Database Programming Techniques

This MCQ-formatted quiz covers many fundamentals of web programming, JSP and servlets, application performance and security, application encryption and architecture.

Start Quiz

Which argument is used for processing the URL http://www.google.com/search?q=silberschatz?

google

google.com

q=silberschatz

HTTP defines two ways in which user-defined values at the browser can be sent to the Web server. The __ method encodes those values as part of the URL.

Post

Get

Read

Argument

A __ is a program running on the server machine, which accepts requests from a Web browser and sends back results in HTML documents.

HTML

HTTP

Web Server

Web browser

The application program typically communicates with a database server, through __ or other protocols, to get or store data.

JDBC

ODBC

All of the above

None of the above

The Java __ specification defines an application programming interface for communication between the Web server and the application program.

Servlet

Server

Program

Randomize

The doGet() method in the example extracts values of the parameter’s type and number by using

request.getParameter()

request.setParameter()

responce.getParameter()

responce.getAttribute()

How many JDBC driver types does Sun Microsystems define?

One

Two

Three

Four

Which JDBC driver Type(s) can be used in either applet or servlet code?

Both Type 1 and Type 2

Both Type 1 and Type 3

Both Type 3 and Type 4

Type 4 only

What MySQL property is used to create a surrogate key in MySQL?

UNIQUE

SEQUENCE

AUTO_INCREMENT

None of the mentioned

Entities can be associated with one another in which of the following?

Entities

Attributes

Identifiers

Relationships

Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?

Super-type entity

Sub-type entity

Archetype entity

Instance entity

In a one-to-many relationship, the entity that is on the many side of the relationship is called a(n) ________ entity.

Parent

Child

Instance

Sub-type

An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is that of another entity.

True

False

All instances of an entity class have the exact attributes. True or false?

True

False

Which of the following is a valid uniform resource locator?

http://www.acm.org/sigmod

www.google.com

www.ann.in

http:/www.acm.org/sigmod/

Quiz/Test Summary

Title: Database Programming Techniques