CCCCC Foundations (Pre-Assessment)
Questions Answer
Which requirement within large, complex databases ensures users have limited access
to the database?
A) Recovery
B) Performance
C) Authorization
D) Confidentiality - ANSWER-C) Authorization
Which design type specifies database requirements without regard to a specific
database system?
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design - ANSWER-B) Conceptual Design
What characterizes the rules of relational databases? - ANSWER-They are logical
constraints that ensure the data is valid.
Which event will result in an error code and error description when using MySQL
Server? - ANSWER-When an SQL statement is syntactically incorrect
Which data type should be used to store whole integer values, such as age? -
ANSWER-INT
Which text-based interface is included in the MySQL Server Download? - ANSWER-
MySQL Command-Line Client
True or False: MySQL includes the World database during its installation. - ANSWER-
True
What is the standardized language of relational database systems? - ANSWER-
Structured Query Language (SQL)
Which SQL sublanguage is used to manage database access? - ANSWER-Data
Control Language (DCL)
, Which SQL sublanguage is used to roll back database changes? - ANSWER-Data
Transaction Language (DTL)
Which format is used by the TIME data type in MySQL? - ANSWER-hh:mm:ss
Which MySQL operator is the last in the order of operator precedence?
A) -
B) OR
C) NOT
D) = - ANSWER-OR
Which operator is used to compare columns from the left and right tables in MySQL? -
ANSWER-=
Which type of join combines two tables without comparing columns? - ANSWER-
CROSS
Which type of join compares columns using only the = operator? - ANSWER-Equijoin
Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID - ANSWER-EQUIJOIN
What is another name for a subquery? - ANSWER-Nested Query
Which operator is used to compare against a list of values when determining a match in
a WHERE clause? - ANSWER-IN
Which wildcard character is used to represent zero or more characters when searching
for a specified pattern using a LIKE operator? - ANSWER-%
Which function is considered an aggregating function in SQL?
A) TRIM
B) REPLACE
C) MIN
D) SUBSTRING - ANSWER-C) MIN
Which clause or function is used with aggregate functions to produce summary rows? -
ANSWER-GROUP BY
Which type of join returns only the matching values when selecting rows from two or
more tables? - ANSWER-Inner Join
Questions Answer
Which requirement within large, complex databases ensures users have limited access
to the database?
A) Recovery
B) Performance
C) Authorization
D) Confidentiality - ANSWER-C) Authorization
Which design type specifies database requirements without regard to a specific
database system?
A) Physical design
B) Conceptual design
C) Logical design
D) Abstract design - ANSWER-B) Conceptual Design
What characterizes the rules of relational databases? - ANSWER-They are logical
constraints that ensure the data is valid.
Which event will result in an error code and error description when using MySQL
Server? - ANSWER-When an SQL statement is syntactically incorrect
Which data type should be used to store whole integer values, such as age? -
ANSWER-INT
Which text-based interface is included in the MySQL Server Download? - ANSWER-
MySQL Command-Line Client
True or False: MySQL includes the World database during its installation. - ANSWER-
True
What is the standardized language of relational database systems? - ANSWER-
Structured Query Language (SQL)
Which SQL sublanguage is used to manage database access? - ANSWER-Data
Control Language (DCL)
, Which SQL sublanguage is used to roll back database changes? - ANSWER-Data
Transaction Language (DTL)
Which format is used by the TIME data type in MySQL? - ANSWER-hh:mm:ss
Which MySQL operator is the last in the order of operator precedence?
A) -
B) OR
C) NOT
D) = - ANSWER-OR
Which operator is used to compare columns from the left and right tables in MySQL? -
ANSWER-=
Which type of join combines two tables without comparing columns? - ANSWER-
CROSS
Which type of join compares columns using only the = operator? - ANSWER-Equijoin
Which type of join is demonstrated by the following query?
SELECT Dog.Nickname, Kennel.Address
FROM Dog, Kennel
WHERE Dog.KennelID = Kennel.ID - ANSWER-EQUIJOIN
What is another name for a subquery? - ANSWER-Nested Query
Which operator is used to compare against a list of values when determining a match in
a WHERE clause? - ANSWER-IN
Which wildcard character is used to represent zero or more characters when searching
for a specified pattern using a LIKE operator? - ANSWER-%
Which function is considered an aggregating function in SQL?
A) TRIM
B) REPLACE
C) MIN
D) SUBSTRING - ANSWER-C) MIN
Which clause or function is used with aggregate functions to produce summary rows? -
ANSWER-GROUP BY
Which type of join returns only the matching values when selecting rows from two or
more tables? - ANSWER-Inner Join
