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 both the databases
• C.as SYS in both the databases
• D.as SCOTT in BOSTON_DB
• E.as SCOTT in BOSTON_DB and SYS in DALLAS_DB

Comment: *

Name: *

Email: *

Verification: *

Which two are true about shrinking a segment online? (Choose two.)

• A.It is not possible to shrink either indexes or Index Organized Tables (IOTs)
• B.It always eliminates all migrated rows if any exist in the table
• C.To shrink a table it must have a PRIMARY KEY constraint
• D.To shrink a table it must have a UNIQUE KEY constraint
• E.To shrink a table it must have row movement enabled
• F.It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

• A.A connection string including a service name must be defined in the cnsnames.ora file.
• B.A connection string must include the SID of a database Instance.
• C.A service name is created by a listener.
• D.A single connection string can refer to multiple database instances.
• E.Different connection strings in the same tnsnames.ora file can contain the same service name, host and port parameters.
• F.A single database instance can support connections for multiple service names.

Comment: *

Name: *

Email: *

Verification: *

Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

• A.The service DB01.abc.com is dynamically registered
• B.The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1
• C.The listener is not listening on the default port 1521
• D.The service DB01.abc.com is statically registered
• E.The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about the results of using the INTERSECT operator in compound queries? (Choose two.)

• A.Reversing the order of the intersected tables can sometimes affect the output
• B.The number of columns in each SELECT in the compound query can be different
• C.INTERSECT ignores NULLs
• D.Column names in each SELECT in the compound query can be different
• E.INTERSECT returns rows common to both sides of the compound query

Comment: *

Name: *

Email: *

Verification: *