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?

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?

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?

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 PFILE is also available. 

You execute this command: 

ALTER SYSTEM SET DB_CACHE_SIZE=100K; 

Where is the value changed?

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?

（含图）

Which statement is true?

want to ensure the following: 

1.The user account must be locked after five unsuccessful login attempts. 

2.Data read per session must be limited for the user. 

3.The user cannot have more than three simultaneous sessions. 

4. The user must have a maximum of 10 minutes session idle time before being logged off 

automatically. 

How would you accomplish this? 

ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YYYY HH24:MI:SS' ;

ALTER SESSION SET TIME_ZONE = '-5:00' ; 

SELECT DBTIMEZONE, SYSDATE FROM DUAL; 

Examine the result: 

DBTIMEZONE SYSDATE

+00.00 11- JUL-2019 11:00:00 

If LOCALTIMESTAMP was selected at the same time, what would it return?

Examine this scenario: connect / as sysdba 

Connected. 

SHUTDOWN TRANSACTIONAL 

Database closed.

Database dismounted. 

ORACLE instance shut down. 

STARTUP 

Now examine these steps: 

1.Oracle instance is started. 

2.The control file is read. 

3.Instance recovery is started. 

4.Datafiles and redo log files are opened.

5.The spfile or pfile is read. 

6.The database is available for use. 

7.The database is mounted. 

8.Instance recovery is completed. 

Identify the correct steps and the order they will be executed in following this command:

Which statement is true?

restrictions: 

1. A connection must be terminated after four unsuccessful login attempts by user. 

2. A user should not be able to create more than four simultaneous sessions. 

3. User session must be terminated after 15 minutes of inactivity. 

4. Users must be prompted to change their passwords every 15 days. 

How would you accomplish these requirements? 

Which statement is true about the DEFAULT profile?

Which DBCA option must you choose to create the database?

Which statement is true?

ALTER SYSTEM SET LOG_BUFFER=32M; 

What is the outcome of this command?

How would you accomplish this?

One of the columns must meet three requirements: 

Be stored in a format supporting date arithmetic without using conversion functions 

Store a loan period of up to 10 years 

Be used for calculating interest for the number of days the loan remains unpaid 

Which data type should you use?