CERTIPORT SOFTWARE DEVELOPMENT #1-4 EXAM QUESTIONS AND CORRECT ANSWERS LATEST UPDATE

CERTIPORT SOFTWARE DEVELOPMENT #1-4
EXAM QUESTIONS AND CORRECT ANSWERS
LATEST UPDATE 2025-2026
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

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



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

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

D.) Cookie - answer>>>D.) Cookie



For these statements match the correct response

XHTML attribute names must be in uppercase

XHTML attribute names must be in quotation marks

XHTML attribute minimization is forbidden



A.) True, False, True

B.) True, False, False

C.) True, True, True

D.) False, True, True - answer>>>D.) False, True, True



Which function does Simple Object Access Protocol (SOAP) provide when using web service?



A.) Model for describing Web services

B.) Directory of registered web services

C.) Communications protocol

D.) Security model - answer>>>C.) communications protocol



You need to debug a Windows Service application by using breakpoints.What should you do?



A.) Implement the Console.WriteLine method throughout the Windows Service.