Certiport Software Development #1 with
Complete Solutions
The server limits data 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 - ANS-B.) Connection Pooling
The database administrator 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 - ANS-A.) Call a stored procedure
A database dictionary that describes the structure of a database is called
______________
A.) DBMS
B.) Metacontent
C.) Normalization
D.) Metadata - ANS-D.) Metadata
You need to ensure the 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 - ANS-C.) Normalization
Your database has a table called students that contains the following fields:
firstNamelastNameemailAddressphone
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
