Quiz
SQL
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (57)
1If you want to list all the rows in the tables, you do not need to include the word WHERE in a SQL statement.
- ATrue
- BFalse
2SQL 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.
- ATrue
- BFalse
3To add records to a table, use the SQL ____ command.
- AADD INTO
- BAPPEND
- CRECORD
- DINSERT INTO
4To create a query that groups all accounts with the same account manager number, include the ____ clause in the SQL command.
- AGROUP BY
- BHAVING
- CGROUP AND SORT
- DARRANGE BY
5To name a computed field, follow the computation with the word ____ and then the name you wish to assign to the field.
- ANAME
- BAS
- CASSIGN
- DGIVING
6When simple criteria are connected by the word OR, all the simple criteria must be true in order for the compound criterion to be true.
- ATrue
- BFalse
7When simple criteria are connected by the word AND, all the simple criteria must be true in order for the compound criterion to be true.
- ATrue
- BFalse
8You can use a(n) ____ clause with a list as an alternative to an OR criterion when the OR criterion involves a single field.
- AWITHIN
- BLIST
- CIN
- DBETWEEN
9The UNIQUE operator eliminates duplicate values in the results of a query.
- ATrue
- BFalse
10A table is in third normal form (3NF) if it is in second normal form and if the only determinants it contains are ____ keys.
- AALTERNATE
- BINDEXED
- CPRIMARY
- DCANDIDATE
11Rows in a table often are called ____.
- ARECORDS
- BATTRIBUTES
- CFIELDS
- DTUPLES
12If you use the word, Order, for the name of a table, you cannot use SQL to query that table.
- ATrue
- BFalse
13A table is in third normal form (3NF) if it is second normal form (2NF) and if the only determinants it contains are candidate keys.
- ATrue
- BFalse
14To 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.
- ASQUARE BRACKETS []
- BCURLY BRACES {}
- CSLASHES //
- DPARENTHESES ()
15Rows in a table often are called records or ____.
- AATTRIBUTES
- BLINES
- CRELATIONS
- DTUPLES
16A field is a dependent field if it is not part of the primary key.
- ATrue
- BFalse
17In designing a database, you must first identify the fields in the database and then the tables.
- ATrue
- BFalse
18The most common normal forms are ____.
- A1NF
- B2NF
- C3NF
- D4NF
19To determine the number of customers assigned to a particular account manager, use the ____ aggregate function.
- AAVG
- BTOTAL
- CNUMBER
- DCOUNT
20Use a query to ____ tables; that is, to find records in two tables that have identical values in matching fields.
- ACOMBINE
- BCONCATENATE
- CINTERLEAVE
- DJOIN
21If a criterion involves a text field, the value must be enclosed in curly braces { }.
- ATrue
- BFalse
22SQL is a non-standardized language.
- ATrue
- BFalse
23To save a query, click the Save button on the ____.
- AHOME TAB ON THE RIBBON
- BCREATE TAB ON THE RIBBON
- CSTATUS BAR
- DQUICK ACCESS TOOLBAR
24If a criterion involves a text field, the value must be enclosed in quotation marks.
- ATrue
- BFalse
25The ____ query enables you to send SQL commands directly to ODBC (Open Database Connectivity) databases.
- APASS-THROUGH
- BPROTOTYPE
- CDATA DEFINITION
- DDATA CONTROL
26When simple criteria are connected by the word ____, the compound criterion will be true whenever any of the simple criteria are true.
- ABETWEEN
- BAND
- COR
- DNOT
27To include all fields in a SQL query, use the ____ symbol after the word SELECT
- APOUND #
- BAMPERSAND &
- CPERCENT %
- DASTERISK *
28To 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.
- ARESULT
- BVIEW
- CSQL
- DEXECUTE
29Columns in a table often are called fields or ____.
- AATTRIBUTES
- BLINES
- CRELATIONS
- DTUPLES
30Rows in a table often are called ____.
- ARECORDS
- BATTRIBUTES
- CFIELDS
- DTUPLES
31The normalization process involves converting tables into various types of ____.
- ATUPLES
- BRELATIONS
- CNORMAL FORMS
- DDIAGRAMS
32A table that contains a repeating group, or multiple entries for a single row, is called a non-standard table.
- ATrue
- BFalse
33In a relational database, each row should be ____.
- AUPDATED
- BUNIQUE
- CNORMALIZED
- DNON-DESCRIPT
34In designing a database, you must first identify the fields in the database and then the tables.
- ATrue
- BFalse
35A(n) ____ key is a field in one table whose values are required to match the primary key of another table.
- AALTERNATE
- BFOREIGN
- CCANDIDATE
- DRELATIONAL
36If 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.
- ATrue
- BFalse
37The determination of database requirements is part of a process known as systems analysis.
- ATrue
- BFalse
38A(n) ____ is like a noun: It is a person, place, thing, or event.
- ARECORD
- BTUPLE
- CENTITY
- DATTRIBUTE
39To sort in descending order, follow the name of the sort key with the DESC operator.
- ATrue
- BFalse
40SQL is a non-standardized language.
- ATrue
- BFalse
41To display a blank window to begin typing SQL commands, click ____ on the View menu in the Query Design window.
- ACOMMAND VIEW
- BSQL COMMANDS
- CBLANK WINDOW
- DSQL VIEW
42SQL has special format rules for placement of terms and capitalization.
- ATrue
- BFalse
43To include all fields in a SQL query, use the ____ symbol after the word SELECT.
- APOUND #
- BAMPERSAND &
- CPERCENT %
- DASTERISK *
44If data is to be sorted on two fields, the more important key is called the ____.
- AMAJOR SORT KEY
- BFIRST SORT KEY
- CLEFT SORT KEY
- DPRIMARY SORT KEY
45To use the word NOT in a criterion, follow the criterion with the word NOT.
- ATrue
- BFalse
46To create a query that groups all accounts with the same account manager number, include the ____ clause in the SQL command.
- AGROUP BY
- BHAVING
- CGROUP AND SORT
- DARRANGE BY
47To 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.
- ASAVE QUERY AS
- BSAVE
- CSAVE DATABASE AS
- DSAVE OBJECT AS
48When simple criteria are connected by the word ____, all the simple criteria must be true in order for the compound criterion to be true.
- AJOIN
- BAND
- COR
- DNOT
49You can use an entity-relationship diagram (ERD) to diagram a database design.
- ATrue
- BFalse
50Columns in a table often are called ____.
- ARECORDS
- BATTRIBUTES
- CFIELDS
- DTUPLES
51A table that contains a repeating group, or multiple entries for a single row, is called a(n) ____ table.
- A1NF
- BUNNORMALIZED
- CREDUNDANT
- DDUPLICATE
52If you use the word, Order, for the name of a table, you cannot use SQL to query that table.
- ATrue
- BFalse
53If you have already created a database and relationships in Access, the ____ window and corresponding report provide a helpful diagram of the design.
- AREFERENTIAL INTEGRITY
- BDATABASE TOOLS
- CRELATIONSHIPS
- DERD
54A(n) ____ is a property of an entity.
- ARECORD
- BTUPLE
- CENTITY
- DATTRIBUTE
55In a relational database, the order of the rows and the order of the columns are ____.
- APREDETERMINED
- BCRITICAL
- CIMMATERIAL
- DDISTINCT
56When creating a database, a(n) ____ is represented as a table.
- AENTITY
- BATTRIBUTE
- CDETERMINANT
- DTUPLE
57Any field or collection of fields that determines another field is called a(n) ____.
- AATTRIBUTE
- BANTIPODE
- CDETERMINANT
- DDESCENDENT
Information
- Description
- Quiz on SQL, created by Rocky Ferguson on 28/04/2021.
- Author
- Rocky Ferguson
- Language
- English
- Views
- 1
- Rating
- No ratings yet Rate this quiz