Database, Security, and Cloud Technology Exam Q&A

RESEARCHEDITE152EXAMQUESTIONS j j j j




ANDANSWERS j




All the pet names in a veterinarian's database are stored in a
j j j j j j j j j j j j calledPetName. -CORRECT
j j j




ANSWER -field
j j




Which of the following is the easiest way add data to a table. - CORRECT ANSWER -form
j j j j j j j j j j j j j j j j




In a record, each separate piece of data, such as a last name, a first name, or an address, is called a
j j j j j j j j j j j j j j j j j j j j j




. - CORRECT ANSWER -field j j j j




In a database, each
j j j j contains a collection of related data. - CORRECT ANSWER -table
j j j j j j j j j




What does SQL stand for? - CORRECT ANSWER -Structured Query Language
j j j j j j j j j j




In a database, a
j j j j is a unit of information about one individual or item. - CORRECT
j j j j j j j j j j j




ANSWER -record
j j




Which of the following is a way to sort data? - CORRECT ANSWER -all of the above
j j j j j j j j j j j j j j j j




This key uniquely identifies each record. - CORRECT ANSWER -primary key
j j j j j j j j j j




Queries in access can be used - CORRECT ANSWER -both
j j j j j j j j j




Which of the following is LEAST likely to be a field in a Customers table? - CORRECT ANSWER -
j j j j j j j j j j j j j j j j j j




Employment date
j j

, Contact information for all the people taking a class at a school are stored in a
j j j j j j j j j j j j j j j j called Students. j




- CORRECT ANSWER -table
j j j




Dana is creating a table that will show books for sale on a bookstore's website. Which field in the table would
j j j j j j j j j j j j j j j j j j j j




best serve as its primary key? - CORRECT ANSWER -product id
j j j j j j j j j j j




What are the columns in a Microsoft Access table called? - CORRECT ANSWER -fields
j j j j j j j j j j j j j




A computerized database can store millions of telephone numbers. - CORRECT ANSWER -true
j j j j j j j j j j j j




Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is the most
j j j j j j j j j j j j j j j j j j j j j j j j




likely problem? - CORRECT ANSWER -the table is filtered
j j j j j j j j j




Which field could serve as the primary key for a list of students in your school? - CORRECT ANSWER - student
j j j j j j j j j j j j j j j j j j j j




id number
j j




Databases are useful only if they are j j j j j j j . - CORRECT ANSWER -accurate
j j j j




A database is an organized collection of information. - CORRECT ANSWER -true
j j j j j j j j j j j




What does a filter do? - CORRECT ANSWER -hide records from view
j j j j j j j j j j j




Which of the following is NOT a part of a database? - CORRECT ANSWER -worksheets
j j j j j j j j j j j j j j




Malisa is designing a database for a doctor's office where receptionists, office managers, and other office
j j j j j j j j j j j j j j j




staff will need to manage patient data. Which database object should Malisa create to make it easy for these
j j j j j j j j j j j j j j j j j j j




non-technical users to add patient records? - CORRECT ANSWER -forms
j j j j j j j j j j