Oracle 19C OCP-总结——083—2-高频易错题

一、About GI for Standalone Server

3——Which three are true about upgrading Oracle Grid Infrastructure?

A . The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version
B . A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version
C . The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure
D . Only the grid user can perform the upgrade
E . Existing Oracle Database instances must be shut down before starting the upgrade
F . An existing Oracle base can be used.

标准答案 :AEF

7. Which two are true about a read-only Oracle home?

A . It contains an image that can be distributed across multiple servers
B . It is enabled by performing a software-only Oracle Database installation and then running the roohctl-enable script
C . It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.
D . It requires the Rapid Home Provisioning service.
E . It's configuration data and log files reside in subdirectories under the Oracle home
标准答案 :AB

78——Which two are true about Oracle Grid Infrastructure for a Standalone Server? ( )

A . It requires Oracle Automatic Storage Management(ASM)components to be installed separately
B . The CSS daemon runs from the Grid Infrastructure home
C . It can manage database resources on the server where it is installed or on a different server.
D . It supports volume management,file system, and automatic restart capabilities
E . It must be installed before the Oracle database software is installed

标准答案 :BD

110——Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A . It includes both Oracle Restart and Oracle Automatic Storage Management(ASM) software.
B . It creates one disk group during installation.
C . It requires the operating system ORACLE_BASE environment variable to be predefined before installation
D . It requires Oracle ASMLib to manage Automatic Storge Management(ASM) disks.
E . It requires Oracle ASM Filter Driver(ASMFD) to manage Automatic Storge Management(ASM) disks.
F . Automatic Storge Management(ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.
标准答案 :ABF

二、About RMAN

16——Which three are true about recovering tables using RMAN?

A . RMAN can recover tables in the SYSAUX tablespace
B . RMAN always uses an auxiliary instance
C . RMAN can recover a table after a DDL operation has altered the table structure.
D . RMAN can recover tables owned by the sys user
E . RMAN can recover tables in the SYSTEM tablespace
F . RMAN can recover tables in a standby database
G . RMAN can recover tables owned by the SYSTEM user.
标准答案 :BCG

44——Which two are true about duplicating pluggable databases(PDBS) with RMAN?

A . CDB$ROOT and PDB$SEED are automatically duplicated if a PDB is duplicated
B . A user with SYSDBA or SYSBACKUP must use RMAN logged in to a PDB in order to duplicate
C . Two or more PDBS can be duplicated with the same RMAN DUPLICATE command
D . The auxiliary instance is automatically created with ENABLE PLUGGABLE DATABASE TRUE
E . All tablespaces belonging to a PDB must be duplicated when duplicating the PDB
标准答案 :AC

55——Which three are true about RMAN archival backups with the RESTORE POINT clause?

A . Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.
B . The SPFILE is included in the archival backup.
C . The ARCHIVAL attribute for a backup overrides the RMAN retention policy.
D . They are never considered obsolete by RMAN.
E . They can optionally be written to a fast recovery area(FRA).
F . All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.
G . Use of a recovery catalog is always required to support the creation and use of archival backups.

标准答案 :ABC

58——RMAN has just been connected to a target database and the recovery catalog database. In which two cases would an automatic full resynchronization occur between this target databases control file and the RMAN recovery catalog?

A . when control file metadata for archive log backups or image copies has been overwritten in the target databases control file due to being older than CONTROL FILE RECORD KEEP TIME
B . when control file metadata for data file backups or image copies has been overwritten in the target databases control file due to being older than CONTROL FILE RECORD KEEP TIME
C . when a backup of the current control file is created
D . when the target is first registered
标准答案 :CD

59.Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant?

A . After a manual upgrade, TNSNAMES. ORA entries must be updated to reflect the new ORACLE HOME
B . The new extended data type capabity must be enabled by running the utlrp. sql script
C . The Oracle Application Express configuration should be updated after upgrading Oracle Database
D . Any Recovery Manager(RMAN) recovery catalog must be upgraded manually
E . Time zone files must be upgraded manually using the DBM PL/SQL package
标准答案 :BCE

62——Which three are true about cloning databases into an existing CDB with RMAN?

A . The target and auxiliary instance passwords must be the same.
B . Only one PDB can be cloned at a time
C . Two or more PDBS can be cloned with the same command
D . A NON-CDB can be cloned into a PDB
E . A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB
F . A user with SYSDBA or SYSBKUP must be logged in with RMAN to the NON-CDB being cloned when cloning a NON-CDB

标准答案 :ABE

74——Which two are true about RMAN backups when using a media manager?

A . A media manager is required to create RMAN proxy copies.
B . A media manager always writes RMAN requested backups to tape
C . The media manager layer(MML) routines provided by Oracle support any vendors media management products
D . A media manager is required to create RMAN image copies
E . By default, a request for a proxy copy may result in a backup set being created

标准答案 :BE

91.Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies?

A . A new DBID is automatically created for the transported database.
B . By default, the transported database will use Oracle Managed Files.
C . Data files can be converted on the source system.
D . Databases can be transported between systems with different endian formats
E . Data files can be converted on the destination system.
F . The password file is automatically converted by RMAN.
标准答案 :BCE

三、OTHERS

4——Which two are true about the Program Global Area(PGA)and its management in an Oracle database instance? 

A . PGA AGGREGATE LIMII is a hard limit on the PGA size for any one session
B . The entire PGA is located in the System Global Area(SGA)when using shared servers
C . The private SQL area(UGA)is located in the System Global Area(SGA)when using shared servers
D . Sorts and Hash Joins use PGA memory.
E . The private SQL area (UGA)is located in the System Global Area(SGA)when using dedicated servers
标准答案 :CD

5——You plan to perform cross-platform PDB transport using XTTS, Which two are true?

A . A backup of the PDB must exist, taken using the BACKUP command with the ro PLATFORM clause
B . The source PDB can be in MOUNT or OPEN state
C . The source PDB must be in MOUNT state.
D . The source PDB must not be an application root.
E . Automatic conversion of endianess occurs.
F . The source and target platforms must have the same endianess
标准答案 : AF

20——Which three are true in Oracle 19c and later releases?

A . Simultaneous data pump jobs can be limited at the pluggable database(PDB) level
B . An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported
C . Tablespaces always remain in read/write mode during transportable tablespace operations
D . A transportable data pump import can leave a plugged-in tablespace in read/write mode.
E . Tablespaces never remain in read/write mode during transportable tablespace operations
F . A transportable data pump import can leave a plugged-in tablespace in read-only mode
标准答案 :ADF

23——Which two are true about Optimizer Statistics?

A . They are ignored by Optimizer if they are stale.
B . They provide real-time data about schema objects
C . By default, they are automatically gathered by a maintenance job
D . They are gathered by the SQL Tuning Advisor
E . They can be gathered by the DBMS_STATS package
标准答案 :CE

24.Which three are true about interpreting Recovery Manager(RMAN)error stacks returned to standard output?

A . If an RMAN command fails, the output will only identify the command that failed
B . If an RMAN command fails, the output will identify the channel ID where the failure occurred.
C . Media Management errors appear as a line with"sbtio"
D . Some messages in the error stack are not errors
E . Media Management errors appear as a line with"Additional information and a number".
F . Media Management errors appear as a line with"sbtio and a number"

标准答案 :BDE

29——Which three are true about Automatic Workload Repository (AWR)and Automatic Database Diagnostic Monitor(ADDM)in an Oracle multitenant environment?

A . AWR snapshots can be created in CDB$ROOT
B . No AWR data is stored in the CDB$ROOT SYSAUX tablespace
C . ADDM can run in a nonroot container
D . All AWR data is stored in the CDB$ROOT SYSAUX tablespace
E . AWR snapshots can be created in a PDB
F . AWR reports can be generated while connected to any container

标准答案 :AEF

30——Which four are true about duplicating a database using Recovery Manager(RMAN)

A . A connection to an auxiliary instance is always required
B . A connection to the target database instance is always required
C . A subset of the target database can be duplicated
D . A new DBID is always created for the duplicated database
E . Duplication can be done by having the auxiliary database instance pull backup sets from the target database instance
F . Duplication can be done by having the target database instance push copies to the auxiliary database instance
标准答案 :ACEF

31、Which are three of the steps taken by Database Configuration Assistant(DBCA )to clone a remote pluggable database(PDB )starting from Oracle 19c?

A . leaving the cloned PDB in mount state
B . creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
C . creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
D . opening the cloned PDB
E . backing up the cloned PDB
标准答案 :BCD

33——Which three are true about using Database Upgrade Assistant(DBUA)to upgrade a database?

A . Multiple databases with the same ORACLE HOME can be upgraded simultaneously
B . All pluggable databases are automatically upgraded as part of a container database upgrade.
C . DBUA must be launched from the target Oracle Home
D . The Pre-upgrade Information Tool script is executed by DBUA
E . A whole database backup must exist before upgrade
F . The database must be opened in read-only mode.

标准答案 :BCD

35.Which three are true about using Database Resource Manager in an Oracle multitenant environment?

A . A Pdb-level resource plan can limit session PGA memory
B . A Cdb-level resource plan is mandatory when using Pdb-level resource plans
C . A Cdb-level resource plan can limit session CPU utilization.
D . A Cdb-level resource plan can limit PDB UNDO use
E . Pdb-level resource plans can limit uncommitted UNDO per consumer group
F . A Cdb-level resource plan can limit PDB CPU utilization.
标准答案 :ABF

42.Which two are true about backup set compression using RMAN default compression?

A . Compressed backups cannot have a section size denned
B . Unused blocks below the high water mark are backed up
C . Binary compression adds CPU overhead to backup operations
D . Compressed backups can be written only to media
E . Compression can be done only for locally managed tablespaces
标准答案 :CE

48——Your container database, CDB1, is in local undo mode.
You successfully execute this command while connected to CDB1.

SQL>CREATE PLUGGABLE DATABASE pdb1
ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT)
CREATE_FILE_DEST='/u01/ app/orac1e/oradata/cdb1/pdb1 ';

