SANS GFACT SQL Quiz Questions
& Answers 100% Accurate!
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
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
The first table in a LEFT JOIN will always have all of its records returned in the query no
matter what the condition of the join is - ANSWERSTrue
The first table to be joined is mentioned in the INNER JOIN clause. - ANSWERSFalse -
The second table to be joined is mentioned in the INNER JOIN clause.
Operators UNION, IN, LIKE and SOME are examples of Comparison operators -
ANSWERSFalse - These are Logical operators To select all data from a table, use the
wild card character '!', exclamation point - ANSWERSFalse - The asterisks '*' is the wild
card character
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
Scripting table creation must be done with a scripting language like Python -
ANSWERSFalse - You can combine command into a single script to automate the
creation and insertion of tables.
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.
& Answers 100% Accurate!
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
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
The first table in a LEFT JOIN will always have all of its records returned in the query no
matter what the condition of the join is - ANSWERSTrue
The first table to be joined is mentioned in the INNER JOIN clause. - ANSWERSFalse -
The second table to be joined is mentioned in the INNER JOIN clause.
Operators UNION, IN, LIKE and SOME are examples of Comparison operators -
ANSWERSFalse - These are Logical operators To select all data from a table, use the
wild card character '!', exclamation point - ANSWERSFalse - The asterisks '*' is the wild
card character
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
Scripting table creation must be done with a scripting language like Python -
ANSWERSFalse - You can combine command into a single script to automate the
creation and insertion of tables.
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.
