Question 1: Which SQL JOIN type returns all rows from the left table and the matching rows from the right table, filling in with NULLs for non-matching rows?
a) INNER JOIN
b) LEFT JOIN
c) RIGHT JOIN
d) FULL JOIN
b) LEFT JOIN
a) Scalar subquery
b) Correlated subquery
c) Nested subquery
d) Derived subquery
a) Scalar subquery
a) FILTER BY
b) HAVING
c) WHERE
d) LIMIT
b) HAVING
a) To combine multiple tables
b) To convert data types
c) To filter rows based on a condition
d) To return the first non-null value from a list
d) To return the first non-null value from a list
a) ALTER COLUMN
b) ADD COLUMN
c) INSERT COLUMN
d) NEW COLUMN
b) ADD COLUMN
a) TOTAL
b) SUM
c) CUMSUM
d) SUM() OVER()
d) SUM() OVER()
a) To perform mathematical calculations on columns
b) To combine multiple tables
c) To control the flow of the query based on conditions
d) To filter rows based on a condition
c) To control the flow of the query based on conditions
a) DUPLICATE
b) CREATE COPY
c) CLONE
d) CREATE AS
d) CREATE AS
a) DELETE
b) ERASE
c) REMOVE
d) DELETE DUPLICATES
a) DELETE
a) Clustered index
b) Bitmap index
c) B-tree index
d) Non-clustered index
c) B-tree index
a) To combine multiple tables into a single result set
b) To insert new rows into a table
c) To update or insert data based on a condition
d) To delete rows from a table
c) To update or insert data based on a condition
a) FETCH
b) LIMIT
c) OFFSET
d) ROWS
b) LIMIT
a) CROSS JOIN
b) NATURAL JOIN
c) FULL OUTER JOIN
d) SELF JOIN
c) FULL OUTER JOIN
a) To filter rows based on a condition
b) To order the result set
c) To perform calculations on window functions
d) To group rows based on a column's values
c) To perform calculations on window functions
a) Calculates the average of a column's values
b) Assigns a unique rank to each row in the result set
c) Retrieves the highest value from a column
d) Combines multiple columns into one
b) Assigns a unique rank to each row in the result set
a) PIVOT
b) UNPIVOT
c) TRANSPOSE
d) ROTATE
a) PIVOT
a) To join two tables based on a common column
b) To perform self-joins on a single table
c) To join a subquery with a table
d) To create a Cartesian product of two tables
c) To join a subquery with a table
a) To perform calculations on window functions
b) To generate a list of sequential numbers
c) To join two or more tables
d) To query hierarchical or nested data structures
d) To query hierarchical or nested data structures
a) Counts the total number of rows in a table
b) Returns the first row in a result set
c) Assigns a unique sequential integer to each row in the result set
d) Calculates the sum of values in a column
c) Assigns a unique sequential integer to each row in the result set
a) To count the number of occurrences of a value in a column
b) To retrieve the previous row's value in a column
c) To calculate the average of a column's values
d) To perform string concatenation on column values
b) To retrieve the previous row's value in a column
a) To join tables based on a common column
b) To join tables using arithmetic operations
c) To join tables based on their natural order
d) To perform self-joins on a single table
a) To join tables based on a common column
a) Aggregates data in XML format
b) Creates a new table by aggregating XML data
c) Parses XML data into relational format
d) Extracts data from XML attributes
a) Aggregates data in XML format
a) SET
b) UPDATE WHERE
c) MODIFY
d) WHERE
d) WHERE
a) It specifies the order of the subquery execution
b) It defines the alias for the subquery
c) It allows the subquery to reference columns from the outer query
d) It indicates the subquery to be executed after the main query
c) It allows the subquery to reference columns from the outer query
a) To delete all rows from a table
b) To remove a specific column from a table
c) To remove duplicate values from a table
d) To remove NULL values from a table
a) To delete all rows from a table
a) To calculate the average of values in a column
b) To generate all possible combinations of grouping sets
c) To filter rows based on conditions
d) To sort the result set
b) To generate all possible combinations of grouping sets
a) NOW()
b) CURRENT_DATE()
c) GETDATE()
d) DATE_TIME()
b) CURRENT_DATE()
a) It combines the result sets of two SELECT statements
b) It returns the common rows between two result sets
c) It returns the difference between two result sets
d) It joins two tables based on a common column
b) It returns the common rows between two result sets
a) To create a new table
b) To update data in a table
c) To insert data into a table
d) To provide privileges to users or roles
d) To provide privileges to users or roles
a) To calculate the sum of values in a column
b) To generate subtotals for multiple levels of grouping
c) To filter rows based on conditions
d) To sort the result set
b) To generate subtotals for multiple levels of grouping