Halian Oracle Test

40 Questions | By Halian Ltd | Last updated: Jan 7, 2013 | Total Attempts: 40

Questions

Settings

Welcome, This is an oracle 10g test

Questions and Answers

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