Your database instance is started with an SPFILE. A PFILE is also available. You execute this command: ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?
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: LISTENER_1 = (ADDRESS = (PROTOCOL = TCP)(HOST = host1.abc.com)(PORT = 1521)). Which statement is true?
Which two statements are true concerning logical and physical database structures?
Examine these commands: [oracle@host01 ~]$ sqlplus u1/oracle SQL> SELECT * FROM emp; ENO ENAME DN 1 Alan 2 2 Ben 2 SQL> exit [oracle@host01 ~]$ cat emp.dat 1, Alan, 2 3, Curl, 4 4, Bob, 4 [oracle@host01 ~]$ sqlldr u1/oracle TABLE=emp Which two statements are true?
Which three tasks are performed by background processes in an Oracle database instance?
Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?
