ICCP-Prep 15 Questions || with 100% Errorless Solutions.
A client query requires a small subset of records from a five million row table stored on a remote
database server. Obtaining this ad hoc subset requires extensive processing. The BEST solution
in terms of speed and performance would be to implement the processing
A. at the client tier
Student Response
B. at the DBMS tier with a stored procedure
C. using a scrolling facility in the client interface
D. in middleware correct answers B. at the DBMS tier with a stored procedure
PSI uses a customer information data entry screen for its corporate clients that includes three
mandatory fields: customer name, postal code, and phone number. If the clerk leaves all three of
these fields blank, which is the BEST way to be sure the input error does NOT cause the
program to crash?
A. Data validation
B. Exception handling
C. Debugging procedures
D. Data verification correct answers A. Data validation
Due to a recent merger, developers must be able to create a single application that can access
multiple databases (i.e., Oracle, SYBASE, and INFORMIX). The Web server data environment
that BEST allows access to SQL-based databases is
A. OLE DB
B. ODBC
C. HTML
D. XML correct answers B. ODBC
As a service, Bruce donated his time to a local charity to develop a web site. After the
development, he intends to train a person at the charity to maintain the site. Which would be
BEST for developing the site?
A. A high end web development package with database connectivity
B. A reasonably priced graphical page editor
C. Native HTML coding using a text editor
D. A package that Bruce has available to him through his employer correct answers C. Native
HTML coding using a text editor
Each point in a data flow diagram where a data flow intersects a process should be represented in
the physical design of a data base by a(n) _________ .
A. relation
B. user view
A client query requires a small subset of records from a five million row table stored on a remote
database server. Obtaining this ad hoc subset requires extensive processing. The BEST solution
in terms of speed and performance would be to implement the processing
A. at the client tier
Student Response
B. at the DBMS tier with a stored procedure
C. using a scrolling facility in the client interface
D. in middleware correct answers B. at the DBMS tier with a stored procedure
PSI uses a customer information data entry screen for its corporate clients that includes three
mandatory fields: customer name, postal code, and phone number. If the clerk leaves all three of
these fields blank, which is the BEST way to be sure the input error does NOT cause the
program to crash?
A. Data validation
B. Exception handling
C. Debugging procedures
D. Data verification correct answers A. Data validation
Due to a recent merger, developers must be able to create a single application that can access
multiple databases (i.e., Oracle, SYBASE, and INFORMIX). The Web server data environment
that BEST allows access to SQL-based databases is
A. OLE DB
B. ODBC
C. HTML
D. XML correct answers B. ODBC
As a service, Bruce donated his time to a local charity to develop a web site. After the
development, he intends to train a person at the charity to maintain the site. Which would be
BEST for developing the site?
A. A high end web development package with database connectivity
B. A reasonably priced graphical page editor
C. Native HTML coding using a text editor
D. A package that Bruce has available to him through his employer correct answers C. Native
HTML coding using a text editor
Each point in a data flow diagram where a data flow intersects a process should be represented in
the physical design of a data base by a(n) _________ .
A. relation
B. user view
