单选题 You want to use table compression suitable for OLTP that will: 

1. Compress rows for all DML statements on that table 

2. Minimize the overheads associated with compression 

Which compression option is best suited for this?

单选题 Choose the best answer. Which statement is true about database links?

单选题 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?

单选题 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?

单选题 Choose the best answer Examine these statements and results: 

SQL> SELECT COUNT(*) FROM emp; 

COUNT (*)

14 

SQL> CREATE GLOBAL TEMPORARY TABLE t_emp AS SELECT * FROM

emp; 

Table created. 

SQL> INSERT INTO t_emp SELECT * FROM emp; 

14 rows created.

 SQL> COMMIT;

 Commit complete. 

SQL> INSERT INTO t_emp SELECT * FROM emp; 

14 rows created. 

SQL> SELECT COUNT(*) FROM t_emp; 

How many rows are retrieved by the last query?

单选题 Choose the best answer. Examine these commands: 

CONNECT / AS SYSDBA 

CREATE DIRECTORY dumpdir AS ‘/u01/app’; 

Directory created.

GRANT READ,WRITE ON DIRECTORY dumpdir TO PUBLIC;

 Grant succeeded. 

Create USER TEST IDENTIFIED BY test; 

User created. 

GRANT CREATE SESSION,RESOURCE,UNLIMITED TABLESPACE TO test; 

Grant succeeded. 

CONN test/test.

Connected. 

CREATE TABLE test_employees (id NUMBER(3), name VARCHAR2(20), salary NUMBER (7)); 

Table created. 

SQL> CREATE SYNONYM emp FOR test_employees; 

Synonym create. 

Now examine this command: $ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log TABLES=emp 

Which is true?

单选题 choose one Which statement is true about profiles?

单选题 In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:  

Which statement is true?