ICT
.
- 1.
We created the query below to find all customers who have placed orders. But this query also returns customers who haven't placed orders. What's wrong with the query below?
- A.
We did not join the correct tables
- B.
We need to change the join from left to right to right to left
- C.
We did not include the correct criteria
- D.
We did not use the sort command
Correct Answer
B. We need to change the join from left to right to right to left -
- 2.
Let's say we're creating a query to find all customers who have paid for an order and who live in North Carolina but not in the city of Raleigh. This is our query so far:What should we enter in the Criteria row of the City field to get the results we want?
- A.
Not like ("Raleigh")
- B.
Like ("Raleigh")
- C.
Everything except "Raleigh"
- D.
Like ("North Carolina")
Correct Answer
A. Not like ("Raleigh") -
- 3.
Where can you find a list of every object in a database?
- A.
Navigation pane
- B.
Document Tabs bar
- C.
Taskbar
- D.
Ribbon
Correct Answer
A. Navigation pane -
- 4.
Let's say you wanted to sort this customer list in ascending order by last name. Was this example sorted correctly?
- A.
No; the list is in descending order instead of ascending order
- B.
No; the list is sorted by zip code instead of last name
- C.
Yes; it is sorted correctly
- D.
No; the list is sorted by first name instead of last name
Correct Answer
A. No; the list is in descending order instead of ascending order -
- 5.
Which of the following are objects of an Access database? Check all that apply (There are 4 answers).
- A.
Form
- B.
Table
- C.
Report
- D.
Chart
- E.
Query
Correct Answer(s)
A. Form
B. Table
C. Report
E. Query -
- 6.
In Access, the rows and columns of a table are referred to as __________________.
- A.
Placeholders and categories
- B.
Records and fields
- C.
Rows and columns
- D.
Filters and categories
Correct Answer
B. Records and fields -
- 7.
What is the first step in planning a multi-table query?
- A.
Decide exactly what you want to know
- B.
Determine the direction of the join line
- C.
Make a list of the fields you need
- D.
Write your query criteria
Correct Answer
A. Decide exactly what you want to know -
- 8.
Let's say we created a form for customers to enter their addresses. Now we're having trouble organizing the records because some customers type the complete state name, while others type only the abbreviation. How could we prevent this from happening?
- A.
Create a validation rule
- B.
Run a query
- C.
Create a totals row
- D.
Insert sort criteria
Correct Answer
A. Create a validation rule -
- 9.
Which button should you click to delete a record?
- A.
Button B
- B.
Button C
- C.
Button A
Correct Answer
A. Button B -
- 10.
You cannot save an entire database at once. You must save each object separately. (True or False)
- A.
True
- B.
False
Correct Answer
A. True -
- 11.
Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
- A.
Foreign key
- B.
Native key
- C.
Composite key
- D.
Primary key
Correct Answer
D. Primary key -
- 12.
An Access database object that is used to enter, view or edit records
- A.
Menu
- B.
Form
- C.
Query
- D.
Report
Correct Answer
B. Form -
- 13.
Which of the following can be an example of a database?
- A.
Address book of all the suppliers of a company
- B.
Salary sheet of all the employees of a company
- C.
Records of daily sales transactions of a company
- D.
All of above
Correct Answer
D. All of above -
- 14.
Collection of related records in a database is known as
- A.
File
- B.
Bench
- C.
Table
- D.
Relationship
Correct Answer
C. Table -
- 15.
A database object in MS Access that stores a question about the data in database?
- A.
Table
- B.
Form
- C.
Query
- D.
Report
Correct Answer
C. Query -
- 16.
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
- A.
A relationship is created
- B.
Edit relationship dialog box appears
- C.
Error occurs
- D.
Nothing happens
Correct Answer
B. Edit relationship dialog box appears -
- 17.
A part of database that stores only one type of data is
- A.
Field
- B.
Query
- C.
Record
- D.
Report
Correct Answer
A. Field -
- 18.
Which of the following database object hold data?
- A.
Tables
- B.
Queries
- C.
Reports
- D.
Forms
Correct Answer
A. Tables -
- 19.
In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______
- A.
Parent, Child
- B.
Child, Parent
- C.
Brother, Sister
- D.
Father, Son
Correct Answer
A. Parent, Child -
- 20.
The complete information about an entity in a database is called
- A.
Record
- B.
Field
- C.
View
- D.
Queries
Correct Answer
A. Record -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 14, 2017Quiz Edited by
ProProfs Editorial Team -
Oct 16, 2016Quiz Created by
Kamila
Back to top