2
SANS GFACT SQL Questions with accurate answers || || || || || ||
The data in non-relational databases is structured, just like relational databases. - ✔✔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. - ✔✔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 - ✔✔False - The
|| || || || || || || || || || || || || || || || || || ||
asterisks '*' is the wild card character || || || || || ||
When using the AS command, the renaming of the field is permanent - ✔✔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 - ✔✔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? - ✔✔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 -
|| || || || || || || || || || || || || || || ||
✔✔True - 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 -
|| || || || || || || || || || || || || || || || || ||
✔✔False - the RIGHT JOIN command includes matching results from the first table and all
|| || || || || || || || || || || || || || ||
results from the second table
|| || || ||
SANS GFACT SQL Questions with accurate answers || || || || || ||
The data in non-relational databases is structured, just like relational databases. - ✔✔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. - ✔✔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 - ✔✔False - The
|| || || || || || || || || || || || || || || || || || ||
asterisks '*' is the wild card character || || || || || ||
When using the AS command, the renaming of the field is permanent - ✔✔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 - ✔✔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? - ✔✔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 -
|| || || || || || || || || || || || || || || ||
✔✔True - 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 -
|| || || || || || || || || || || || || || || || || ||
✔✔False - the RIGHT JOIN command includes matching results from the first table and all
|| || || || || || || || || || || || || || ||
results from the second table
|| || || ||
