COMPUTER SCIENCE CERTIPORT SOFTWARE DEVELOPMENT #1-4

1|Page




COMPUTER SCIENCE CERTIPORT SOFTWARE
DEVELOPMENT #1-4

NEWLY FORMATTED DOCUMENT




The server limits data B.) Connection Pooling
connections. What should
you use for connectivity
when the number of users
exceeds the number of
connections?


A.) Named Pipes
B.) Connection Pooling
C.) Connection Timeouts
D.) Normalization

,2|Page

The database administrator A.) Call a stored procedure
will not allow you to write
SQL code in your
application how do you
retrieve data?


A.) Call a stored
procedure
B.) Script a SELECT
statement to a file
C.) reference an index in
the database
D.) Query a database view

,3|Page



A database dictionary that D.) Metadata
describes the structure of a
database is called
______________


A.) DBMS
B.) Metacontent
C.) Normalization
D.) Metadata

You need to ensure the C.) Normalization
data integrity of a database
by resolving insertion,
update, and deletion
anomalies. Which term is
used to describe this
process?


A.) Resolution
B.) Integration
C.) Normalization
D.) Isolation

, 4|Page



Your database has a table B.) SELECT firstName, lastName, email FROM students
called students that ORDER BY lastName, firstName
contains the following
fields:
firstNamelastNameemailA
ddressphone
You need to get the
firstName, last Name, and
email for all students listed
alphabetically by last name
and then first name.


A.) SELECT lastName,
firstName FROM students
ORDER BY lastName,
firstName
B.) SELECT firstName,
lastName, email FROM
students ORDER BY
lastName, firstName
C.) SELECT firstName,
lastName, email FROM
students ORDER BY
firstName, lastName
D.) SELECT firstName,
lastName FROM students
ORDER BY lastName,
firstName