Contestant Number: ________________
SQL DATABASE FUNDAMENTALS - REGIONAL 2020 Time: _________
Page 1 of 10
Rank: _________
SQL DATABASE
FUNDAMENTALS
(345)
REGIONAL 2020
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 2020
Page 2 of 10
General Instructions
Your name and/or school name should not appear on any work you submit for grading. Write your
contestant number in the provided space. Staple all pages in order before you turn in your test.
Assumptions to make when taking this assessment:
Unless specified otherwise, questions are in the context of database systems of the Relational/SQL
type database family/genre
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
Page 3 of 10
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. Which SQL statement is used to retrieve data from a database?
a. Get
b. Pull
c. Select
d. Obtain
2. Which SQL statement is used to modify existing rows in a database table?
a. Update
b. Where
c. Amend
d. Insert
3. Which SQL statement is used to remove rows from a database table?
a. Remove
b. Cancel
c. Unpublish
d. Delete
4. Which SQL statement is used to add rows into a database table?
a. Put
b. Insert
c. Add
d. AddRow
5. The acronym DDL stands for
a. Database Dynamic Language
b. Data Definition Language
c. Data Dynamic Linear
d. Database Definition Linear
6. The acronym DML stands for
a. Database Manipulation Languages
b. Data Markup Language
c. Data Manipulation Language
d. Data Markup Linear
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
Page 4 of 10
7. RDMS stands for which of the following?
a. Relationship Data Manipulation System
b. Relationship Data Management Series
c. Relational Database Management System
d. Relational Database Manipulation Series
8. ETL stands for which of the following?
a. Extract, Transform, Load
b. Extract, Terraform, Load
c. Extract, Table, Load
d. Extract, Transform, Lag
9. Which range of values defines INT?
a. Integer data from 0 to 255
b. Integer data from -32,768 to 32,767
c. Integer data from -8,388,608 to 8,388,607
d. Integer data from -2,147,483,648 to 2,147,483,647
10. How do you retrieve all the rows and columns from a table named Cities?
a. GET * FROM Cities;
b. SELECT * FROM Cities;
c. PULL ALL FROM Cities;
d. OBTAIN ALL FROM Cities;
11. Which of the following SQL statements will return the FirstName and LastName columns
for all rows from a table called Customers?
a. GET FirstName and LastName FROM Customers;
b. PULL FirstName, LastName FROM Customers;
c. OBTAIN FirstName and LastName FROM Customers;
d. SELECT FirstName, LastName FROM Customers;
12. Which of the following is not true for a Primary Key?
a. It uniquely identifies each record in a database table
b. It can contain NULL values
c. A table may have a maximum of one primary key
d. It cannot contain NULL values
13. A ______ enforces that all of a column's values must match existing values from the column
it references.
a. Foreign Key Constraint
b. Check Constraint
c. Fact Constraint
d. Candidate Constraint
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
Page 5 of 10
14. Which of the following joins selects records with matching values in both tables?
a. Left Join
b. Right Join
c. Inner Join
d. Cross Join
15. Which of the following joins selects all records from the left table and the matched records
from the right table?
a. Left Join
b. Right Join
c. Cross Join
d. Inner Join
16. Which of the following SQL statements removes the table called Products?
a. DROP TABLE Products;
b. REMOVE TABLE Products;
c. DELETE TABLE Products;
d. DESC TABLE Products;
17. A _____ SQL statement is used to generate a SQL table?
a. Add Table
b. Put Table
c. Generate Table
d. Create Table
18. Which of the following is used to modify the structure of a table?
a. Alter Table
b. Update Table
c. Modify Table
d. Expand Table
19. A ______ is a data structure that organizes information into rows and columns.
a. Table
b. Foreign Key
c. Field
d. Attribute
20. A table column is also considered to be an attribute.
a. True
b. False
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
Page 6 of 10
21. The acronym CRUD stands for
a. Create, Remove, Update, and Delete
b. Create, Read, Update, and Delete
c. Create, Render, Update, and Delete
d. Construct, Read, Update, and Delete
22. The acronym CAP stands for
a. Concurrent, Atomicity, and Partition Tolerance
b. Concurrent, Availability, and Partition Tolerance
c. Consistency, Atomicity, and Partition Tolerance
d. Consistency, Availability, and Partition Tolerance
23. The acronym ACID stands for
a. Addition, Creation, Insertion, and Deletion
b. Atomicity, Consistency, Isolation, and Durability
c. Atomicity, Creation, Isolation, and Deletion
d. Addition, Consistency, Isolation, and Durability
24. Most major RDMS providers do not implement ACID principles?
a. True
b. False
25. Which of the following SQL statements is used to erase all data changes made from the start
of the current transaction?
a. Undo
b. Modify
c. Unpublish
d. Rollback
26. Which of the following SQL statements is used to end your current transaction and make
permanent changes performed in the transaction?
a. Publish
b. Commit
c. Save
d. Update
27. ______ requires concurrent transactions must leave the database in a status as if they were
executed sequentially.
a. Consistency
b. Atomicity
c. Partition Tolerance
d. Isolation
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
Page 7 of 10
28. ______ ensures each record in a table is uniquely identified.
a. Entity integrity
b. Referential integrity
c. Foreign key integrity
d. Database integrity
29. Which of the below SQL keywords is used to sort a result set in ascending or descending
order?
a. Sort By
b. Group By
c. Order By
d. Select By
30. Which of the below SQL statements will filter down to FirstName starting with B and
containing only 2 total characters?
a. WHERE FirstName LIKE 'B%'
b. WHERE FirstName LIKE 'B_'
c. WHERE FirstName LIKE 'B*'
d. WHERE FirstName LIKE 'B%%'
31. Which of the below SQL statements will filter to records with FruitName values containing
Orange, Apple, or Pineapple
a. WHERE EXISTS FruitName ('Orange', 'Apple', 'Pineapple')
b. WHERE FruitName CONTAINS ('Orange', 'Apple', 'Pineapple')
c. WHERE FruitName NOT IN ('Orange', 'Apple', 'Pineapple')
d. WHERE FruitName IN ('Orange', 'Apple', 'Pineapple')
32. In SQL Server, which SQL command is used to limit the number of records returned by a
query result set to a specified number of rows?
a. Top
b. Includes
c. Limit
d. Precludes
33. A ______ is a virtual table with contents based on the result-set of a SQL statement.
a. Table
b. Stored procedure
c. Function
d. View
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
Page 8 of 10
34. Which of the following SQL commands is used to add a SQL database?
a. ADD DATABASE
b. GENERATE DATABASE
c. APPEND DATABASE
d. CREATE DATABASE
35. Which of the following SQL statements is used to generate an index for a table?
a. APPEND INDEX
b. GENERATE INDEX
c. ADD INDEX
d. CREATE INDEX
36. ______ is an example of DDL?
a. CREATE
b. SELECT
c. INSERT
d. REVOKE
37. ______ is an example of DML?
a. CREATE
b. ALTER
c. UPDATE
d. GRANT
38. A ______ is often used to enforce entity integrity within a table.
a. Foreign key
b. Primary key
c. Check key
d. Type key
39. The acronym SQL stands for
a. Standard Query Loop
b. Structured Query Language
c. Striped Query Language
d. Structured Quantum Language
40. The acronym 3NF stands for
a. Three Normal Forms
b. Three Notable Forms
c. Third Normal Form
d. Third form of normalization
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
Page 9 of 10
41. ANSI stands for which of the following?
a. Alphanumeric National Standards Institute
b. Alphabetic and Numeric Standards Institute
c. American National Syntax Institution
d. American National Standards Institute
42. Which of the following is a set of programming extensions from Sybase and Microsoft that
adds features to the SQL available in SQL Server?
a. PL/SQL
b. Transact-SQL
c. C#
d. [Link]
43. Which of the following database systems is not a RDBMS?
a. Neo4j
b. Postgres
c. MariaDB
d. Oracle
44. Which SQL statement filters rows from a table named Cities to just rows whose CityName
starts with B?
a. WHERE CityName = 'B';
b. WHERE CityName LIKE 'B*';
c. WHERE CityName LIKE 'B%';
d. WHERE CityName IS LIKE 'B*';
45. The DELETE statement may be used in conjunction with the WHERE statement?
a. True
b. False
46. A Primary Key may contain only one column?
a. True
b. False
47. Which of the following SQL statements adds a Primary Key constraint for column ClientID
when used within a CREATE TABLE statement?
a. CONSTRAINT PK_Client PRIMARYKEY (ClientID)
b. CONSTRAINT PK_Client PRIMARY KEY (ClientID)
c. CONSTRAINT PK_Client CANDIDATEKEY (ClientID)
d. CHECK PK_Client PRIMARYKEY (ClientID)
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
Page 10 of 10
48. A ______ is a unique identifier not derived from application data and that has no business
meaning. For example, the first five values might be 1, 2, 3, 4, 5.
a. Surrogate key
b. Natural key
c. Select Key
d. Dimension Key
49. RANK is an example of a ______ function
a. Window
b. Trigger
c. User-defined
d. Procedure
50. Postgres, SQL Server, and MySQL each have a DATE datatype?
a. True
b. False
SQL DATABASE FUNDAMENTALS - REGIONAL 2020
ANSWER KEY
Page 1 of 2
SQL DATABASE
FUNDAMENTALS
(345)
REGIONAL 2020
Multiple Choice & Short Answer:
Multiple Choice (50 @ 10 points each) _______________ (500 points)
TOTAL POINTS _____________ (500 points)
Judge/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 2020
ANSWER KEY
Page 2 of 2
1. C 26. B
2. A 27. D
3. D 28. A
4. B 29. C
5. B 30. B
6. C 31. D
7. C 32. A
8. A 33. D
9. D 34. D
10. B 35. D
11. D 36. A
12. B 37. C
13. A 38. B
14. C 39. B
15. A 40. C
16. A 41. D
17. D 42. B
18. A 43. A
19. A 44. C
20. A 45. A
21. B 46. B
22. D 47. B
23. B 48. A
24. B 49. A
25. D 50. A