Certiport Software Development #1-4 EXAM
QUESTIONS AND CORRECT {VERIFIED}
ANSWERS NEWEST UPDATE|ALREADY GRADED
A+.
Save
Terms in this set (77)
The server limits data B.) Connection Pooling
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
,The database A.) Call a stored procedure
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
A database dictionary that D.) Metadata
describes the structure of
a database is called
______________
A.) DBMS
B.) Metacontent
C.) Normalization
D.) Metadata
You need to ensure the C.) Normalization
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
,Your database has a table B.) SELECT firstName, lastName, email FROM students
called students that ORDER BY lastName, firstName
contains the following
fields:
firstNamelastNameemailA
ddressphone
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
, Your application must pull B.) Establish a connection to the database by using
data from a database on a the appropriate data provider
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
Using Asp.net, you need A.) Application
to store a value that can
be shared across users on
the server
A.) Application
B.) Session
C.) ViewState
D.) Cookies
What is the term for small D.) Cookie
units of text that are
stored on a client
computer?
A.)Trace
B.) Transfer
C.) Cross page post
D.) Cookie
QUESTIONS AND CORRECT {VERIFIED}
ANSWERS NEWEST UPDATE|ALREADY GRADED
A+.
Save
Terms in this set (77)
The server limits data B.) Connection Pooling
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
,The database A.) Call a stored procedure
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
A database dictionary that D.) Metadata
describes the structure of
a database is called
______________
A.) DBMS
B.) Metacontent
C.) Normalization
D.) Metadata
You need to ensure the C.) Normalization
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
,Your database has a table B.) SELECT firstName, lastName, email FROM students
called students that ORDER BY lastName, firstName
contains the following
fields:
firstNamelastNameemailA
ddressphone
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
, Your application must pull B.) Establish a connection to the database by using
data from a database on a the appropriate data provider
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
Using Asp.net, you need A.) Application
to store a value that can
be shared across users on
the server
A.) Application
B.) Session
C.) ViewState
D.) Cookies
What is the term for small D.) Cookie
units of text that are
stored on a client
computer?
A.)Trace
B.) Transfer
C.) Cross page post
D.) Cookie
