Oracle Database SQL - 1z1-071 Exam Practice Test

A. Andrew will be able to see the changes you habe made

B. Andrew will be able to modify any rows in the table that have not been modified by your transaction

C. Andrew will be unable to see the changes you have made

D. Andrew will be unable to perform any INSERT, UPDATE of DELETE on the teble

E. Andrew will be able to SELECT from the table, but be unable to modify any existing rows.

A. SELECT dept_id, join_date, SUM(salary) FROM employees GROUP BY dept_id;

B. SELECT dept_id, MAX (AVG(salary)) FROM employees GROUP BY dept_id;

C. SELECT dept_id, join date, SUM(salary) FROM employees GROUP BY dept_id,join_date;

D. SELECT dept_id, AVG(NAX(salary)) FROM employees GROUP BY dept_id;

A. They can be used in the clause.

B. A SQL statement may have multiple single row subquery blocks.

C. They must be placed on the left side of the comparison operator or condition.

D. They can be used in the HAVING clause.

E. They must be placed on the right side of the comparison operator or condition.

F. They must return a row to prevent errors in the SQL statement.

A. Store the query in a script and pass the substitution value to the script when executing it.

B. Use the UNDEFINE command before executing the query.

C. Execute the SET VERIFY OFF command before executing the query.

D. Use the DEFINE command before executing the query

E. Replace 's1' with &1'in the query:

F. Execute the SET VERIFY ON command before executing the query.

A. SELECT customer_id CUSTID, transaction_date TRANS_DATE,amount+100 DUES FROM transactions;

B. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS "DATE", amount+100 DUES FROM transactions;

C. SELECT customer_id AS 'CUSTOMER-ID',transaction_date AS DATE, amount+100 'DUES' from transactions;

D. SELECT customer_id AS "CUSTOMER-ID", transaction_date AS DATE, amount+100 "DUES" from transactions;

E. SELECT customer id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount+100 "DUES AMOUNT" FROM transactions;

A. SELECT DISTINCT promo_cost ||'in'IIDISTINCT promo_category promotions ORDER BY1:

B. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

C. SELECT promo_category, DISTINCT promo_cost FROM promotiong ORDER BY 2:

D. select DISTINCT promo_categoryIl 'has'||promol_cost as COSTS FROM promotions ORDER BY 1:

E. SELECT promo_cost, promo_category FROM promotions ORDER BY 1

A. ALTER

B. REFERENCES

C. INSERT

D. INDEX

E. UPDATE

F. SELECT

G. DELETE

A. The delete command will wait for HR's transaction to end then return an error.

B. The DELETE command will wait for HR's transaction to end then delete the row.

C. The DELETE command will immediately delete the row.

D. The delete command will immediately return an error.

A. ROUND(MOD(25,3),-1) IS INVALID

B. TRUNC(MOD(25,3),-1) IS INVALID.

C. ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE DIFFERENT RESULTS.

D. ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE SAME RESULT.

A. select last _ name, (monthly_ salary * 12) + (monthly_ salary * 12 *monthly_ commission_ pct) AS annual_ camp FROM employees

B. SELECT last _ NAME (monthly_ salary + monthly _commission _ pct) * 12 AS annual_ comp FROM employees;

C. SELECT last _ name, (monthly_ salary * 12) + (monthly_ salary * 12 * NVL (monthly_ commission _pct, 0)) AS annual _comp

D. SELECT last _ name, (monthly _ salary * 12) + (monthly_ commission _ pct * 12) AS FROM employees:

A. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.

B. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.

C. INTERVAL YEAR TO MONTH columns support yearly intervals.

D. INTERVAL DAY TO SECOND columns support fractions of seconds.

E. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

F. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.

A. All existing rows in the ORDERS table are updated.

B. The subquery is executed for every updated row in the ORDERS table.

C. The UPDATE statement executes successfully even if the subquery selects multiple rows.

D. The subquery is not a correlated subquery.

E. The subquery is executed before the UPDATE statement is executed.

A. Indexes can be created on them.

B. If the ON COMMIT clause is session-specific,the table is dropped when the session is terminated.

C. They can be created only by a user with the DBA role,but can be accessed by all users who can create a session.

D. If the ON COMMIT clause Is transaction-specific, all rows in the table are deleted alter each COMMIT or ROLLBACK.

E. Backup and recovery operations are available for these tables.

F. Their data is always stored in the default temporary tablespace of the user who created them.

A. SELECT MAX (salary)
FROM employees
GROUP BY department_id
HAVING MAX (salary) = MAX (MAX (salary));

B. SELECT MAX (salary)
FROM employees
GROUP BY department_id;

C. SELECT MAX (MAX (salary))
FROM employees
GROUP BY department_id;

D. SELECT department_id, MAX(salary)
FROM employees
GROUP BY department_id;

E. SELECT MAX (salary)
FROM employees;

A. ALTER TAELE products DROP COLUMN expiry_date;

B. ALTER TABLE products DROP UNUSED COLUMNS

C. CREATE INDEX price_idx on products (price);

D. TRUNCATE TABLE products;

E. ALTER TABLE products SET UNUSED(expiry_date);

F. DROP TABLE products