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?

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

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: *

Which two statements are true about Database Instances and Real Application Clusters (RAC)?

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

Comment: *

Name: *

Email: *

Verification: *

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

• A.An inner join returns matched rows
• B.A left or right outer join returns only unmatched 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, you create a user, HR, and then execute this command:
GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A.Revoke the CREATE SESSION privilege from other users
• B.Revoke the CREATE SESSION privilege from user HR
• C.Log in to the database instance
• D.Grant the CREATE SESSION privilege with ADMIN OPTION to other users
• E.Execute DDL statements in the HR schema
• F.Execute DML statements in the HR schema

Comment: *

Name: *

Email: *

Verification: *