DBMS || Answered Perfectly 100%.
Margaret creates a transaction within a transaction. Her first (outermost) transaction rolls back
data and the second (innermost) transaction commits data. What will be the outcome? correct
answers Both transactions are rolled back.
What is acid properties of dbms transaction? correct answers atomicity, consistency, isolation,
and durability
Aggregate functions correct answers avg, min, max, sum, count
To combine multiple retrievals, we write several SELECT statements and put the keyword
between them. What is the keyword? correct answers UNION
All changes made in a transaction are ____ once it commits correct answers visible
which clause is used to sort a union result as a whole correct answers ORDER BY
If you SELECT attributes and use an aggregate function, you must GROUP BY the non-
aggregate attributes. True/False? correct answers TRUE
Aggregate functions can be used in the select list or the_______clause of a select statement or
subquery. They cannot be used in a __ clause correct answers HAVING, WHERE
Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword
is used for this? correct answers LIMIT
The sequence of the columns in a GROUP BY clause has no effect in the ordering of the output.
True/False? correct answers False
, The column names in the result of a UNION (of tables) are always equal to the column names in
the 1st SELECT statement with the UNION operator. correct answers True
The entire transaction takes place at once or doesn't happen at all correct answers Atomicity
property
The database must be consistent before and after the transaction correct answers consistency
property
Multiple transactions occur independently without interference correct answers isolation
property
The changes of a successful transaction occurs even if the system failure occurs correct answers
durability property
_ marks the end of a successful implicit or explicit transaction. correct answers COMMIT
WORK
What is the significance of the statement "HAVING COUNT (emp_id)>2" in the given query?
correct answers Filter out all rows whose total emp_id below 2 & Selecting those rows whose
total emp_id > 2
"COUNT" keyword belongs to which categories in Mysql? correct answers Aggregate functions
You need to find the salaries for all the employees who have a higher salary than the Vice
President of a company 'ABC'.Which of the following queries will give you the required result?
correct answers SELECT first_name, last_name, salary
FROM employees
WHERE salary > (SELECT salary
FROM employees
Margaret creates a transaction within a transaction. Her first (outermost) transaction rolls back
data and the second (innermost) transaction commits data. What will be the outcome? correct
answers Both transactions are rolled back.
What is acid properties of dbms transaction? correct answers atomicity, consistency, isolation,
and durability
Aggregate functions correct answers avg, min, max, sum, count
To combine multiple retrievals, we write several SELECT statements and put the keyword
between them. What is the keyword? correct answers UNION
All changes made in a transaction are ____ once it commits correct answers visible
which clause is used to sort a union result as a whole correct answers ORDER BY
If you SELECT attributes and use an aggregate function, you must GROUP BY the non-
aggregate attributes. True/False? correct answers TRUE
Aggregate functions can be used in the select list or the_______clause of a select statement or
subquery. They cannot be used in a __ clause correct answers HAVING, WHERE
Suppose it is desired that UNION operation should return not more than 3 rows. Which keyword
is used for this? correct answers LIMIT
The sequence of the columns in a GROUP BY clause has no effect in the ordering of the output.
True/False? correct answers False
, The column names in the result of a UNION (of tables) are always equal to the column names in
the 1st SELECT statement with the UNION operator. correct answers True
The entire transaction takes place at once or doesn't happen at all correct answers Atomicity
property
The database must be consistent before and after the transaction correct answers consistency
property
Multiple transactions occur independently without interference correct answers isolation
property
The changes of a successful transaction occurs even if the system failure occurs correct answers
durability property
_ marks the end of a successful implicit or explicit transaction. correct answers COMMIT
WORK
What is the significance of the statement "HAVING COUNT (emp_id)>2" in the given query?
correct answers Filter out all rows whose total emp_id below 2 & Selecting those rows whose
total emp_id > 2
"COUNT" keyword belongs to which categories in Mysql? correct answers Aggregate functions
You need to find the salaries for all the employees who have a higher salary than the Vice
President of a company 'ABC'.Which of the following queries will give you the required result?
correct answers SELECT first_name, last_name, salary
FROM employees
WHERE salary > (SELECT salary
FROM employees
