1|Page
CERTIPORT SOFTWARE DEVELOPMENT TEST EXAM
CURRENTLY TESTING COMPLETE EXAM QUESTIONS
WITH DETAILED VERIFIED ANSWERS (100%
CORRECT ANSWERS) /ALREADY GRADED A+/
LATEST EXAM!!!
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 - 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
,2|Page
D.) Query a database view - 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 - 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 - Answer-C.) Normalization
,3|Page
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 - 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
, 4|Page
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 - 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
B.) Session
C.) ViewState
D.) Cookies - Answer-A.) Application
What is the term for small units of text that are stored on a
client computer?
A.)Trace
B.) Transfer
C.) Cross page post
CERTIPORT SOFTWARE DEVELOPMENT TEST EXAM
CURRENTLY TESTING COMPLETE EXAM QUESTIONS
WITH DETAILED VERIFIED ANSWERS (100%
CORRECT ANSWERS) /ALREADY GRADED A+/
LATEST EXAM!!!
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 - 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
,2|Page
D.) Query a database view - 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 - 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 - Answer-C.) Normalization
,3|Page
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 - 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
, 4|Page
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 - 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
B.) Session
C.) ViewState
D.) Cookies - Answer-A.) Application
What is the term for small units of text that are stored on a
client computer?
A.)Trace
B.) Transfer
C.) Cross page post
