Certiport Software Development #1 UPDATED ACTUAL Exam Questions and CORRECT Answers

Certiport Software Development #1
UPDATED ACTUAL Exam Questions and
CORRECT Answers
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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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 - CORRECT ANSWER - 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
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 -
CORRECT ANSWER - B.) SELECT firstName, lastName, email FROM students
ORDER BY lastName, firstName


Your application must pull data from a database on a separate server. What must you do?


A.) Install the database on each client computer
B.) Establish a connection to the database by using the appropriate data provider
C.) Create a routine that bypasses firewalls

D.) Configure the network routers to allow database connections - CORRECT ANSWER -
B.) Establish a connection to the database by using the appropriate data provider


Using Asp.net, you need to store a value that can be shared across users on the server


A.) Application