Autonomous Database Exam | Verified Questions and
Answers | Updated Practice Test 2025/2026 - JUST
RELEASED, 100 % Verified
It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement
Ans: True
Quiz The SERVICE_CATEGORY table in the StayWell database includes the service fees.
Ans: True
Quiz An example of a relationship between categories in the KimTay database is the relationship
between sales reps and customers
Ans: True
Quiz You can determine functional dependence by viewing sample data
,Ans: True
Quiz If column A in a relational database determines a single value for column B at any point in time,
then column B is functionally dependent on column A.
Ans: True
Quiz To list all the columns in a table and their properties in MySQL, use the LIST COLUMNS command
Ans: False
Quiz All SELECT statements require a WHERE clause
Ans: False
Quiz It is possible to place one query inside another
Ans: True
Quiz When adding rows to character columns, make sure you enclose the values in single quotation
marks.
Ans: True
,Quiz The statement "A sales rep's pay class functionally determines his or her pay rate" means that if
you know the pay class, you can determine the pay rate.
Ans: True
Quiz Which statement about changing the default database is FALSE?
A. The MySQL command USE SPIDERS; makes SPIDERS the default database.
B. To activate a database, you execute the USE command followed by the database's name.
C. There are two steps to choosing a database to use: changing the default and activation.
D. Tables created in MySQL are added to the default database.
Ans: C. There are two steps to choosing a database to use: changing the default and activation.
Quiz Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the
quoted price, and ___
A. the customer ID
B. The wholesale price
C. and item description
D. an office location
Ans: C. An item description
Quiz Which statement about the command used to view all columns and rows in a database table is
correct?
A. The command used in SQL Server is different form that used in MySQL and Oracle.
B. When using Oracle, the semicolon in the MySQLm, command must be replaced with a slash.
, C. The same simple version of this command can be used in MySQL, Oracle, and SQL Server.
D. The command contains two symbols: a colon and a question mark.
Ans: C. The same simple version of this command can be used in MySQL, Oracle, and SQL Server.
Quiz The process of determining the particular tables and columns that will comprise a database is
known as ___
A. relational management
B. qualification
C. database design
D. normalization
Ans: C. database design
Quiz When you need to sort data on two columns, the less important column is call the ___.
A. minor sort key
B. foreign sort key
C. double sort key
D. primary sort key
Ans: A. minor sort key
Quiz Bradford would like to write a query that returns the average unit sales over the last 30 days for
each of his bakery's product types: cupcakes, muffins, and cookies. There are several flavors of each in
the table, but the product types are identified in a CATEGORY column as "Cupcake," "Muffin," or
"Cookie." What should the last part of his query be, following the part shown below?
SELECT CATEGORY, AVG(UNIT_SALES) FROM PRODUCTS
Answers | Updated Practice Test 2025/2026 - JUST
RELEASED, 100 % Verified
It is possible to use both a WHERE clause and a HAVING clause in a SELECT statement
Ans: True
Quiz The SERVICE_CATEGORY table in the StayWell database includes the service fees.
Ans: True
Quiz An example of a relationship between categories in the KimTay database is the relationship
between sales reps and customers
Ans: True
Quiz You can determine functional dependence by viewing sample data
,Ans: True
Quiz If column A in a relational database determines a single value for column B at any point in time,
then column B is functionally dependent on column A.
Ans: True
Quiz To list all the columns in a table and their properties in MySQL, use the LIST COLUMNS command
Ans: False
Quiz All SELECT statements require a WHERE clause
Ans: False
Quiz It is possible to place one query inside another
Ans: True
Quiz When adding rows to character columns, make sure you enclose the values in single quotation
marks.
Ans: True
,Quiz The statement "A sales rep's pay class functionally determines his or her pay rate" means that if
you know the pay class, you can determine the pay rate.
Ans: True
Quiz Which statement about changing the default database is FALSE?
A. The MySQL command USE SPIDERS; makes SPIDERS the default database.
B. To activate a database, you execute the USE command followed by the database's name.
C. There are two steps to choosing a database to use: changing the default and activation.
D. Tables created in MySQL are added to the default database.
Ans: C. There are two steps to choosing a database to use: changing the default and activation.
Quiz Each line in a KimTay invoice contains an item ID, the number of units of the item ordered, the
quoted price, and ___
A. the customer ID
B. The wholesale price
C. and item description
D. an office location
Ans: C. An item description
Quiz Which statement about the command used to view all columns and rows in a database table is
correct?
A. The command used in SQL Server is different form that used in MySQL and Oracle.
B. When using Oracle, the semicolon in the MySQLm, command must be replaced with a slash.
, C. The same simple version of this command can be used in MySQL, Oracle, and SQL Server.
D. The command contains two symbols: a colon and a question mark.
Ans: C. The same simple version of this command can be used in MySQL, Oracle, and SQL Server.
Quiz The process of determining the particular tables and columns that will comprise a database is
known as ___
A. relational management
B. qualification
C. database design
D. normalization
Ans: C. database design
Quiz When you need to sort data on two columns, the less important column is call the ___.
A. minor sort key
B. foreign sort key
C. double sort key
D. primary sort key
Ans: A. minor sort key
Quiz Bradford would like to write a query that returns the average unit sales over the last 30 days for
each of his bakery's product types: cupcakes, muffins, and cookies. There are several flavors of each in
the table, but the product types are identified in a CATEGORY column as "Cupcake," "Muffin," or
"Cookie." What should the last part of his query be, following the part shown below?
SELECT CATEGORY, AVG(UNIT_SALES) FROM PRODUCTS
