1Z0-082 무료 덤프문제 온라인 액세스

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

• A.Change is applied to the current instance, but does not persist after instance restart
• B.The value is changed only in the PFILE and takes effect at the next instance startup
• C.It fails because the SCOPE clause is missing
• D.The value is changed for the current instance and in the PFILE

Which two statements are true about single row functions? (Choose two.)

• A.FLOOR : returns the smallest integer greater than or equal to a specified number
• B.MOD : returns the quotient of a division operation
• C.TRUNC : can be used with NUMBER and DATE values
• D.CEIL : can be used for positive and negative numbers
• E.CONCAT : can be used to combine any number of values

Examine the description of the customers table:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.
Examine this partial query:
SELECT cust_last_name, cust_credit_limit FROM customers
Which two where conditions give the required result?

• A.
• B.
• C.
• D.
• E.

Examine these SQL statements which execute successfully:

Which two statements are true after execution?

• A.The foreign key constraint will be enabled and deferred.
• B.The primary key constraint will be enabled and immediate.
• C.The foreign key constraint will be enabled and immediate.
• D.The foreign key constraint will be disabled.
• E.The primary key constraint will be enabled and deferred.

What is true about non-equijoin statement performance? (Choose two.)

• A.Table aliases can improve performance
• B.The join syntax used makes no difference to performance
• C.The BETWEEN condition always performs better than using the >= and <= conditions
• D.The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
• E.The BETWEEN condition always performs less well than using the >= and <= conditions