-
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
-
During which phase of the Steps to Success methodology for Cisco SMB Security Solutions would the Security Technology Requirements document be used to determine a customer’s security requirements?()
A . Perform
B . Position
C . Develop
D . Prepare
E . Plan
F . Desig
-
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 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.
-
When recovering from a disaster, the backup and restore operation you use is similar to the export/import configuration procedure, with one additional step. Which additional step must you take when recovering from a disaster?()
A . A new WebSphere profile is required to restore the configuration.
B . The restored system requires the IBM Tivoli Access Manager for e-business (TAMeb) JRTE to be manually configured against the WebSphere’s Java Runtime to allow the IBM Tivoli Federated Identity Manager (ITFIM) Runtime to function properly.
C . The ITFIM Domain needs to be created manually within the Integrated Solution Console.
D . The ITFIM Runtime instance needs to be re-registered with the TAMeb policy server by running the SvrSslCfg command.
-
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
-
What is the first step that you would use Cisco Product Advisor for when selecting a router for an Edge solution?()
A . determine types of protocols to be supported
B . determine the environment in which the router will be used
C . select the number of WAN ports required
D . select the number of LAN ports required
-
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.
-
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