单项选择题

Oracle Grid Infrastructure for a stand-alone server is installed on your production host before 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.


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which three statements are true regarding the use of the Database Migration Assistant for Unicode(DMU)?()

A. A DBA can check specific tables with the DMU
B. The database to be migrated must be opened read-only.
C. The release of the database to be converted can be any release since 9.2.0.8.
D. The DMU can report columns that are too long in the converted characterset.
E. The DMU can report columns that are not represented in the converted characterset.

2.多项选择题

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?()

A. The valid time columns employee_time_start and employee_time_end are automatically created.
B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
C. The valid time columns are not populated by the Oracle Server automatically.
D. The valid time columns are visible by default when the table is described.
E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio

3.多项选择题Which three activities are supported by the Data Recovery Advisor?()

A. Advising on block checksum failures
B. Advising on inaccessible control files
C. Advising on inaccessible block change tracking files
D. Advising on empty password files
E. Advising on invalid block header field values

4.单项选择题What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?()

A. It fails with the ORA-665610 Invalid DDL statement on history-tracked message
B. The rows in the table are truncated without being archived.
C. The rows in the table are archived, and then truncated.
D. The rows in both the table and the archive are truncated.

5.多项选择题

A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted?()

A. SYS sessions, regardless of the roles that are set in the session
B. SYSTEM sessions, regardless of the roles that are set in the session
C. SCOTT sessions, only if the MGR role is set in the session
D. SCOTT sessions, only if the MGR role is granted to SCOTT
E. SCOTT sessions, because he is the owner of the table
F. SYSTEM session, only if the MGR role is set in the session

7.多项选择题Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?()

A. The size of the shared pool is too small.
B. Cursors are not being shared.
C. A large number COMMITS are being performed.
D. There are frequent logons and logoffs.
E. The buffers are being read into the buffer cache, but some other session is changing the buffers.

8.单项选择题You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privilegesand execute the following sequence statements:What is the result of the last SET CONTAINER statement and why is it so?()

A. It succeeds because the PDB_ADMIN user has the required privileges.
B. It fails because common users are unable to use the SET CONTAINER statement.
C. It fails because local users are unable to use the SET CONTAINER statement.
D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

9.多项选择题Which three operations can be performed as multipartition operations in Oracle?()

A. Merge partitions of a list partitioned table
B. Drop partitions of a list partitioned table
C. Coalesce partitions of a hash-partitioned global index.
D. Move partitions of a range-partitioned table
E. Rename partitions of a range partitioned table
F. Merge partitions of a reference partitioned index

10.多项选择题Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?()

A. Thread creation must be routed through a dispatcher process
B. The local listener may spawn a now process and have that new process create a thread
C. Each Oracle process runs an SCMN thread.
D. Each multithreaded Oracle process has an SCMN thread.
E. The local listener may pass the request to an existing process which in turn will create a thread.

最新试题

You find this query being used in your Oracle 12c database:Which method a used by the optimizer to limit the rows being returned?()

题型:单项选择题

Which two are prerequisites for performing a flashback transaction?()

题型:多项选择题

In which two scenarios do you use SQL* Loader to load data?()

题型:多项选择题

You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?()

题型:多项选择题

Which three statements are true about SQL plan directives?()

题型:多项选择题

Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?()

题型:多项选择题

You upgraded from a previous Oracle database version to Oracle Database version to Oracle 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?()

题型:单项选择题

In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?()

题型:单项选择题

You use the segment advisor to help determine objects for which space may be reclaimed.Which three statements are true about the advisor given by the segment advisor?()

题型:多项选择题

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?()

题型:多项选择题