SANS GFACT SQL Quiz UPDATED
ACTUAL Exam Questions and CORRECT
Answers
The data in non-relational databases is structured, just like relational databases. - CORRECT
ANSWER - False - 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. - CORRECT
ANSWER - True - 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 select all data from a table, use the wild card character '!', exclamation point - CORRECT
ANSWER - False - The asterisks '*' is the wild card character
When using the AS command, the renaming of the field is permanent - CORRECT
ANSWER - False - The renaming of a field using the AS command only exists fo the
duration of the SQL query.
When using the SELECT command, data is returned in alphabetical order - CORRECT
ANSWER - False - Use the ORDER BY command along with the SELECT command to
order the data returned
To combine results from two or more table queries, you would use the JOIN clause? -
CORRECT ANSWER - True - The JOIN command, INNER, LEFT and RIGHT, are used
to combine output from queries to different database tables
To retrieve rows that meet defined conditions in 2 tables, use the INNER JOIN command -
CORRECT ANSWER - True - An INNER JOIN is used for retrieving rows that meet a
condition in both tables
ACTUAL Exam Questions and CORRECT
Answers
The data in non-relational databases is structured, just like relational databases. - CORRECT
ANSWER - False - 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. - CORRECT
ANSWER - True - 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 select all data from a table, use the wild card character '!', exclamation point - CORRECT
ANSWER - False - The asterisks '*' is the wild card character
When using the AS command, the renaming of the field is permanent - CORRECT
ANSWER - False - The renaming of a field using the AS command only exists fo the
duration of the SQL query.
When using the SELECT command, data is returned in alphabetical order - CORRECT
ANSWER - False - Use the ORDER BY command along with the SELECT command to
order the data returned
To combine results from two or more table queries, you would use the JOIN clause? -
CORRECT ANSWER - True - The JOIN command, INNER, LEFT and RIGHT, are used
to combine output from queries to different database tables
To retrieve rows that meet defined conditions in 2 tables, use the INNER JOIN command -
CORRECT ANSWER - True - An INNER JOIN is used for retrieving rows that meet a
condition in both tables
