Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

• A.Tablespace free space can be viewed in V$TABLESPACE
• B.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
• C.Tablespace free space can be viewed in DBA_TABLESPACES
• D.V$TABLESPACE displays information about tablespaces contained in the data dictionary
• E.V$TABLESPACE displays information that is contained in the controlfile about tablespaces

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

A user complains about poor database performance. You suspect that the user's session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user's session is currently waiting? (Choose two.)

• A.V$SYSTEM_EVENT
• B.V$SESSION
• C.V$SESSION_EVENT
• D.V$SESSION_WAIT_CLASS
• E.V$SESSION_WAIT

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 statements are true about Database Instances and Real Application Clusters (RAC)?

• A.A RAC database can have one Instance.
• B.A RAC database can have instances on separate servers.
• C.Two RAC databases can share their instances.
• D.A RAC database must have three or more Instances.
• E.A RAC database must have two or more instances.

Comment: *

Name: *

Email: *

Verification: *