Certiport Software Development #1 Exam Questions and Answers | Verified | Graded A

Certiport Software Development #1
Exam Questions and 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 Answers -B.) Connection Pooling

Which two types of information should you include in an effective test case? (Choose
two.)

A.) any pre-conditions necessary to test the case
B.) the expected result from testing the case
C.) multiple actions combined as a single step to test the case
D.) the stakeholders who originated the test case - Correct Answers -A.) any pre-
conditions necessary to test the case
B.) the expected result from testing the case

The Dog class and the Cat class inherit from the Animal class. The Animal class
includes a breathe() method and a speak() method. If the speak() method is called from
an object of type Dog, the result is a bark. If the speak() method is called from an object
of type Cat, the result is a meow.
Which term is used to describe this object-oriented concept?

A.) Encapsulation
B.) No answer text provided.
C.) Data hiding
D.) Polymorphism - Correct Answers -D.) Polymorphism

In your student directory database, the Students table contains the following fields:
firstName
lastName
emailAddress
telephoneNumber
You need to retrieve the data from the firstName, lastName, and emailAddress fields for
all students listed in the directory. The results must be in alphabetical order according to

, lastName and then firstName. - Correct Answers -SELECT firstName, lastName,
emailAddress FROM Students ORDER BY lastName, firstName

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 Answers -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 Answers -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 Answers -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 Answers -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