SANS GFACT SQL Quiz Questions
AND ANSWERS 100% VERIFIED!
The data in non-relational databases is structured, just like relational databases. -
ANSWERSFalse - Non-relational databases are for use when the kind of data is not
known, and/or if the type of data changes frequently.
The 'WHERE' SQL command is used to filter data that meet certain criteria. -
ANSWERSTrue - The `WHERE` clause helps us to filter records to only the ones that
match a certain condition, i.e.the defined value within a database column
Operators UNION, IN, LIKE and SOME are examples of Comparison operators -
ANSWERSFalse - These are Logical operators
When you execute a query that contains a subquery, the subquery is evaluated at the
same time as the query - ANSWERSFalse - The subquery is evaluated first and then
the result of that query is used in the enclosing query
The `EXISTS` operator checks for the existence of records in a subquery before the
subquery is evaluated - ANSWERSFalse - The 'EXISTS' operator evaluates subqueries
after all the subqueiries are evaluated
The UNION operator is used to emulate a FULL JOIN, not supported by MySQL -
ANSWERSTrue
The CONSTRAINTS operator is used to define rules for a field in a table -
ANSWERSFalse - There is no CONSTRAINT operator, rather we use commands like
FOREIGN KEY, PRIMARY KEY or REFERENCES To retrieve rows that meet defined
conditions in 2 tables, use the INNER JOIN command - ANSWERSTrue - An INNER
JOIN is used for retrieving rows that meet a condition in both tables
a LEFT JOIN includes matching results from the first table and all results from the
second table - ANSWERSFalse - the RIGHT JOIN command includes matching results
from the first table and all results from the second table
To select all data from a table, use the wild card character '!', exclamation point -
ANSWERSFalse - The asterisks '*' is the wild card character
When using the AS command, the renaming of the field is permanent - ANSWERSFalse
- The renaming of a field using the AS command only exists fo the duration of the SQL
query.
AND ANSWERS 100% VERIFIED!
The data in non-relational databases is structured, just like relational databases. -
ANSWERSFalse - Non-relational databases are for use when the kind of data is not
known, and/or if the type of data changes frequently.
The 'WHERE' SQL command is used to filter data that meet certain criteria. -
ANSWERSTrue - The `WHERE` clause helps us to filter records to only the ones that
match a certain condition, i.e.the defined value within a database column
Operators UNION, IN, LIKE and SOME are examples of Comparison operators -
ANSWERSFalse - These are Logical operators
When you execute a query that contains a subquery, the subquery is evaluated at the
same time as the query - ANSWERSFalse - The subquery is evaluated first and then
the result of that query is used in the enclosing query
The `EXISTS` operator checks for the existence of records in a subquery before the
subquery is evaluated - ANSWERSFalse - The 'EXISTS' operator evaluates subqueries
after all the subqueiries are evaluated
The UNION operator is used to emulate a FULL JOIN, not supported by MySQL -
ANSWERSTrue
The CONSTRAINTS operator is used to define rules for a field in a table -
ANSWERSFalse - There is no CONSTRAINT operator, rather we use commands like
FOREIGN KEY, PRIMARY KEY or REFERENCES To retrieve rows that meet defined
conditions in 2 tables, use the INNER JOIN command - ANSWERSTrue - An INNER
JOIN is used for retrieving rows that meet a condition in both tables
a LEFT JOIN includes matching results from the first table and all results from the
second table - ANSWERSFalse - the RIGHT JOIN command includes matching results
from the first table and all results from the second table
To select all data from a table, use the wild card character '!', exclamation point -
ANSWERSFalse - The asterisks '*' is the wild card character
When using the AS command, the renaming of the field is permanent - ANSWERSFalse
- The renaming of a field using the AS command only exists fo the duration of the SQL
query.