Which three are true about PDB1?

A . It has no local users
B . It has only local roles
C . It has the same number of roles as CDB1.
D . It has the same common users defined as does CDB1
E . It is in mount state after creation
F . Service PDB1 is created for remote logins to PDB1

标准答案 :CEF

61——Which two are true about an rpm-based Oracle Database installation?

A . It requires an Unbreakable Linux Network(ULN)subscription
B . It uses a service configuration script to create a single-instance database as part of the installation
C . It performs a software-only Oracle Database installation
D . It includes the Oracle Preinstallation RPM
E . From Oracle Database 18c, a single RPM can be used to install only Oracle Database Server for a single instance
标准答案 :CD

64.Which three are true about the Oracle Optimizer?

A . It can re-optimize execution plans after previous executions detect suboptimal plans；
B . It considers the filters in WHERE clauses when generating execution plans for SQL statements；
C . It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated;
D . It considers object statistics when generating execution plans for SQL statements；
E . It updates stale object statistics in the Data Dictionary；
F . It obeys all hints.
标准答案 :
ABD

65——The HR_Root application container must support the execution of a query on a table shared by application local PDBS PDB1 and PDB2, and remote PDB PDB3.

Which three are true?

A . A proxy PDB must exist in the application root in the remote CDB
B . A database link must exist in the remote CDB referring to the local CDB
C . A database link must exist in the local CDB root referring to the remote CDB
D . The HR_Root replica must exist in the remote CDB
E . A proxy PDB must exist in the application root in the local CDB
F . PDB3'S application root replica must exist in the local CDB

