DATABASE DESIGN & APPLICATION A
Email address *
31)  The ______ Query Wizard adds a filter expression that finds unlinked records in related tables.
1 point
40)  A “top value” query would help to answer which one of the following questions?
1 point
18)  ____ and recovery services, which are mechanisms for recovering the database in the event the database is damaged in any way, are among the features that a DBMS should furnish. 
1 point
28)  A(n) ___ query can be used to prompt the user for data before searching.
1 point
46)  A(n) _____ cannot reference a declared temporary table.
1 point
36)  If you specify more than one sort, the sort column to the right will be which one of the following?
1 point
2)  What is the term for a component in a database?
0 points
49)  This is an example of when Microsoft Access deletes a record and all of the relating records.
1 point
32)  You have a SQL database with a single table called 'countries'. There are columns for name, area, region, population and gdp. What SQL query would show each region only once?
1 point
11)  Press this key to access help in Access.
1 point
30)  If you forgot to set a primary key or create a unique index for your table, then this can help you clean up the mess.
1 point
4)  Which stores information about people, places, things, or events?
1 point
Password *
Your answer
17)  The purpose of “Field Size” in a table is to:
1 point
20)  Which one of the following questions is not a critical design consideration when planning a database design?
1 point
22)  You open up the database called “Northwind Traders” and enter a phone number in the format 888-767-5143. The database automatically converts it to the style (888) 767-5143. Which one of the following features is responsible for the conversion?
1 point
35)  Assume that you have two columns in a database formatted with Date/Time data, “Date Shipped” and “Date Purchased”. Which one of these expressions would calculate the difference between those two columns?
1 point
23)  This validation rule ensures that a field with a numeric data type does notexceed a reasonable limit.
1 point
What is your name? *
Your answer
39)  All of the following except this are options that are available when using the query wizard in Access.
1 point
16)  To “filter” out data based on criteria specified and to produce an unformatted document, you would use a:
1 point
37)  Which one of the following WHERE clauses would correctly show all records from the database with a last name of “Robinson?”
1 point
6)  What command allows you to specify the database you wish to work with?
1 point
12)  If a serious problem occurs with your database, do this.
1 point
51)  Which one of the following fields would be the best primary key in a table named “Person”?
1 point
44)  The _____ JOIN compares all columns in both tables that have the same column name in the joined tables.
1 point
48)  To open the Edit Relationships dialog box, __________ on the sloping portion of the join line.
1 point
50)  To print wide database tables use ____ orientation.
1 point
3)  When data has been broken down into separate smaller tables with no repetition of data, this is known as:
0 points
14)  The “Compact and Repair” feature in Microsoft Access is best used:
1 point
45)  If you specify the _____ as a column constraint, an implicit column list is composed of the column name or names that are listed.
1 point
38)  Which one of the following is the proper way to show all the “Title” records from the table called “Album”?
1 point
21)  What text field property displays a model or pattern for consistency when entering data?
1 point
43)  What can cause problems when using relationships?
1 point
1)  In a database of automobiles owned by employees, which of the following fields would best be chosen as the primary key?
1 point
47)  A junction table is used when you have which type of table relationship?
1 point
25)  If you have to store a large amount of text in a database (for example, notes on a complex product order) that could be more than a paragraph long, which one of the following field types would be most appropriate to use?
1 point
7)  What does SQL stand for?
1 point
13)  An alphabetical sort from Z to A in any database system is a:
1 point
19)  When an Access database is opened, you would like a “menu” to appear for the user to select from a list of the most popular/common database operations. This is called:
1 point
10)  Microsoft Access databases exist as a single file. If the database is moved to another folder, which one of the following errors will likely occur when the database file is opened?
1 point
5)  What is a series of commands which have been scripted for repetitive activities?
1 point
15)  Which one of the following is not a vital, necessary part of most databases?
1 point
27)  Which one of the following database data types would store a five megabyte picture file within a database?
1 point
9)  Microsoft Access integrates tightly with SharePoint Services. SharePoint services:
1 point
33)  The default query type for Access is a(n) ______query.
1 point
8)  Which one of the following feeds data into query results to produce requested information?
1 point
41)  Which query function does not relate to an Access database for fields with numbers?
1 point
34)  Which one of the following SQL Statements would update data in a database table?
1 point
24)  You open up a database called “Southwest Traders” and enter a zip code in the format 60610. The database automatically converts it to the style 60610-0000. Which one of the following features is responsible for the conversion?
1 point
29)  In Access, the ______Query Wizard lets you summarize large amounts of data using different calculations.
1 point
26)  When inserting a new record into an Access database, you accidentally enter a duplicate primary key for a record and the software disallows the new record until a unique key is entered. Which one of the following data types should be used for the primary key to help solve this problem?
1 point
Submit
Never submit passwords through Google Forms.
reCAPTCHA
This content is neither created nor endorsed by Google. Report Abuse - Terms of Service