kiwi的专栏

You are administering a database stored in Automatic Storage management (ASM). Thefiles are stored in the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+

You database is running an ARCHIVELOG mode.The following parameter are set in your database instance:LOG_ARCHIVE_FORMAT = arch+%t_%r.arcLOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive'DB_RECOV

Your multitenant container database (CDB) is running in ARCHIVELOG mode. Youconnect to the CDB RMAN.Examine the following command and its output:You execute the following command:RMAN > BACK

1.Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB andACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is calledtemp01.tmp.A user issues a query o

Examine the following commands for redefining a table with Virtual Private Database (VPD)policies:Which two statements are true about redefining the table?A. All the triggers for the table a

Which two statements are true about the use of the procedures listed in thev$sysaux_occupants.move_procedure column?A. The procedure may be used for some components to relocate component data to t

Which statement is true about Oracle Net Listener?A. It acts as the listening endpoint for the Oracle database instance for all local and nonlocaluser connections.B. A single listener can servic

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and hastwo pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists forthe database.You issue the command to o

Which Oracle Database component is audited by default if the unified Auditing option isenabled?A. Oracle Data PumpB. Oracle Recovery Manager (RMAN)C. Oracle Label SecurityD. Oracle Database

Your multitenant container (CDB) containing three pluggable databases (PDBs) is runningin ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the rootcontainer.The steps to reco

Examine the following steps of privilege analysis for checking and revoking excessive,unused privileges granted to users:1. Create a policy to capture the privilege used by a user for privilege anal

The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from thesame OS user session, you are not able

Which three functions are performed by the SQL Tuning Advisor? A. Building and implementing SQL profiles B. Recommending the optimization of materialized views C. Checking query objects for mi

Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?A. None of the data definition language (DDL) statements are logged in the trace file. B. Only D

In order to exploit some new storage tiers that have been provisioned by a storageadministrator, the partitions of a large heap table must be moved to other tablespaces inyour Oracle 12c database?

Which three are true about the large pool for an Oracle database instance that supportsshared server connections?A. Allocates memory for RMAN backup and restore operationsB. Allocates memory for

You are administering a database stored in Automatic Storage Management (ASM). Youuse RMAN to back up the database and the MD_BACKUP command to back up the ASMmetadata regularly. You lost an ASM d

You notice that the performance of your production 24/7 Oracle database significantlydegraded. Sometimes you are not able to connect to the instance because it hangs. Youdo not want to restart the

What are three purposes of the RMAN “FROM” clause? A. to support PUSH-based active database duplication B. to support synchronization of a standby database with the primary database in a Dataenv

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rowsthat are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage opti

In your multitenant container database (CDB) containing pluggable databases (PDB), userscomplain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check

Which three are direct benefits of the multiprocess, multithreaded architecture of OracleDatabase 12c when it is enabled?A. Reduced logical I/OB. Reduced virtual memory utilizationC. Improved