-
In which two cases would you use an outer join? （）
A . The tables being joined have NOT NULL columns.
B . The tables being joined have only matched data.
C . The columns being joined have NULL values.
D . The tables being joined have only unmatched data.
E . The tables being joined have both matched and unmatched data.
F . Only when the tables have a primary key/foreign key relationship.
-
In which case would you use a FULL OUTER JOIN? （）
A . Both tables have NULL values.
B . You want all unmatched data from one table.
C . You want all matched data from both tables.
D . You want all unmatched data from both tables.
E . One of the tables has more data than the other.
F . You want all matched and unmatched data from only one table.
-
Which IOS command would you use to find out which networks are routed by a particular OSPFprocess？（）
A . show ospf
B . show ip route
C . show ip protocols
D . show ip ospf database
E . None of the other alternatives apply
-
In which situation would you use the Oracle Shared Server configuration？（）
A . when performing export and import using Oracle Data Pump
B . when performing backup and recovery operations using Oracle Recovery Manager
C . when performing batch processing and bulk loading operation in a data warehouse environment
D . in an online transaction processing （OLTP） system where large number of client sessions are idle most of the time
-
Which command would you use to determine what database backups are currently available for restore?（）
A . list database backup
B . report database backup
C . list backup of database
D . list summary backup
E . report backup of database
-
For which two situations would you use functionality provided by the Resource Manager? （）(Choose two.)
A . setting idle timeout limits on resource plans
B . saving storage space by using compressed backup sets
C . creating jobs that will run automatically at a scheduled time
D . assigning priorities to jobs to manage access to system resources
E . creating alerts to perform notification when tablespaces are low on available space resource
-
You are performing a database recovery because a user’s schema is dropped. While performing the recovery， you use the UNTIL SEQUENCE clause. Which type of database recovery are you performing？（）
A . user managed complete recovery
B . user managed incomplete recovery
C . RMAN-based complete recovery
D . RMAN-based incomplete recovery
-
You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （）
A . SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B . SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
C . SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D . SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E . SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual
-
Which two built-ins would you use to remove the HOUR_ALARM timer using the timer_id parameter?（）
A . FIND_TIMER
B . CREATE_TIMER
C . SET_TIMER
D . DELETE_TIMER
E . GET_APPLICATION_PROPERTY
-
In which situation would you use static database registration for a listener（）
A . when multiple databases are to be registered with the listener
B . when DBAs need to connect remotely to start up the database instance
C . when users need to connect the database instance using the host naming method
D . when the database instance that is to be registered with the listener is configured in shared server mode
-
Which protocols would you want to use for secure VPN ？（）
A . EAP
B . Chap
C . Ms-Chap
D . PPTP
E . PAP
F . SPAP
-
You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）
A . You are backing up to tape and your tape device performs its own compression.
B . You are making image copies, and you have not enabled tablespace compression.
C . You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
D . You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
E . You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.
-
Which IOS command would you use to find out which networks are routed by a particular OSPF process（）
A . show ip ospf
B . show ip route
C . show ip protocols
D . show ip ospf database
E . None of the other alternatives apply
-
Which substitution variable would you use if you want to reuse the variable without prompting the user each time? （）
A . &
B . ACCEPT
C . PROMPT
D . &&am
-
Which of the following would you use to enable automatic media recovery for a database？（）
A . SET AUTORECOVERY ON
B . SET RECOVERY ON
C . SET AUTO ON
D . You cannot enable automatic media recovery.
-
In which case would you use the Flashback Database feature to perform a recovery？（）
A . to recover a dropped tablespace
B . to recover data from a truncated table
C . to recover a data file that has been shrunk
D . to recover a database to the state that existed before the RESETLOGS operatio
-
Which step would you use to get information about the number of contacts currently in queue?（）
A . Get Contact Info
B . Get Session Info
C . Get Call Contact Info
D . Get Reporting Statistics&e
-
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature？ （）
A . To recover a dropped table.
B . To recover a dropped schema.
C . To recover data from a truncated table.
D . To view changes made by all the transactions during a given period of time.
E . To view changes made by a single transaction during a given period of time.
-
You are performing an incomplete recovery because some important tables have been dropped and purged from the Recycle Bin. Which clause can you NOT use to perform the incomplete recovery by using the RMAN utility？（）
A . UNTIL CANCEL
B . UNTIL SCN
C . UNTIL SEQUENCE
D . UNTIL TIME
-
Which command would you use to determine what database backups are currently available for restore？（）
A . list database backup
B . report database backup
C . list backup of database
D . list summary backup
E . report backup of database
-
For which two situations would you use functionality provided by the Resource Manager?（）
A . setting idle timeout limits on resource plans
B . saving storage space by using compressed backup sets
C . creating jobs that will run automatically at a scheduled time
D . assigning priorities to jobs to manage access to system resources
E . creating alerts to perform notification when tablespaces are low on available space resource
-
You would like to display the system date in the format "Monday, 01 June, 2001".Which SELECT statement should you use?（）
A . SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B . SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYY') FROM dual;
C . SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D . SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E . SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual
-
Which of the following professional greeting would you use if you do not know the recipient?
-
With which people would you be formal and use titles?
A:Your lead worker
B:your manager
C:your boss
D:a close friend
