-
You are creating a SQL Tuning Set to allow a group of SQL statements to be passed into the SQL Tuning Advisor. Which packages will you use to create the SQL Tuning Set？（）
A . DBMS_WORKLOAD_REPOSITORY
B . DBMS_RESOURCE_MANAGER
C . DBMS_SQLTUNE
D . DBMS_ADVISOR
-
You want users to log on to Active Directory by using a new Principal Name （UPN）. You need to modify the UPN suffix for all user accounts. Which tool should you use（）
A . Dsmod
B . Netdom
C . Redirusr
D . Active Directory Domains and Trust
-
You want to allow Router R1 to immediately become the active router if its priority is highest than the active router fails. What command would you use if you wanted to configure this？ （）
A . en standby preempt
B . standby preempt enable
C . standby preempt
D . hot standby preempt
-
You are designing the placement of the global catalog servers. You want to use the minimum number of global catalog servers that are required. Which design should you use?（）
A . One global catalog server in New York.
B . Two global catalog servers in New York.
C . One global catalog server in Chicago and one global catalog server in New York.
D . Two global catalog servers in Chicago and two global catalog servers in New York.
E . One global catalog server in Chicago, one global catalog server in New York, and one global catalog server in Boston.
-
You want to use RMAN to create compressed backups.Which statement is true about the compression algorithms that RMAN can use?（）
A . The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B . The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C . The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D . Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
-
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）
A . The CDB must be open.
B . The CDB must be in the mount stage.
C . The CDB must be in the nomount stage.
D . Alt existing PDBs must be closed.
-
You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment. Which three sources can you select for the advisor to analyze？（）
A . Top SQL
B . snapshots
C . SQL Tuning sets
D . index access path
E . optimizer statistics
F . materialized view log
-
You want to use RMAN to create compressed backups. Which statement is true about the compression algorithms that RMAN can use？（）
A . The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
B . The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
C . The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
D . Only the BZIP2 compression algorithm can be used to make compressed backups to disk.
-
You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）
A . Named Pipes
B . TCP/IP
C . Shared Memory
D . Virtual Interface Adapter (VIA)
E . Multiprotocol&e
-
You want to create a pie-style chart using the Chart Wizard. What must be you do to determine the fields available for use in this chart? （）
A . Select the block that contains the data to appear in the pie chart.
B . Select the table that contains the data to appear in the pie chart.
C . Select the view that contains the data to appear in the pie chart.
D . Nothing. The wizard will automatically create the pie chart based on the highlighted data.
-
You want to analyze a SQL Tuning Set （STS） using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set？（）
A . Every SQL statement in the STS is considered only once for execution.
B . The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics.
C . The execution plan and execution statistics are computed for each SQL statement in the STS.
D . The effects of DDL and DML are considered to produce the execution plan and execution statistics.
-
You are designing the placement of the global catalog servers. You want to use the minimum number of global catalog servers that are required. Which design should you use？（）
A . One global catalog server in New York.
B . Two global catalog servers in New York.
C . One global catalog server in Chicago and one global catalog server in New York.
D . Two global catalog servers in Chicago and two global catalog servers in New York.
E . One global catalog server in Chicago， one global catalog server in New York， and one global catalog server in Boston.
-
You want to use WLST to view metrics for a running domain. Which command should you issue to navigate through the Mbean hierarchy containing the metrics?（）
A . runtime ()
B . runtimeMbeanServer ()
C . connectRuntime ()
D . beginRuntime ()
E . serverRuntime ()
-
You have a domain that was created and configured with WebLogic 10.3.5. You want to upgrade the domain to use WebLogic 12c. Which Oracle tool must you use to upgrade your domain?（）
A . Oracle WebLogic Domain Upgrade tool
B . Smart Update
C . Smart Upgrade
D . No tool required, just install WebLogic 12c, update the domain to point to the new WebLogic installation and start your domain.
E . JDeveloper
-
You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task？（）
A . EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history => 5， job_name => ’JOB1’）；
B . EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， job_name => ’JOB_LOG’）；
C . EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log => ’JOB1’）；
D . EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history => 5， which_log =>’JOB_LOG’）；
-
You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use？（）
A . a domain user account
B . a local user account
C . the NETWORK SERVICE account
D . the LOCAL SYSTEM account
-
View the following SQL statements:
https://assets.asklib.com/images/image2/2018080211430018041.jpg
You want to back out transaction T2. Which option would you use?（）
A . It is possible, but transaction T3 also backs out.
B . It is possible with the NOCASCADE_FORCE option.
C . It is possible with the NONCONFLICT_ONLY option.
D . It is not possible because it has conflicts with transaction T3.
-
You want users to log on to Active Directory by using a new User Principal Name （UPN）. You need to modify the UPN suffix for all user accounts. Which tool should you use（）
A . Dsmod
B . Netdom
C . Redirusr
D . Active Directory Domains and Trust
-
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
-
You want users to log on to Active Directory by using a new User Principal Name （UPN）. You need to modify the UPN suffix for all user accounts. Which tool should you use（）
A . Dsmod
B . Netdom
C . Redirusr
D . Active Directory Domains and Trust
-
The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4) LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10) You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）
A . SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE '\';
B . SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C . SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\";
D . SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_'
-
You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal？（）
A . Named Pipes
B . TCP/IP
C . Shared Memory
D . Virtual Interface Adapter （VIA）
E . Multiprotocol
-
If you want to control the front wheel over various kinds of road conditions, you need learn to use_______.
A steering gear
B starting system
C steering system
D final drive
-
To use the machine, first__ the correct coins, then select （挑选） the drink you want and press the button（）
A．insert
B．investigate
C．promote
D．put
