SQL

Question 1

If you want to list all the rows in the tables, you do not need to include the word WHERE in a SQL statement.

Answer

true

Question 2

SQL has built-in functions, also called aggregate functions, to calculate the number of entries, the sum or average of all entries in a given column, and the largest or smallest of the entries in a given column.

Answer

true

Question 3

To add records to a table, use the SQL ____ command.

Accepted Answer

INSERT INTO

Answer

ADD INTO

Answer

APPEND

Answer

RECORD

Question 4

To create a query that groups all accounts with the same account manager number, include the ____ clause in the SQL command.

Accepted Answer

GROUP BY

Answer

HAVING

Answer

GROUP AND SORT

Answer

ARRANGE BY

Question 5

To name a computed field, follow the computation with the word ____ and then the name you wish to assign to the field.

Accepted Answer

AS

Answer

NAME

Answer

ASSIGN

Answer

GIVING

Question 6

When simple criteria are connected by the word OR, all the simple criteria must be true in order for the compound criterion to be true.

Answer

true

Question 7

When simple criteria are connected by the word AND, all the simple criteria must be true in order for the compound criterion to be true.

Answer

true

Question 8

You can use a(n) ____ clause with a list as an alternative to an OR criterion when the OR criterion involves a single field.

Accepted Answer

IN

Answer

WITHIN

Answer

LIST

Answer

BETWEEN

Question 9

The UNIQUE operator eliminates duplicate values in the results of a query.

Answer

true

Question 10

A table is in third normal form (3NF) if it is in second normal form and if the only determinants it contains are ____ keys.

Accepted Answer

CANDIDATE

Answer

ALTERNATE

Answer

INDEXED

Answer

PRIMARY

Question 11

Rows in a table often are called ____.

Accepted Answer

RECORDS

Accepted Answer

TUPLES

Answer

ATTRIBUTES

Answer

FIELDS

Question 12

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

Answer

true

Question 13

A table is in third normal form (3NF) if it is second normal form (2NF) and if the only determinants it contains are candidate keys.

Answer

true

Question 14

To depict the structure of a relational database, you can use a commonly accepted shorthand representation. You write the name of the table and then within ____ list all of the fields in the table.

Accepted Answer

PARENTHESES ()

Answer

SQUARE BRACKETS []

Answer

CURLY BRACES {}

Answer

SLASHES //

Question 15

Rows in a table often are called records or ____.

Accepted Answer

TUPLES

Answer

ATTRIBUTES

Answer

LINES

Answer

RELATIONS

Question 16

A field is a dependent field if it is not part of the primary key.

Answer

true

Question 17

In designing a database, you must first identify the fields in the database and then the tables.

Answer

true

Question 18

The most common normal forms are ____.

Accepted Answer

1NF

Accepted Answer

2NF

Accepted Answer

3NF

Answer

4NF

Question 19

To determine the number of customers assigned to a particular account manager, use the ____ aggregate function.

Accepted Answer

COUNT

Answer

AVG

Answer

TOTAL

Answer

NUMBER

Question 20

Use a query to ____ tables; that is, to find records in two tables that have identical values in matching fields.

Accepted Answer

JOIN

Answer

COMBINE

Answer

CONCATENATE

Answer

INTERLEAVE

Question 21

If a criterion involves a text field, the value must be enclosed in curly braces { }.

Answer

true

Question 22

SQL is a non-standardized language.

Answer

true

Question 23

To save a query, click the Save button on the ____.

Accepted Answer

QUICK ACCESS TOOLBAR

Answer

HOME TAB ON THE RIBBON

Answer

CREATE TAB ON THE RIBBON

Answer

STATUS BAR

Question 24

If a criterion involves a text field, the value must be enclosed in quotation marks.

Answer

true

Question 25

The ____ query enables you to send SQL commands directly to ODBC (Open Database Connectivity) databases.

Accepted Answer

PASS-THROUGH

Answer

PROTOTYPE

Answer

DATA DEFINITION

Answer

DATA CONTROL

Question 26

When simple criteria are connected by the word ____, the compound criterion will be true whenever any of the simple criteria are true.

Accepted Answer

OR

Answer

BETWEEN

Answer

AND

Answer

NOT

Question 27

To include all fields in a SQL query, use the ____ symbol after the word SELECT

Accepted Answer

ASTERISK *

Answer

POUND #

Answer

AMPERSAND &

Answer

PERCENT %

Question 28

To view the results of a SQL query, type the SQL statement and then click the ____ button on QUERY TOOLS DESIGN tab to view the results.

Accepted Answer

VIEW

Answer

RESULT

Answer

SQL

Answer

EXECUTE

Question 29

Columns in a table often are called fields or ____.

Accepted Answer

ATTRIBUTES

Answer

LINES

Answer

RELATIONS

Answer

TUPLES

Question 30

Rows in a table often are called ____.

