Contestant Number: _______________

SQL DATABASE FUNDAMENTALS - REGIONAL 2019 Time: _________

Page 1 of 9
  Rank: _________  
 

SQL DATABASE
FUNDAMENTALS
(345)

REGIONAL – 2019
Multiple Choice:

Multiple Choice (50 @ 10 points each) ______________ (500 points)

TOTAL POINTS ______________ (500 points)

  Failure to adhere to any of the following rules will result in disqualification:

1.   Contestant must hand in this test booklet and all printouts. Failure to do so will
result in disqualification.
2.   No equipment, supplies, or materials other than those specified for this event are
allowed in the testing area. No previous BPA tests and/or sample tests or facsimile
(handwritten, photocopied, or keyed) are allowed in the testing area.
3.   Electronic devices will be monitored according to ACT standards.

No more than sixty (60) minutes testing time

 
Property of Business Professionals of America.
May be reproduced only for use in the Business Professionals of America
Workplace Skills Assessment Program competition.  
 
 
 
 
 
 
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
Page 2 of 9  

MULTIPLE CHOICE
Identify the letter of the choice that best completes the statement or answers the question. Mark
A if the statement is true. Mark B if the statement is false.

1.   What does SQL stand for?

a.   Standard Question Language
b.   Safe Query Language
c.   Structure Query Language
d.   Strong Question Language

2.   The command to remove rows from a table 'CUSTOMER' is:

a.   DELETE FROM CUSTOMER WHERE
b.   DROP FROM CUSTOMER
c.   UPDATE FROM CUSTOMER
d.   REMOVE FROM CUSTOMER

3.   Which SQL statement is used to extract data from a database

a.   Select
b.   Delete
c.   Join
d.   Group By

4.   Keys may include:

a.   Primary keys
b.   Nonunique secondary keys
c.   Unique secondary keys
d.   All of the above

5.   How do you select all the columns from a table named “Addresses”?
a.   SELECT FROM Addresses
b.   SELECT * FROM Addresses
c.   SELECT all FROM Addresses
d.   SELECT Addresses

6.   A table is:
a.   A collection of rows
b.   A collection of rows and columns
c.   A collection of data types
d.   A collection of keys, indexes, and columns
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
Page 3 of 9  

7.   Which SQL keyword is used to filter records from a table?

a.   Delete
b.   Select
c.   Having
d.   Where

8.   Which SQL keyword is used to bring back a specific number of records?

a.   Select Top
b.   Select Max
c.   Select Min
d.   Select Count

9.   Which SQL keyword enables you to add records to a table?

a.   Insert Into
b.   Update
c.   Select Into
d.   Where

10.  Which SQL keyword enables you to be able to change columns within a table?
a.   Delete
b.   Change
c.   Alter
d.   Update

11.  What would be the effect of the following UPDATE statement?  

 
UPDATE Address  
SET AddressCity = ‘Columbus’  

a.   The statement will have no effect

b.   The statement will change all the records in the table to set city as Columbus
c.   The statement will change just one record to Columbus
d.   None of the above

12.  The OR operator displays a record if ANY conditions listed are true. The AND operator
displays a record if ALL of the conditions listed are true.
a.   True
b.   False
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
Page 4 of 9  

13.  A table column within common database terminology is also considered as a(n):
a.   Data
b.   Row
c.   Record
d.   Field

14.  Which range of values defines mediumint?

a.   Integer data from 0 to 512
b.   Integer data from 0 to 756
c.   Integer data from 0 to 256
d.   Integer data from 0 16777215

15.  What does the SQL clause ORDER BY SalesAmount DESC do?
a.   Order the salespeople by sales amount lease to greatest
b.   Order the salespeople by the number of digits in the sales amount
c.   Order the salespeople by sales amount greatest to lease
d.   None of the above

16.  The acronym ETL stands for Entry, Transform, Load:

a.   True
b.   False

17.  Which acronym refers to the major functions within relational database applications?
a.   Create, Read, Update, Delete (CRUD)
b.   Select, Alter, Insert, Delete (SAID)
c.   Select, Execute, Alter, Write (SEAW)
d.   Consistency, Availability, Partition tolerance (CAP)

18.  Each table within a database must have:

a.   A unique name
b.   A primary key
c.   An index
d.   At least one record

19.  A primary key:

a.   Contains two or more fields
b.   Cannot contain null values
c.   Must contain a unique value for each row of data
d.   Both b and c
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
Page 5 of 9  

20.  A foreign key:

a.   Establishes a relationship between two or more tables within two databases
b.   Is a numeric field that increments automatically per record
c.   Links between a field in one table to a field in another table
d.   Is a value that never changes

21.  The acronym RDBMS stands for Rational Database Managerial System:
a.   True
b.   False

22.  Which of the following is not a character string data type in SQL Server?
a.   Tinytext
b.   Text
c.   Nvarchar
d.   Binary

23.  Which of the following is not a Date and Time data type within SQL Server?
a.   Dateoffset
b.   Timestamp
c.   Smalldatetime
d.   Datetime2
e.  
24.  Which of the following is not a numeric data type within SQL Server?
a.   Smallmoney
b.   Real
c.   Money
d.   Varbinary

25.  The definition of a Domain is:

a.   The possible values of an attribute, i.e. column
b.   A collection of records
c.   A set of data records
d.   The possible values of an attribute, i.e. row

26.  Which of the following should be considered when making a table within SQL?
a.   Primary keys
b.   Default values
c.   Data types
d.   All of the above
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
Page 6 of 9  

