We're so confident of our products that we provide no hassle product exchange.
Oracle database 10g:new features for Oracle8i ocps Sample Questions:
1. Which two statements are true regarding the use of UTF-16 encoding? (Choose two.)
A) Asian characters are represented in three characters
B) European characters are represented in one or two bytes
C) uses a variable-widthmultibyte encoding sequence
D) uses a fixed-widthmultibyte encoding sequence
E) enables easier loading of multinational data
2. You decide to define the Flash Recovery Area manually. What are the two mandatory initialization parameters you need to set? (Choose two.)
A) DB_FLASHBACK_RETENTION_TARGET
B) LOG_ARCHIVE_DEST_10
C) RECOVERY_PARALLELISM
D) DB_RECOVERY_FILE_DEST_SIZE
E) DB_CREATE_FILE_DEST
F) DB_RECOVERY_FILE_DEST
3. You flashed back the jobs table at 11:00 a.m. to its state at 9:30 a.m.
At 11:15 a.m., you decided to retrieve the jobs table as it was at 10:12 a.m.
What would you do to retrieve the jobs table fast and with minimum impact to other objects?
A) use the ROLLBACK command with SCN
B) use the FLASHBACK TABLE command
C) drop and re-create the table
D) perform point-in-time recovery
E) use the FLASHBACK DATABASE command
4. In an online transaction processing (OLTP) environment, you find that the transaction tables get heavily fragmented during the week. You decide to defragment the transaction tables on every Friday at 9:30 p.m. to gain performance. Which two new features of the Oracle 10g database could you use to automate this task? (Choose two.)
A) Enterprise Manager job scheduling
B) the DBMS_SCHEDULER package
C) the DBMS_IJOB package
D) the DBMS_AQ package
E) the OS level job automation tool
5. You created a locally managed tablespace by using the following SQL statement:
CREATE TABLESPACE hr_tbs DATAFILE 'data.dat' SIZE 1M REUSE AUTOEXTEND ON MAXSIZE 100M;
The warning and critical tablespace usage threshold values are set to 85% and 97%, respectively. Which two statements regarding the threshold-based alerts generation for the HR_TBS tablespace are correct? (Choose two.)
A) No warning alert will be generated because thetablespace is autoextensible.
B) A warning alert will be generated when 85 MB space is used.
C) A critical alert will be generated when 970 KB is left as free space.
D) A warning alert will be generated when 850 KB is left as free space.
E) A warning alert will be generated when 850 KB space is used.
F) A critical alert will be generated when 97 MB space is used.
G) No critical alert will be generated because it is a small filetablespace.
H) A critical alert will be generated when 970 KB space is used.
Solutions:
| Question # 1 Answer: D,E | Question # 2 Answer: D,F | Question # 3 Answer: B | Question # 4 Answer: A,B | Question # 5 Answer: B,F |
By Emily