Accepted Answer

RECORDS

Accepted Answer

TUPLES

Answer

ATTRIBUTES

Answer

FIELDS

Question 31

The normalization process involves converting tables into various types of ____.

Accepted Answer

NORMAL FORMS

Answer

TUPLES

Answer

RELATIONS

Answer

DIAGRAMS

Question 32

A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.

Answer

true

Question 33

In a relational database, each row should be ____.

Accepted Answer

UNIQUE

Answer

UPDATED

Answer

NORMALIZED

Answer

NON-DESCRIPT

Question 34

In designing a database, you must first identify the fields in the database and then the tables.

Answer

true

Question 35

A(n) ____ key is a field in one table whose values are required to match the primary key of another table.

Accepted Answer

FOREIGN

Answer

ALTERNATE

Answer

CANDIDATE

Answer

RELATIONAL

Question 36

If an account can be offered many workshops and each workshop is offered to many accounts, there is a many-to-many relationship between accounts and workshops.

Answer

true

Question 37

The determination of database requirements is part of a process known as systems analysis.

Answer

true

Question 38

A(n) ____ is like a noun: It is a person, place, thing, or event.

Accepted Answer

ENTITY

Answer

RECORD

Answer

TUPLE

Answer

ATTRIBUTE

Question 39

To sort in descending order, follow the name of the sort key with the DESC operator.

Answer

true

Question 40

SQL is a non-standardized language.

Answer

true

Question 41

To display a blank window to begin typing SQL commands, click ____ on the View menu in the Query Design window.

Accepted Answer

SQL VIEW

Answer

COMMAND VIEW

Answer

SQL COMMANDS

Answer

BLANK WINDOW

Question 42

SQL has special format rules for placement of terms and capitalization.

Answer

true

Question 43

To include all fields in a SQL query, use the ____ symbol after the word SELECT.

Accepted Answer

ASTERISK *

Answer

POUND #

Answer

AMPERSAND &

Answer

PERCENT %

Question 44

If data is to be sorted on two fields, the more important key is called the ____.

Accepted Answer

MAJOR SORT KEY

Accepted Answer

PRIMARY SORT KEY

Answer

FIRST SORT KEY

Answer

LEFT SORT KEY

Question 45

To use the word NOT in a criterion, follow the criterion with the word NOT.

Answer

true

Question 46

To create a query that groups all accounts with the same account manager number, include the ____ clause in the SQL command.

Accepted Answer

GROUP BY

Answer

HAVING

Answer

GROUP AND SORT

Answer

ARRANGE BY

Question 47

To save a query with a new name, display the Save As tab in Backstage view, and click ____ in the File Types area of the Save As gallery.

Accepted Answer

SAVE OBJECT AS

Answer

SAVE QUERY AS

Answer

SAVE

Answer

SAVE DATABASE AS

Question 48

When simple criteria are connected by the word ____, all the simple criteria must be true in order for the compound criterion to be true.

Accepted Answer

AND

Answer

JOIN

Answer

OR

Answer

NOT

Question 49

You can use an entity-relationship diagram (ERD) to diagram a database design.

Answer

true

Question 50

Columns in a table often are called ____.

Accepted Answer

ATTRIBUTES

Accepted Answer

FIELDS

Answer

RECORDS

Answer

TUPLES

Question 51

A table that contains a repeating group, or multiple entries for a single row, is called a(n) ____ table.

Accepted Answer

UNNORMALIZED

Answer

1NF

Answer

REDUNDANT

Answer

DUPLICATE

Question 52

If you use the word, Order, for the name of a table, you cannot use SQL to query that table.

Answer

true

Question 53

If you have already created a database and relationships in Access, the ____ window and corresponding report provide a helpful diagram of the design.

Accepted Answer

RELATIONSHIPS

Answer

REFERENTIAL INTEGRITY

Answer

DATABASE TOOLS

Answer

ERD

Question 54

A(n) ____ is a property of an entity.

Accepted Answer

ATTRIBUTE

Answer

RECORD

Answer

TUPLE

Answer

ENTITY

Question 55

In a relational database, the order of the rows and the order of the columns are ____.

Accepted Answer

IMMATERIAL

Answer

PREDETERMINED

Answer

CRITICAL

Answer

DISTINCT

Question 56

When creating a database, a(n) ____ is represented as a table.

Accepted Answer

ENTITY

Answer

ATTRIBUTE

Answer

DETERMINANT

Answer

TUPLE

Question 57

Any field or collection of fields that determines another field is called a(n) ____.

Accepted Answer

DETERMINANT

Answer

ATTRIBUTE

Answer

ANTIPODE

Answer

DESCENDENT

SQL

Erstelle ein kostenloses Konto, um dieses Quiz zu beenden

Fragen in diesem Quiz (57)

Informationen

Feedback

Wie gefällt dir das neue Design?