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

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

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A.It must be the name of the server running the database to whose instance HR wishes to connect
• B.It must resolve to a valid connect descriptor in the client's tnsnames.ora file
• C.It must be the name of the database to whose instance HR wishes to connect
• D.It must be the value of the SERVICE_NAMES parameter on the client side
• E.It must resolve to a valid connect descriptor in the server's tnsnames.ora file

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about undo and undo tablespaces?

• A.An instance will crash if the active undo tablespace is lost.
• B.An undo tablespace may be owned by only one instance.
• C.undo segments are owned by SYSBACKUP.
• D.undo segments are owned by SYSTEM.
• E.There can be only one undo tablespace created in a database.

Comment: *

Name: *

Email: *

Verification: *

You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.
The variables used in your query are never undefined in your session.
Which query can be used?
SELECT &&col1, &&col2

• A.FROM &&table
  WHERE &condition;
  SELECT &col1, &col2
• B.FROM &table
  WHERE '&&condition' = '&cond';
  SELECT &&col1, &&col2
• C.FROM &table
  WHERE &&condition;
• D.FROM "&table"
  WHERE &condition;
  SELECT '&&col1', '&&col2'
• E.FROM &table
  WHERE &&condition = &&cond;
  SELECT &col1, &col2

Comment: *

Name: *

Email: *

Verification: *

In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?

• A.T1, an index segment for the primary key, a LOB segment, and a lobindex segment
• B.no segments are created
• C.T1 only
• D.T1 and an index segment created for the primary key only
• E.T1, an index segment for the primary key, and a LOB segment only

Comment: *

Name: *

Email: *

Verification: *