Which two are true about complete and incomplete recovery? (Choose two.)

• A.Uncommitted transactions will be rolled back after incomplete recovery completes.
• B.Uncommitted transactions will be rolled back after complete recovery completes.
• C.The database must have FLASHBACK enabled in order to perform incomplete recovery.
• D.Only incremental backups can be used to roll forward the database while performing complete recovery.
• E.Incomplete recovery is possible only when the database is open.

Comment: *

Name: *

Email: *

Verification: *

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

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about inner and outer joins? (Choose three.)

• A.A full outer join returns matched and unmatched rows
• B.An inner join returns matched rows
• C.Outer joins can only be used between two tables per query
• D.A full outer join must use Oracle syntax
• E.Outer joins can be used when there are multiple join conditions on two tables
• F.A left or right outer join returns only unmatched rows

Comment: *

Name: *

Email: *

Verification: *

Which two tasks can you perform using DBCA for databases? (Choose two.)

• A.Configure a nonstandard block size for a new database
• B.Register a new database with an available Enterprise Manager Management server
• C.Change the standard block size of an existing database
• D.Configure incremental backups for a new database
• E.Enable flashback database for an existing database

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the CUSTOMERS table:

You want to display details of all customers who reside in cities starting with the letter D followed by at least two characters.
Which query can be used?

• A.SELECT * FROM customers WHERE city = 'D_%';
• B.SELECT * FROM customers WHERE city LIKE 'D_%';
• C.SELECT * FROM customers WHERE city LIKE 'D_';
• D.SELECT * FROM customers WHERE city = '%D_';

Comment: *

Name: *

Email: *

Verification: *