Which three statements are true about a self join? (Choose three.)

• A.The ON clause must be used
• B.The query must use two different aliases for the table
• C.It must be an equijoin
• D.It must be an inner join
• E.The ON clause can be used
• F.It can be an outer join

Comment: *

Name: *

Email: *

Verification: *

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

• A.Incomplete recovery is possible only when the database is open.
• 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.Uncommitted transactions will be rolled back after incomplete recovery completes.

Comment: *

Name: *

Email: *

Verification: *

Which three activities are recorded in the database alert log? (Choose three.)

• A.Data Definition Language (DDL) statements
• B.non-default database parameters
• C.block corruption errors
• D.deadlock errors
• E.session logins and logouts

Comment: *

Name: *

Email: *

Verification: *

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017/3/6 14:45:17
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

• A.Set AUTOEXTEND ON for data files in DATA
• B.Set DEFERRED_SEGMENT_CREATION to TRUE
• C.Increase U1's quota sufficiently in DATA
• D.Drop other U1 objects in DATA
• E.Grant UNLIMITED TABLESPACE to U1
• F.Add a data file to DATA

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *