READ Free Dumps For Oracle- 1z0-023
| Question ID 8755 | You are creating a database with a character set other than US7ACII. Which operating system environmental variable needs to be set to specify the directory location of the NLS support files?
|
| Option A | NLS_LANG
|
| Option B | ORA_NLS33
|
| Option C | ORACLE_SID
|
| Option D | ORACLE_BASE
|
| Option E | ORACLE_HOME
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. Parameter ORA_NLS33 specifies the directory location of the NLS support files. Incorrect Answers: A: NLS_LANG system variable indicates the language for error messages, the names of days and months, the symbol for 12-hour time of day and calendar ara; this parameter also defines the sort mechanism Oracle will use. C: ORACLE_SID parameter specifies unique database name, not NLS support files directory location. D: ORACLE_BASE parameter identifies base directory where all versions of Oracle software have been installed. E: ORACLE_HOME parameter identifies directory name where current version of Oracle software have been installed. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 545-547 Chapter 11: Data Loads and National Language Support
| Question ID 8758 | Given the statement: CREATE DATABASE orc1 LOGFILE GROUP 1 'u01/oracle/dba/logla.rdo' SIZE 1M, GROUP 2 'u01/oracle/dba/ log2a.rdo' SIZE 1M DARAFILE'u01/oracle/dbs/sys_01.dbf'REUSE; Which statement is true?
|
| Option A | The online redo logs will be multiplexed.
|
| Option B | The file 'u01/oracle/dbs/sys_01.dbf' already exists
|
| Option C | File 'u01/oracle/dbs/sys_01.dbf' as a parameter file
|
| Option D | The control file name is 'u01/oracle/dbs/sys_01.dbf'.
|
| Option E | Oracle will determine the optimum size for 'u01/oracle/dba/sys_01.dbf'.
|
| Correct Answer | B |
Explanation Explanation/Reference: Explanation: Answer B is correct. Because of using keyword REUSE the file 'u01/oracle/dbs/sys_01.dbf' have already to be created. Incorrect Answers: A: This statement shows that there is one member of each group of a log files, it means there is no multiplexing for online redo logs. C: File 'u01/oracle/dbs/sys_01.dbf' is data file, not a parameter file. D: File 'u01/oracle/dbs/sys_01.dbf' is data file, not a control file. E: Oracle will not determine the optimum size for 'u01/oracle/dba/sys_01.dbf', because it will reuse existing file without changing its size. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 293-296 Chapter 6: Basics of the Oracle Database Architecture