Which two statements are true about the SET VERIFY ON command? (Choose two.)

• A.It displays values for variables created by the DEFINE command
• B.It displays values for variables prefixed with &&
• C.It can be used only in SQL*Plus
• D.It displays values for variables used only in the WHERE clause of a query
• E.It can be used in SQL Developer and SQL*Plus

Comment: *

Name: *

Email: *

Verification: *

The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name.
Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING 'dallas_db'; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

• A.as SCOTT in DALLAS_DB
• B.as SCOTT in BOSTON_DB
• C.as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• D.as SYS in both the databases
• E.as SCOTT in both the databases

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

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

• A.The sales user must have a quota on the TEMP tablespace
• B.The sales user must have their quota on the users tablespace removed
• C.The sales user must have been granted the CREATE SESSION privilege
• D.The sales user must have been granted the CREATE TABLE privilege
• E.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• F.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

Comment: *

Name: *

Email: *

Verification: *

Which two functions are performed by a listener?

• A.verifying the service name in an incoming user request
• B.creating a user session in the System Global Area (SGA)
• C.verifying a user's authentication credentials
• D.connecting a user process to a server process
• E.returning the results of processing from the server process to the user process
• F.maintaining the connection to a client's user process until the user request is completed

Comment: *

Name: *

Email: *

Verification: *