CERTIPORT SOFTWARE DEVELOPMENT FINAL EXAM QUESTIONS AND DETAILED SOLUTIONS COMPLETE PREPARATION GUIDE

CERTIPORT SOFTWARE DEVELOPMENT
FINAL EXAM QUESTIONS AND DETAILED
SOLUTIONS COMPLETE PREPARATION
GUIDE

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