27.  Which of the following are characteristics of an RDBMS?

a.   Tables are linked by common data known as keys
b.   Data are organized in a series of two-dimensional tables each of which contains records
for one entity
c.   Keys may be unique or have multiple occurrences in the database
d.   All of the above.

28.  What is the name of the item that can store data from various databases to be used as a fast
table in memory to read and write data from?
a.   Data Source
b.   Data Set
c.   Query
d.   Data connection

29.  A database schema:

a.   Defines the tables, the fields in each table, and the relationships between fields and
tables.
b.   Is the structure of a database system
c.   Is described in a formal language supported by the database management system
d.   All of the above

30.  The acronym GUID stands for Global User Interface Device:
a.   True
b.   False

31.  SQL commands are generally grouped into four different categories. Which of the following
is not a category of SQL commands?
a.   DAC (Data Administration Commands)
b.   TCC (Transactional Control Commands)
c.   DAL (Data Abstraction Language)
d.   DQL (Data Query Language)

32.  When representing a 1:M relationship in a relational database design, ______:

a.   Both tables need a primary key, and the foreign key needs to be placed in the table that is
referencing the other table
b.   Both tables must have the same primary key
c.   An Intersection table gets the key from both relations
d.   One table needs to have a primary key while the other needs a foreign key
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
Page 7 of 9  

33.  Primary key constraints ensure:

a.   Referential integrity
b.   User-defined integrity
c.   Domain integrity
d.   Entity integrity

34.  Which of the following is not a category of data integrity?

a.   Attribute integrity
b.   Referential integrity
c.   Domain integrity
d.   User-defined integrity

35.  The UPDATE command is used to insert records into tables:

a.   True
b.   False

36.  The DROP command is used to either drop a database or table from the server:
a.   True
b.   False

37.  In order to create a table named “Orders” with a primary key named “orderID”, use the
following MS SQL syntax (assuming there are several more fields):
a.   CREATE TABLE orders (PRIMARY KEY = orderID INT NOT NULL PRIMARY
KEY,)
b.   CREATE TABLE NAME = orders (PRIMARY KEY = orderID)
c.   CREATE TABLE orders (orderID INT NOT NULL PRIMARY KEY,)
d.   CREATE TABLE NAME = orders (orderID INT NULL PRIMARY KEY,)

38.  What does the SQL code in the following SQL clause define?
PRIMARY KEY (Name, Address)
a.   A composite key
b.   A primary key
c.   A foreign key
d.   None of the above

39.  RDBMS is the basis for SQL, and for all modern database systems except:
a.   MariaDB
b.   MySQL
c.   SQLite
d.   MongoDB
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
Page 8 of 9  

40.  Which of the following is an example of a DML command?

a.   GRANT
b.   CREATE
c.   DROP
d.   INSERT

41.  A stored program that is attached to a table or view is called a ______:

a.   Trigger
b.   Function
c.   Stored Procedure
d.   View

42.  Which of the following is not removed by the DROP TABLE in SQL Server?
a.   Triggers
b.   Permissions
c.   Views
d.   Stored Procedures

43.  Which of the following is inconsistent with Domain information?

a.   Bitwise constraints
b.   Length
c.   Data type
d.   Default value if any

44.  Aggregate functions can be used as expressions in the select list of a SELECT statement:
a.   True
b.   False

45.  What are the two common wildcard characters within SQL?
a.   Period (.); Semi-Colon (;)
b.   Semi-Colon (;); Percent Sign (%)
c.   Period (.); Underscore (_)
d.   Percent Sign (%); Underscore (_)

46.  SQL query and modification commands make up a(n) ______:

a.   DML
b.   XML
c.   HTML
d.   DQL
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
Page 9 of 9  

47.  The language available in SQL Server that adds programming constructs to the SQL
language is known as ______:
a.   INTERACT-SQL
b.   VB
c.   TRANSACT-SQL
d.   C#

48.  In MS SQL the parameter added to a field in order to auto increment that field is:
a.   ADD 1
b.   IDENTITY
c.   INCREMENT 1
d.   None of the above is a correct parameter

49.  The identifier of the entity becomes the ______ of the corresponding table:
a.   Foreign Key
b.   Primary Key
c.   Default Value
d.   None of the above

50.  A table's Permissions are a set of defined levels of access to a securable and are applied
individually or collectively to a securable:
a.   True
b.   False
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
ANSWER KEY
Page 1 of 2
 

 
SQL DATABASE
FUNDAMENTALS
(345)
REGIONAL – 2019

Multiple Choice:

Multiple Choice (50 @ 10 points each) ______________ (500 points)

TOTAL POINTS ______________ (500 points)

Graders: Please double check and verify all scores and

answer keys!

Property of Business Professionals of America.

May be reproduced only for use in the Business Professionals of America
Workplace Skills Assessment Program competition.
SQL DATABASE FUNDAMENTALS - REGIONAL 2019
ANSWER KEY
Page 2 of 2

1.   C 26.  D
2.   A 27.  A
3.   A 28.  B
4.   D 29.  D
5.   B 30.  B
6.   B 31.  C
7.   D 32.  A
8.   A 33.  D
9.   A 34.  A
10.  C 35.  B
11.  B 36.  A
12.  A 37.  C
13.  D 38.  A
14.  D 39.  D
15.  C 40.  D
16.  B 41.  C
17.  A 42.  B
18.  A 43.  A
19.  D 44.  A
20.  C 45.  D
21.  B 46.  A
22.  A 47.  C
23.  A 48.  B
24.  D 49.  B
25.  A 50.  A