Certiport Software Development #1-4
Exam Questions And Answers Latest
Update
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 ______________
,Certiport Software Development #1-4
Exam Questions And Answers Latest
Update
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
,Certiport Software Development #1-4
Exam Questions And Answers Latest
Update
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
, Certiport Software Development #1-4
Exam Questions And Answers Latest
Update
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
B.) Session
C.) ViewState
D.) Cookies -
correct 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 -
correct answer ✅D.) Cookie
Exam Questions And Answers Latest
Update
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 ______________
,Certiport Software Development #1-4
Exam Questions And Answers Latest
Update
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
,Certiport Software Development #1-4
Exam Questions And Answers Latest
Update
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
, Certiport Software Development #1-4
Exam Questions And Answers Latest
Update
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
B.) Session
C.) ViewState
D.) Cookies -
correct 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 -
correct answer ✅D.) Cookie
