Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）

A . Library cache  B . Row cache C . Dictionary cache  D . Large area  E . Buffer cache

A . A single SQL statement provided by a user B . An existing SQL Tuning Set (STS) C . A preprocessed Database Replay workload D . A schema name E . SQL statement identified in EM as using excessive resource

A .  Filter versions B .  Filter loads C .  Filter tasks D .  Filter optio

A .  OPEN B .  MOUNT C .  NORMAL D .  NOMOUNT

A . ADR diagnostic files B . all the optimizer statistics C . initialization parameter settings D . PL/SQL functions, procedures, and packages E . the table and index definitions and actual data

A . It enables all system triggers. B . It allows only SYSDBA connections. C . It ensures that all job queues remain active during the upgrade process. D . It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

A .  The SGA Tuning Advisor B .  The SQL Access Advisor C .  The SQL Tuning Advisor D .  The Memory Advisor

A .  It must be executed from the Oracle Database 11g environment. B .  It must be executed only after the SYSAUX tablespace has been created. C .  It must be executed from the environment of the database that is being upgraded. D .  It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E .  It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

A .  The switch privilege is granted to the PROG_ROLE role. B .  The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group. C .  The users cannot grant the switch privilege to other users. D .  The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

A . The tablespace would require recovery to go back online. B . A checkpoint is taken on all data files that are associated with the SALES tablespace. C . The sessions that subsequently try to access the objects in the SALES tablespace receive an error. D . The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

A . SQL Repair Advisor B . SQL Optimizer C . SQL Access Advisor D . SQL Tuning Advisor SQL

A . It must be executed from the Oracle Database 11g environment. B . It must be executed only after the SYSAUX tablespace has been created. C . It must be executed from the environment of the database that is being upgraded. D . It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E . It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

A . The SGA Tuning Advisor B . The SQL Access Advisor C . The SQL Tuning Advisor D . The Memory Advisor

A .  EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor B .  EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor C .  EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor D .  Either B or C E .  All of the above

A . The tablespace would require recovery to go back online. B . A checkpoint is taken on all data files that are associated with the SALES tablespace. C . The sessions that subsequently try to access the objects in the SALES tablespace receive an error D . The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

A . View B . Table C . Routine D . Package

A . access-list 100 permit any any udp eq 1434 B . access-list 100 permit any any udp eq 1434 log C . access-list 110 permit any any udp eq 69 D . access-list 110 permit any any udp eq 69 log E . None of above.

A . Use the Capacity Manager to monitor the processes on the servers.Log the events to the event log and use the resource monitor to restart the SQL process. B . Use the System Availability tool that comes with IBM Director to improve the availability of the SQL applications. C . Use the IBM Director Application PING function to watch the SQL service. When the SQL service goes down， restart the service remotely on the managed server using the software distribution function. D . Utilize Process Management and create a threshold to monitor the SQL process.Create an Event Action Plan and set the task to restart the SQL process when stopped and apply it to the managed SQL servers.

A .  It enables all system triggers. B .  It allows only SYSDBA connections. C .  It ensures that all job queues remain active during the upgrade process. D .  It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

A .  A single SQL statement provided by a user B .  An existing SQL Tuning Set （STS） C .  A preprocessed Database Replay workload D .  A schema name E .  SQL statement identified in EM as using excessive resource

A . UDT B . Trigger C . Package D . Access pla

A .  Create new indexes. B .  Modify existing indexes. C .  Implement partitioning on a nonpartitioned table. D .  Create materialized views. E .  All of the above

A . SELECT * FROM t1 UNION SELECT * FROM t2 B . SELECT * FROM t1 UNION DISTINCT SELECT * FROM t2 C . SELECT * FROM t1 INTERSECT SELECT * FROM t2 D . SELECT * FROM t1 WHERE (c1,c2)= (SELECT c1,c2 FROM t2)