ITE 152 Final Exam 3 Practice Test Questions with Correct Answers | Latest Update

ITE 152 FINAL EXAM 3 PRACTICE EXAM TEST
QUESTIONS WITH CORRECT ANSWERS
LATEST UPDATE EXAM TESTED AND
APPROVED




What does SQL stand for?

-Stated question language

-Structured query language

-System query lingo

-Status query language --CORRECT ANSWER--Structured query language



Which of the following is LEAST likely to be a field in a Customers table?

-LastName

-Address

-EmploymentDate

-PhoneNumber --CORRECT ANSWER--EmploymentDate



A relationship is created between how many tables?

-Two

-Any number


pg. 1

,-Three

-One --CORRECT ANSWER--Two



What is a query?

-A question you ask a table

-A question you ask a record

-A question you ask a database

-A question you ask a field --CORRECT ANSWER--A question you ask a
database



A computerized database can store millions of telephone numbers.

-True

-False --CORRECT ANSWER--True



Which data type would be best suited to a field that lists customer email
addresses?

-Hyperlink

-AutoNumber

-Date/Time

-Number --CORRECT ANSWER--Hyperlink



Databases typically store their data in one big table.


pg. 2

, -True

-False --CORRECT ANSWER--False



All the pet names in a veterinarian's database are stored in a _______ called
PetName.

-record

-table

-worksheet

-field --CORRECT ANSWER--Field



Malisa is designing a database for a doctor's office where receptionists, office
managers, and other office staff will need to manage patient data. Which
database object should Malisa create to make it easy for these non-technical
users to add patient records?

-Forms

-Queries

-Reports

-Tables --CORRECT ANSWER--Forms



Queries in access can be used

-Both 'a' and 'b'

-Only 'a'

-as a source of records for forms and reports

pg. 3