Halian Oracle Test
Settings
-
+
Welcome, This is an oracle 10g test
- 1.To successfully complete the installation of Oracle 10g, which disk size do you need?
- A.
800MB
- B.
1.2GB
- C.
1.5GB
- 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
- 3.Which of the following guarantees that committed data is saved even 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
- 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
- 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
- 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
- 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
- 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
- 9.The view FLASHBACK_TRANSACTION_QUERY retrieve information from?
- A.
UNDO_TABLESPACE
- B.
REDO_LOG
- C.
Flash recovery area
- 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
- 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
- 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
- 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
- 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
- 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
- 16.The Oracle instance crash, but the Unix shared memory is not cleared, How can you free the memory?
- A.
Using ipcs Unix command
- B.
Using ipcrm Unix command
- C.
It is not possible to do it with an oracle account, call the System Administrator.
- 17.The Automatic statistics collection feature enabled by default in 10G Will collect statistics base on,
- A.
each modify object
- B.
Stale data
- C.
At fixed time interval
- 18.You want to set the trace level on one listener, How can you proceed?
- A.
Connect to the listener and: set trace_level_listener=admin
- B.
Connect to the listener and: set trc_level admin
- C.
Restart the listener with the appropriate command option
- 19.You want to get trace files from a specific session, How can you proceed? using “sys.dbms_system.set_sql_trace_in_session…” using “set autotrace on” using “alter session trace on”
- A.
Using “sys.dbms_system.set_sql_trace_in_session…”
- B.
Using “set autotrace on”
- C.
Using “alter session trace on”
- 20.By using tkprof you can,
- A.
Not exclude statements run as user SYS
- B.
Get information on wait events
- C.
Get information on memory usage
- 21.About moving a table, what is true?
- A.
Index are not impacted
- B.
Parallel query is not allowed during the move of the table
- C.
The move will suppress chained rows
- 22.Users A and B are updated a table at the same time with no commit statement, then user C execute a select on that table, What is true?
- A.
C will see the data modified by A and B
- B.
C can reach an ORA-01555 if UNDO tablespace is too small
- C.
C will have to wait for the end of the update from A and B
- 23.Concerning the UNION operator, what is the best about performance?
- A.
UNION ALL
- B.
UNION
- C.
UNION and UNION ALL gives no performance difference
- 24.You want to compile all objects in one user schema, What will you use?
- A.
Dbms_utility.compile_schema
- B.
Create our own sql script
- C.
Use the Oracle utlrp.sql script
- 25.Redo log files are multiplexed and one member in a group is lost, What will you do?
- A.
Shutdown the instance and start a complete recovery
- B.
Shutdown the instance and start it with “open resetlogs”
- C.
Drop the lost member with the instance running and add a new member
- 26.You get the message “ORACLE data block corrupted (file 5, block 114)” You are in time pressure to solve the problem, what will you choose?
- A.
RMAN: recover datafile 5;
- B.
RMAN: blockrecover corruption list;
- C.
RMAN: blockrecover datafile 5 block 114;
- 27.Rman backup failed because the Flash Recover Area is full, What can you do? Choose two answers
- A.
Increase Flash Recover Area system disk size
- B.
Increase DB_RECOVER_FILE_DEST_SIZE
- C.
Choose a smaller period for the backup retention policy
- 28.You have started an RMAN recover with the “set until sequence 400” option, RMAN will recover up to witch log sequence?
- A.
Included sequence 400
- B.
Included sequence 399
- C.
Depend also of other RMAN option used
- 29.You want to minimize the amount of time for instance recovery, Which parameter can be changed?
- A.
LOG_CHECKPOINT_TIMEOUT
- B.
FAST_START_MTTR_TARGET
- C.
LOG_CHECKPOINT_INTERVAL
- 30.Your RMAN backup failed because one archived log is missing on disk, you need a backup soon, What will you do?
- A.
Execute rman command “crosscheck archivelog all” and start a backup
- B.
Start a backup without being connected to the catalogue
- C.
Recreate the catalogue and start a new backup
- 31.About Data Pump Export utility,What is true? Choose two answers
- A.
You can export a subset of a table
- B.
You can specify the full path for the dump files
- C.
You can specify the number of Oracle workers process
- 32.Which of the following is an Enterprise Manager Grid Control component?
- A.
Oracle Management Agent
- B.
Oracle Management Service
- C.
Agent and Service
- 33.Identify the file that provides a list of all the ports used in Grid Control installation.
- A.
/install/portlist.ini
- B.
/install/portlist.ini
- C.
/sysman/log/emoms.log
- 34.You can apply Monitoring Templates on:
- A.
Targets
- B.
Groups
- C.
Targets and Groups
- 35.Which privilege enables a user to start a blackout on a target, but not delete a target?
- A.
View
- B.
Operator
- C.
Full
- 36.On which view can you see if archive log has been applied on a standby DB?
- A.
V$DATAGUARD_STATUS
- B.
V$ARCHIVED_LOG
- C.
V$ARCHIVE_DEST_STATUS
- 37.A physical standby DB has been open as read only, What is true?
- A.
each archive logs need to be apply later on manually
- B.
The primary DB can be shutdown and start-up
- C.
After the standby restart the logs are applied by default
- 38.What will you do to increase the ASM rebalance process when adding a disk to a disk group? choose 2 answers
- A.
Increase the number of DB_WRITER_PROCESS
- B.
Increase the parameter ASM_POWER_LIMIT
- C.
Use the REBALANCE option in adddiskgroup command
- 39.You just added a new disk group in your ASM instance, What is the next action?
- A.
Add it to the ASM_DISKSTRING parameter
- B.
Restart the ASM instance
- C.
Mount the new disk group in the ASM instance
- 40.Which option would you used to migrate database file from a non-ASM to an ASM-instance?
- A.
RMAN
- B.
OS utility to copy files to the ASM instance
- C.
Oracle Data Pump Export Import Utility
Back to top