标准答案：CDE

67——！！！Which three are true about Rapid Home Provisioning（RHP） of Oracle software?

A . It can be used only on nodes with Oracle Grid Infrastructure installed
B . It can be used to patch existing Oracle software installations
C . It can be used to deploy new homes without disrupting active databases.
D . It can be used to upgrade only single-instance databases running on Oracle Restart.
E . It can be used to create templates of Oracle homes as gold images of only Oracle databases
F . It can be used to create a single-instance Oracle Database in an already-installed Oracle home
标准答案 :BCD

68——Which three are true about using an RMAN Recovery Catalog with a pluggable database(PDB)target connection in Oracle Database 19c and later releases?

A . The target PDB must be registered in a Virtual Private Catalog
B . The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog
C . The target PDB must be registered in both the base catalog and the Virtual Private Catalog
D . The target PDB must be registered in a base catalog
E . The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBS
F . The base catalog must be enabled for Virtual Private Catalog use
标准答案 :DEF

74.Which two are true about RMAN backups when using a media manager?

A . A media manager is required to create RMAN proxy copies.
B . A media manager always writes RMAN requested backups to tape
C . The media manager layer(MML) routines provided by Oracle support any vendors media management products
D . A media manager is required to create RMAN image copies
E . By default, a request for a proxy copy may result in a backup set being created
标准答案 :BE

79——HR_Root is an application container with the HR_App application installed. No application PDBS and no application seed have yet been created in HR_ROOT. An application PDB, PDB1, must be created so that the HR_App applications common objects are accessible to it. Which two methods can be used?

A . Create an application seed, synchronize it with HR_Root, and then create the PDB1  application PDB
B . Create the PDB1 application PDB and synchronize it with HR_ROOT
C . Create an application seed, and install HR_APP in it.
D . Create the PDB1 application PDB and synchronize it with PDB$SEED
E . Create the PPB1 application PDB and install HR_App in it
标准答案 :AB

81——USER1 is a common user in App1_Root and all its application PDBS, created when version 1.0 of App1_USER_App was installed
You execute these commands:

$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> ALTER SESSION SET CONTAINER=app1_root;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' to '2.0';
Pluggable database altered
SQL> GRANT CREATE SESSION TO USER1;
Grant succeeded.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE to '2.0'; ;
Pluggable database altered
SQL> ALTER SESSION SET CONTAINER=appl_pdb1；
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app SYNC;
Pluggable database altered.
which two are true?"

A . USER1 can connect to App1_ROOT and APP1_PDB1
B . USER1 can connect only to App1_ROOT
C . USER1 is defined in APP1_PDB2
D . USER1 can connect to APP1_ROOT, App1_ROOTSSEED, and App1_PDB1
E . USER1 can connect only to App1_PDB1
F . USER1 can connect to CDB1
标准答案 :AC

84——Which two are true about memory advisors?

A . If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components
B . If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available
C . If Automatic Shared Memory Management is enabled, both the SGA Advisor are always available.
D . If Automatic Memory Management is enabled, no memory advisors
E . All memory advisors use data from Automatic Workload Repository

标准答案 :CE

87—— Which two are true about a read-only Oracle home?

A . It contains an image that can be distributed across multiple servers
B . It is enabled by performing a software-only Oracle Database installation and then running the roohctl-enable script
C . It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.
D . It requires the Rapid Home Provisioning service.
E . It's configuration data and log files reside in subdirectories under the Oracle home

标准答案 :AB

88——Which three are true about upgrading an application in an application container?

A . The upgrade can be performed when connected either to cdb$root or to PDB$SEED
B . An application name and version number must be specified to upgrade the application
C . After an application upgrade, the application containers pdbs remain synchronized with the existing application root
D . The upgrade must be performed when connected to CDB$ROOT
E . An application root clone gets created automatically
F . After an application upgrade, the application containers PDBS are automatically synchronized with the application root clone

标准答案 :BCE

96——You must migrate a NON-CDB Oracle 11g Database to a CDB without first performing an upgrade to the NON-CDB。

User-defined objects are stored in several tablespaces in the NON-CDB.

Which three methods can you use?

A . Data Pump transportable tablespaces
B . Data Pump full database export and import
C . Data Pump full transportable database
D . replication using Goldengate
E . cloning the NON-CDB as a PDB
F . the DBMS PDB package

标准答案 :BDE

98.Which three actions are mandatory post database upgrade?

A . Resetting passwords to enforce case-sensitivity
B . Setting threshold values for tablespace alerts
C . Upgrading user tables that depend on Oracle-maintained abstract data types.
D . Migration to united auditing
E . Run Patch commands from the new Oracle home
F . Updating client scripts with the new Oracle home
标准答案 :CEF

100——Which two are true about backup encryption?

A . The BACKUP BACKUPSET command can encrypt and decrypt backup sets;
B . Image copies can be encrypted
C . Backup encryption can be enabled selectively for specific tablespaces
D . The Transparent Data Encryption (TDE) keystore is backed up using RMAN
E . Vendor-specific media management software can be used for making encrypted RMAN backups to media
F . Keystore-based encryption is the default mode for RMAN backup encryption
标准答案 :CF

105——Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

A . After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
B . Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
C . After the change, only one undo tablespace can exist in CDB$ROOT.
D . After the change, any user with the required privilege can create an undo tablespace in the PDBs.
E . Undo tablespaces existing in PDBs must be dropped before the change.
F . After the change, each existing PDB has to be reopened for the new undo mode to take effect;

标准答案 :AB

107——Your SALES_ROOT application container has two application PDBs. The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs. Examine this query and its output: ??? Which two are true? (Choose two.)

A . The CONTAINERS clause cannot be used in queries on the REVENUE table.
B . The REVENUE table must be a list-partitioned table.
C . The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
D . The MAPTABLE table is a metadata-linked table.
E . A container map exists for the REVENUE table, but is not enabled.
F . The REVENUE table partitions are not pruned across the PDBs automatically.

标准答案：CF

109.Which three are true about Oracle pluggable database(PDBs)?

A . A PDB can be plugged into a CDB only if both are of the same Oracle Database release.
B . A PDB created from PDB$SEED must be set to READ WRITE after loading data.
C . A non-CDB can be converted into a PDB.
D . A PDB created from PDB$SEED must be set to READ ONLY after loading data.
E . An unplugged PDB can be plugged into multiple CDBs simultaneously by sharing data files.
F . A PDB unplugged from a container database(CDBs) can be plugged into a different CDB without altering any of schemas.
G . A PDB in a remote CDB can be accessed transparently thereby aggregating and remote PDBs

标准答案 :CFG

88、44