某个月的星期天的日期数有3个是奇数，星期六的日期数有3个是偶数，则这个月的28日是（)。A．星期二B．

d SQL Tuning Sets (STS) from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer, you observed performance regression for a few SQL statements.What would you do with these SQL statements？（）

A. Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.

B. Capture the plans from the previous version using STS and then load them into the stored outline.

C. Capture the plans from the previous version using STS and then load them into SQL Management Base (SMB).

D. Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

A. Change in the Oracle Database version

B. Change in your network infrastructure

C. Change in the hardware configuration of the database server

D. Migration of database storage from non-ASM to ASM storage

E. Database and operating system upgrade

efore installing the Oracle Database server. The database and listener are configured by using Oracle Restart.Examine the following command and its output:$ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled.What does this imply？（）

A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.

B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.

C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.

D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

base (CDB) as a pluggable database (PDB).The characteristics of the non-CDB are as follows:-Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National characterset: AL16UTF16 -O/S: Oracle Linux 6 64-bitThe characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Characterset: AL32UTF8 -O/S: Oracle Linux 6 64-bitWhich technique should you use to minimize down time while plugging this non-CDB into the CDB？（）

A. Transportable database

B. Transportable tablespace

C. Data Pump full export / import

D. The DBMS_PDB package

E. RMAN

to Oracle Database 11g:1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is the reason for performing these activities？ （）

A. to minimize plan regression due to the use of a new optimizer version

B. to completely avoid the use of new plans generated by a new optimizer version

C. to prevent plan capturing when the SQL statement is executed after the database upgrade

D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

Database12c. Your database supports a mixed workload. During the day, lots of insert, update, and deleteoperations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run.The ETL jobs perform certain database operations using two or more concurrent sessions.After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause ofperformance degradation, you want to collect basic statistics such as the level of parallelism, totaldatabase time, and the number of I/O requests for the ETL jobs.How do you accomplish this？（）

A. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.

B. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.

C. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.

D. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required information.

se in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script:SQL> @utlrp.sqlWhat is the significance of executing this script？（）

A. It performs parallel recompilation of only the stored PL/SQL code.

B. It performs sequential recompilation of only the stored PL/SQL code.

C. It performs parallel recompilation of any stored PL/SQL as well as Java code.

D. It performs sequential recompilation of any stored PL/SQL as well as Java code.

tore service contract information for its customers.

You are also the administrator of Oracle relational database management system (RDBMS) server.

This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.

You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.

You want to create reports on the SQL Server computer by using the minimum amount of disk space.

What should you do？

A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.

B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.

C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.

D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).Examine the query and its output:Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file？（）

A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.

B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.

C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.

D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.

E. Re-create the password file in the Oracle Database 12c format.

A. Oracle Net Manager

B. Listener Control utility

C. Database Configuration Assistant

D. Oracle Net Configuration Assistant