Free 1z0-082 Exam Braindumps

Which statement is true about aggregate functions?

1. A. Aggregate functions can be nested to any number of levels
2. B. The AVG function implicitly converts NULLS to zero
3. C. Aggregate functions can be used in any clause of a SELECT statement
4. D. The MAX and MIN functions can be used on columns with character data types

Correct Answer: A

Which two statements are true regarding a SAVEPOINT? (Choose two.)

1. A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
2. B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
3. C. Only one SAVEPOINT may be issued in a transaction
4. D. A SAVEPOINT does not issue a COMMIT
5. E. Rolling back to a SAVEPOINT can undo a DELETE statement

Correct Answer: DE

Examine this description of the TRANSACTIONS table:

Which two SQL statements execute successfully? (Choose two.)

1. A. SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS DATE, amount + 100 “DUES” FROM transactions;
2. B. SELECT customer_id AS “CUSTOMER-ID”, transaction_date AS “DATE”, amount + 100 DUES FROM transactions;
3. C. SELECT customer_id AS CUSTOMER-ID, transaction_date AS TRANS_DATE, amount + 100 “DUES AMOUNT” FROM transactions;
4. D. SELECT customer_id CUSTID, transaction_date TRANS_DATE, amount + 100 DUES FROM transactions;
5. E. SELECT customer_id AS ‘CUSTOMER-ID’, transaction_date AS DATE, amount + 100 ‘DUES AMOUNT’ FROM transactions;

Correct Answer: BD

Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)

1. A. two or more instances on separate servers all associated with one database
2. B. one instance on one server associated with one database
3. C. one instance on one server associated with two or more databases on the same server
4. D. one instance on one server not associated with any database
5. E. one instance on one server associated with two or more databases on separate servers

Correct Answer: CDE