Halian Oracle 10g
This is an Oracle test (incl RDBMS, PLSQL, Backup/ recover, Gridcontrol, Dataguard, ASM)
- 1.
To successfully complete the installation of Oracle 10g, which disk size do you need?
- A.
800 MB
- B.
1.2GB
- C.
1.5 GB
Correct Answer
C. 1.5 GB -
- 2.
Your database is in shared server mode, shared pool should not be used by RMAN, Which SGA component should have memory allocated?
- A.
Java pool
- B.
Log buffer
- C.
Large pool
Correct Answer
C. Large pool -
- 3.
Which of the following guarantees that committed data is savedeven if they are not yet recorded in the datafiles?
- A.
LGR and online redo log
- B.
DBW and archived log
- C.
DBW and database buffer cache
Correct Answer
A. LGR and online redo log -
- 4.
Many queries are reparsed and application response time is too slow, SGA buffer pool can not be increased, What will you choose?
- A.
Change parameter cursor_sharing from similar to exact
- B.
Change parameter cursor_sharing from exact to similar
- C.
Use the shared server mode
Correct Answer
B. Change parameter cursor_sharing from exact to similar -
- 5.
Recyclebin is configured and a user has dropped a table,What is true?
- A.
The segment is moved to SYSAUX tablespace
- B.
The segment is still available until the tablespace is full
- C.
The segment is still available until the next restart
Correct Answer
B. The segment is still available until the tablespace is full -
- 6.
The following parameters are set to: SGA_MAX_SIZE = 2GB SGA_TARGET = 1GB SHARED_POOL_SIZE = 120MB LARGE_POOL_SIZE = 110MB What is true?
- A.
SHARED_POOL_SIZE can grow up to have SGA=2GB
- B.
SHARED_POOL_SIZE can grow up to have SGA=1GB
- C.
SHARED_POOL and LARGE_POOL has the specified fixed size
Correct Answer
B. SHARED_POOL_SIZE can grow up to have SGA=1GB -
- 7.
What should be used to determine the appropriate buffer size in case of to many physical read?
- A.
Segment Advisor
- B.
ADDM
- C.
Memory Advisor
Correct Answer
C. Memory Advisor -
- 8.
About Flashback Database, what is true?
- A.
Flashback logs are archived
- B.
“Alter database flashback on” must be executed when the instance is mounted
- C.
Flashback logs can be manually deleted
Correct Answer
B. “Alter database flashback on” must be executed when the instance is mounted -
- 9.
The view FLASHBACK_TRANSACTION_QUERY retrieve information from?
- A.
UNDO_TABLESPACE
- B.
REDO_LOG
- C.
Flash recovery area
Correct Answer
A. UNDO_TABLESPACE -
- 10.
CONTROLE_FILE_RECORD_KEEP_TIME parameter is set to 15, What is true?
- A.
Backup will be maintained on media for 15 days
- B.
Backup will be maintained in recovery catalogue and control file for 15 days
- C.
Backup will be maintained in control file for 15 days
Correct Answer
C. Backup will be maintained in control file for 15 days -
- 11.
You want to use AUTOEXTEND ON features for some data, What is true?
- A.
You can set AUTOEXTEND at tablespace level
- B.
You can set AUTOEXTEND to a dedicated data file
- C.
You must set AUTOEXTEND to all data files of a tablespace
Correct Answer
B. You can set AUTOEXTEND to a dedicated data file -
- 12.
What is the result of the command “alter database backup control file to trace”?
- A.
Binary backup of the control file
- B.
Script to create the control file with the data files
- C.
Script to create the control file with the data files and temp files
Correct Answer
C. Script to create the control file with the data files and temp files -
- 13.
You need to reorganize online a table to get a partitioned table, What can you use?
- A.
Alter table statement
- B.
Dbms_redefinition package
- C.
It is no possible to do it online
Correct Answer
B. Dbms_redefinition package -
- 14.
About the statement “alter index IDX1 rebuild online”, What is true?
- A.
The result is the same as drop and create index
- B.
It is not possible to rebuild index online
- C.
It will be reorganized but the index will keep his depth
Correct Answer
C. It will be reorganized but the index will keep his depth -
- 15.
You need to kill one Oracle session by knowing only the Unix process number, where can you get the information to build your command?
- A.
V$session
- B.
V$process
- C.
V$session and v$process
Correct Answer
C. V$session and v$process -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 07, 2013Quiz Edited by
ProProfs Editorial Team -
Oct 21, 2009Quiz Created by
Halian
Back to top