SANS GFACT SQL Quiz Questions Latest Update 2024-2025 Actual Exam Questions and 100% Verified Correct Answers Guaranteed A+
a LEFT JOIN includes matching results from the first table and all results from the
second table - CORRECT ANSWER: False - the RIGHT JOIN command includes
matching results from the first table and all results from the second table
Database fields do not have to have a defined datatype, like they do in programming -
CORRECT ANSWER: False - Each field must have a specified datatype. SQL is a
structured database, so each field has a static type.
Operators UNION, IN, LIKE and SOME are examples of Comparison operators -
CORRECT ANSWER: False - These are Logical operators
Scripting table creation must be done with a scripting language like Python - CORRECT
ANSWER: False - You can combine command into a single script to automate the
creation and insertion of tables.
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
The `default NULL` constraint means that if no value is entered into this field for a row then the value defaults to an empty field. - CORRECT ANSWER: False - The `default NULL` constraint means that if no value is entered into this field for a row then the value defaults to `NULL`.
The `EXISTS` operator checks for the existence of records in a subquery before the
subquery is evaluated - CORRECT ANSWER: False - The 'EXISTS' operator evaluates
subqueries after all the subqueiries are evaluated
The CONSTRAINTS operator is used to define rules for a field in a table - CORRECT
ANSWER: False - There is no CONSTRAINT operator, rather we use commands like
FOREIGN KEY, PRIMARY KEY or REFERENCES
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 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 - CORRECT ANSWER: True
- / 1