Tests Examen

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf';. DML may be performed on tables with one or more extents in this data file during the execution of this command. It overwrites any existing file with the name sales02.dbf in /u02 by default. The “TO” clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used. Compression applies to objects stored in the datafile after the move. Tables with one or more extents in this data file may be queried during the execution of this command.

You execute the command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?. Free space is managed using freelists. It uses the database default block size. It must be smaller than the smallest BIGFILE tablespace. It is a locally managed tablespace. Any data files added to the tablespace must have a size of 5 gigabytes.

Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. The following command is about to be issued by a DBA logged into the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully?. Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space. Add the AUTOEXTEND ON clause with NEXT set to 100M. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.

Which three are benefits of using temp UNDO when performing DML on global temporary tables?. It permits DML on global temporary tables even if the database is opened read-only. It reduces the amount of UNDO stored in the UNDO tablespace. It reduces I/Os to the SYSTEM tablespace. It reduces the amount of redo generated. It reduces I/Os to the SYSAUX tablespace.

You want to view the initialization parameter settings for only a specific PDB. Which of the following statements is true?. SELECT db_unique_name, pdb_uid, name, value$ FROM pdb_spfile$;. SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$spparameter;. SELECT db_unique_name, pdb_uid, name, value$ FROM pdb_spfile$;. SELECT NAME, VALUE, ISPDB_MODIFIABLE FROM v$spparameter;.

Which three statements are true about UNDO and REDO?. REDO is used for read consistency. UNDO is used for some flashback operations. UNDO is used for read consistency. Both REDO and UNDO can be multiplexed. REDO is used for ROLLBACK. REDO is used for instance recovery.

Examine this command: ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?. Dependent indexes become UNUSABLE. The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment. Only queries are allowed on ORDERS while SHRINK is executing. The high-water mark (HWM) of ORDERS is adjusted. Queries and DML statements are allowed on ORDERS while the SHRINK is executing. The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.

Which three statements are true about Oracle Managed Files (OMF)?. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle managed. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

You have connected to a PDB to perform the administration operations of changing and verifying a system parameter that is PDB_MODIFIABLE. What is the appropriate mode to open the PDB to achieve this?. READ WRITE. RESTRICTED READ ONLY. READ ONLY. RESTRICTED WRITE ONLY.

You must create a tablespace of nonstandard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/oracle/data/nstbs_f01.dbf' SIZE 100G BLOCKSIZE 32K; The standard block size is 8K, but other nonstandard block sizes will also be used. Which two are requirements for this command to succeed?. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA. The operating system must use a 32K block size. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE. The /u02 file system must have at least 100G space for the datafile.

Which three statements are true about dynamic performance views?. Read consistency is not guaranteed. V$FIXED_TABLE can be queried to display the names of all dynamic performance views. Data displayed by querying dynamic performance views is derived from metadata in the data dictionary. They are owned by the SYSTEM user. They can be queried only when the database is open.

In which two ways would you disable timing information collected for wait events and much of the performance monitoring capability of the database?. By setting the TIMED_STATISTICS system parameter to FALSE. By executing the PL/SQL procedure DBMS_TIME_STATISTIC.DISABLE(TRUE). By setting the TIMED_STATISTICS_LEVEL system parameter to FALSE. By setting the STATISTICS_LEVEL parameter to BASIC. By executing the PL/SQL procedure DBMS_TIME_STATISTIC_LEVEL(BASIC).

Which statement regarding PDBs (Pluggable Databases) is correct?. You can drop a PDB as long as it is not the PDB seed. You cannot drop a source PDB of a refreshable PDB. You can drop an application root along with the associated PDBs. When the relocation of a PDB is finished, the source PDB must be dropped.

Which three statements are true about Deferred Segment Creation in Oracle databases?. It is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces. It is supported for SYS-owned tables contained in locally managed tablespaces. It is the default behavior for tables and indexes. Indexes inherit the DEFERRED or IMMEDIATE segment creation attribute from their parent table. Sessions may dynamically switch back and forth from DEFERRED to IMMEDIATE segment creation.

Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?. ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated. Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted. The first block with enough free space to accommodate a row being inserted will always be used for that row. PCTFREE defaults to 10% for all blocks in all segments for all compression methods.

Which two statements are true about views used for viewing tablespace and datafile information?. Tablespace free space can be viewed in V$TABLESPACE. V$TABLESPACE displays information about tablespaces contained in the data dictionary. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened. Tablespace free space can be viewed in DBA_TABLESPACES. V$TABLESPACE displays information that is contained in the control file about tablespaces.

Which advisor is used to detect missing or stale object statistics?. SQL Tuning Advisor. SQL Statistics Advisor. SQL Performance Analyzer. SQL Access Advisor.

Which three statements are true about row chaining and row migration done by Oracle database block space management?. A migrated row results in an update to any index on the table to point the row ID in the index to the row's new location. Update statements can result in one or more migrated rows. Update statements can result in one or more chained rows. Row pieces of a chained row must always reside in different blocks. Insert statements can result in a migrated row.

Which two are true about shrinking a segment online?. To shrink a table it must have row movement enabled. It is not possible to shrink either indexes or Index Organized Tables (IOTs). To shrink a table it must have a UNIQUE KEY constraint. It must be in a tablespace that uses Automatic Segment Space Management (ASSM). To shrink a table it must have a PRIMARY KEY constraint.

Your database instance is started with an SPFILE. A PFILE is also available. You execute this command:ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?. In the SPFILE and PFILE. In the SPFILE and memory. Only in memory. In the SPFILE, PFILE, and memory. Only in the SPFILE.

In the SPFILE of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: LISTENER_1 = (ADDRESS = (PROTOCOL = TCP)(HOST = host1.acb.com)(PORT = 1521)) Which statement is true?. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration. The LREG process registers services dynamically with the LISTENER_1 listener. Dynamic service registration cannot be used for this database instance. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.

Which two statements are true concerning logical and physical database structures?. A segment can span multiple data files in some tablespaces. Segments can span multiple tablespaces. A segment might have only one extent. All tablespaces may have one or more data files. A segment’s blocks can be of different sizes. A segment’s blocks can be of different sizes.

Which three tasks are performed by background processes in an Oracle database instance?. Creating dedicated server connections. Registering services with Oracle Net listeners. Writing redo to log files. Writing dirty database block images from the buffer cache. Reading database blocks into the buffer cache. Reading database blocks into the buffer cache.

Script abc.sql must be executed to perform a certain task. User HR with password HR exists in the target database and the account is unlocked. The TNSNAMES.ORA file is up to date. Examine this command attempted by the user: $ sqlplus hr/hr@orcl @abc What will happen and why?. The command succeeds and HR will be connected to the orcl database and after logging out to the abc database. The command fails because the script must refer to the full path name. The command fails and reports an error because @ is used twice. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed. The command succeeds and HR will be connected to the orcl database instance, and the abc script will be executed.

Which two statements are true about the PMON background process?. It registers database services with all local and remote listeners known to the database instance. It records checkpoint information in the control file. It frees resources held by abnormally terminated processes. It rolls back transactions when a process fails. It frees unused temporary segments.

Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?. Instance recovery occurs automatically during the shutdown. Uncommitted transactions are allowed to continue to the next ROLLBACK. New connection requests made to the database instance are refused. Sessions remain connected even if they are not running a transaction. Uncommitted transactions are allowed to continue to the next COMMIT.

What memory structure caches the data dictionary providing access to all database user processes?. The Large Pool. The Java Pool. The Streams Pool. The Shared Pool.

Which resource plan is used to manage the resources for the predefined maintenance window?. By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLAN resource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager. The predefined maintenance window starts automatically with 20% of the system resources. The SYS_GROUP consumer resource group policies define the resources assigned.

You are going to perform a hot remote clone of PDB1 from CDB1 as TESTPDB in CDB2. PDB1 must be taken offline before the cloning process begins. Both CDBs need to be in local undo mode. PDB1 must be in read-only mode. TESTPDB must be in read-only mode after the cloning process is complete.

Which two methods can be used to purge audit records of the Unified Audits?. Only viewed audit records can be purged from Unified Audits. Use DBMS_AUDIT_MGMT.CREATE_PURGE_JOB as a privileged user to schedule an automatic purge job. Only the owner of a Unified Audit Policy can purge audit records by resetting the policy. Use DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL as a privileged user to manually purge audit records. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy. Use DBMS_AUDIT_MGMT.DELETE_AUDIT_RECORDS('POLICY_NAME') as a privileged user to manually purge audit records of a specified Unified Policy.

Which two statements describe how Optimizer Statistics are collected?. Optimizer Statistics are collected automatically by an automatic maintenance job that runs during predefined maintenance windows. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures. Optimizer Statistics are collected by the Statistics Advisor. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.

How do you validate that the database was migrated to Unified Auditing?. By querying V$OPTION for parameter Unified Auditing. By using the LSINVENTORY command to query the Oracle Database Software Library. By querying the DBA_UNIFIED_AUDIT_OPTION view. By executing DBMS_AUDIT_MGMT PL/SQL package in Verify mode.

Which three statements are true about Automatic Diagnostic Repository (ADR)?. It is a file-based repository held outside any database. It is only used for Oracle database diagnostic information. It is held inside an Oracle database schema. It can be used for the problem diagnosis of a database when that database’s instance is down. The ADR base is specified in the DIAGNOSTIC_DEST database parameter.

Which two statements are true about the tools used to configure Oracle Net Services?. The lsnrctl utility requires a listener.ora file to exist before it is started. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target. The Oracle Net Configuration Assistant is only used when running the Oracle installer. Oracle Net Manager can be used to locally configure naming methods on a database server. Oracle Net Manager can be used to centrally configure listeners on any database server target.

Which two actions can you perform using DBCA for an existing database?. Change the character set. Create an additional listener. Change the server mode from dedicated to shared, and vice versa. Create nonstandard block size tablespaces. Create a template that can be used to clone the database.

Which data dictionary view describes the data sources of external tables?. DBA_ALL_USER_EXTERNAL_LOCATIONS. DBA_ALL_USER_TAB_COLUMNS. DBA_ALL_USER_EXTERNAL_TABLES. DBA_ALL_USER_TABLES.

Which two statements are true about trace files produced by the Oracle Database server?. All trace files contain error information that requires contacting Oracle Support. They can be written by server processes to a file system. They can be written by background processes to a file system. Trace file names are based on the database name concatenated with a sequential number. They can be written by server processes to the Fast Recovery Area (FRA).

Which two tasks can you perform using DBCA for databases?. Configure incremental backups for a new database. Configure a nonstandard block size for a new database. Register a new database with an available Enterprise Manager Management server. Change the standard block size of an existing database. Enable flashback database for an existing database.

You unplugged a PDB to plug it into another CDB with the following command: ALTER PLUGGABLE DATABASE pdb1 UNPLUG INTO '/tmp/pdb1.pdb'; Which statement is true prior to plugging the PDB into the other CDB?. The PDB archive file must be copied to the target CDB. The PDB manifest and all the datafiles must be copied to the target CDB. PDB archive file and only the user-defined tablespaces must be copied to the target CDB. The PDB manifest, the data files, and the PDB archive file must be copied to the target CDB.

Which two statements are true about User Authentication in an Oracle Database?. Operating System authentication may be used for system-privileged administrative users. Password authentication must be used for system-privileged administrative users. Password File authentication is supported for any type of database user. REMOTE_LOGIN_PASSWORDFILE must be set to EXCLUSIVE to permit password changes for system-privileged administrative users. Password File authentication must be used for system-privileged administrative users.

Which three statements are true about roles?. Roles must be password protected. Roles may be granted to other roles. The SET ROLE statement can enable one or more roles for a session. Object privileges may not be granted to roles. All roles granted to a user are set on default when the user logs in. The SET ROLE statement can disable one or more roles for a session.

Which two SQL Plan Management Advisor tasks are part of Automatic Maintenance Tasks?. The Automatic SQL Access Advisor task, which is used to manage an application SQL load. The Automatic SQL Performance Analyzer task, which is used to provide details about impact of database changes to application SQL batch. The Automatic Index Advisor task, which is used to create and maintain table indexes based on the DML load and operations. The Automatic SQL Plan Management Evolve Advisor task, which evolves plans that have recently been added as the SQL plan baseline for statements. The Automatic SQL Tuning Advisor tasks, which would examine the performance of high-load SQL statements and make recommendations for those statements.

As the DBA, you execute this command: GRANT CREATE VIEW TO usr1 WITH ADMIN OPTION; USR1 then executes: GRANT CREATE VIEW TO usr2 WITH ADMIN OPTION; USR2 then executes: GRANT CREATE VIEW TO usr3;. When the DBA revokes the CREATE VIEW privilege from USR1, it is revoked from USR2 but not USR3. When the DBA revokes the CREATE VIEW privilege from USR2, it is revoked from USR3. The DBA can revoke only ADMIN OPTION from USR1. USR1 can revoke the CREATE VIEW privilege from USR3. When the DBA revokes the CREATE VIEW privilege from USR1, it is neither revoked from USR2 nor USR3.

In one of your databases, you create a user HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform?. Execute DML statements in the HR schema. Log in to the database instance. Revoke the CREATE SESSION privilege from other users. Grant the CREATE SESSION privilege with ADMIN OPTION to other users. Revoke the CREATE SESSION privilege from user HR. Execute DDL statements in the HR schema.

You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE system privilege and issued the following command: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = (PDB$SEEDdir, 'PDB1dir'); Which three are results of the CREATE command?. It creates new default schemas for the PDB. It creates tablespaces to store metadata. It creates a new local user ADMIN with SYSDBA privileges. The PDB must be opened READ ONLY to complete the integration of the PDB into the CDB. After the PDB is created, it is automatically opened READ/WRITE. It creates a new local user ADMIN with restricted privileges.

You execute the SHUTDOWN ABORT command. Which two statements are true?. A checkpoint is written. Subsequent instance startup performs media recovery. Subsequent instance startup performs instance recovery. Data files are closed normally. Uncommitted transactions are not rolled back by the shutdown.

Which three relationships between instances and Oracle databases are possible without using Multitenant?. One instance on one server mounting multiple databases. Two or more instances on separate servers all mounting and opening the same database. One instance on one server mounting and opening multiple databases. One instance on one server that has no database mounted. One instance on one server mounting and opening one database.

Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance?. Undo segments can be stored in the SYSTEM tablespace. A single transaction may use multiple undo segments simultaneously. Undo segments can be stored in the SYSAUX tablespace. Undo segments can extend when a transaction fills the last extent of the undo segment. Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.

You execute this command: [oracle@host01 ~]$ expdp system/oracle FULL=Y DUMPFILE=exp_db_full.dmp PARALLEL=4 LOGFILE=exp_db_full.log JOB_NAME=exp_db_full During the export operation, you detach from the job by using CTRL+C and then execute this command: Export> STOP_JOB=IMMEDIATE Are you sure you wish to stop the job ([yes]/no): yes Which two statements are true about the job?. It continues to run in the background. You cannot monitor it. v. It terminates.

Which three statements are true about a dedicated server configuration?. The DBA configures the maximum number of dedicated server processes that can share the same dispatcher process. A dedicated server process may be reused by a new session after the session using that process terminates. A dedicated server process communicates directly with a client or middle-tier process once the session is established. Each dedicated server process has its own dispatcher process. A dedicated server process can be spawned by the listener when using local clients. A dedicated server process can be spawned without a listener when using local clients.

Which two tasks can be performed in the NOMOUNT state?. Renaming data files. Enabling online redo log archiving. Creating a database. Re-creating control files. Full database recovery.

Which three tasks are part of the predefined Automated Maintenance Tasks?. Automatic Backups of the database system files. Automatic Optimizer Statistics Collection. Automatic error and failure log collection tasks. Automatic SQL Plan Management advisor tasks. Automatic notification tasks. Automatic segment and segment statistics advisor tasks.

You start your database instance in NOMOUNT state. Which two actions are performed?. All required background processes are started. The consistency of the database is checked. The control files are opened. Memory is allocated for the SGA. SYS can access the database.

Which two statements describe why Database Auditing is a security requirement?. To monitor suspicious activity. To alert DBAs about system issues. To protect against data theft by a non-authorized user. To protect against data corruption. To monitor proper usage of the system and data by privileged users.

One of your database instances was shut down normally and then started in NOMOUNT state. You then executed this command: ALTER DATABASE MOUNT; Which two of these actions are performed?. Online data files are opened. Online redo logs are opened. The initialization parameter file is read. Oracle shared memory structures are allocated. The alert log has instance startup details written to it. Control files are read.

You want to apply the principle of least privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which two types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?. Analysis of privileges that a user has on other schemas’ objects. Analysis of all privileges used by the SYS user. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role. Analysis of privileges that a user has on their own schema objects.

Which two statements are true about database instances and Real Application Clusters (RAC)?. A RAC database must have two or more instances. A RAC database can have one instance. A RAC database must have three or more instances. A RAC database can have instances on separate servers. Two RAC databases can share their instances.

Which two account management capabilities can be configured using Oracle profiles?. The maximum number of sessions permitted for a user before the password must be changed. The maximum amount of CPU time allowed for a user's sessions before their account is locked. The number of days for which an account may be logged in to one or more sessions before it is locked. The ability to prevent a password from ever being reused. The number of days for which an account may be inactive before it is locked.

Which three statements are true about resumable space allocation in Oracle databases?. Resumable space allocation may be enabled for some sessions and not others. A user's session may be suspended and resumed multiple times. Resumable space allocation is only possible with locally managed tablespaces. All sessions must have the same timeout value when waiting for resumable space allocations. A user's session may be suspended even if the user has the UNLIMITED TABLESPACE system privilege. The AFTER SUSPEND event trigger can itself be suspended due to space conditions.

Which two AWR-based tools listed below are part of Oracle Database self-tuning components?. Automatic capture of statistical information from the SGA and storing it in the AWR using Automatic Database Diagnostic. ADDM, a server-based expert that reviews database performance statistics captured by Snapshots to identify potential problems before system performance degrades noticeably. Automatic Diagnostic Collector used to capture and store database errors and hang analysis. Automatic population of performance views (V$ views) from statistical data stored in AWR repository and using Automatic Database Diagnostic. Automatic Application Tracing used to collect High-Load SQL statements and statistics. Automatic Application Tracing used to collect High-Load SQL statements and statistics.

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR). Online table segment shrink. Online index segment shrink. Oracle Managed Files (OMF). Automatic data file extension (AUTOEXTEND).

Which statement is true about database links?. A database link can be created only between two Oracle databases. Private database link creation requires the same user to exist in both the local and the remote databases. A public database link can be created only by SYS. A database link created in a database allows a connection from that database’s instance to the target database’s instance for selecting schema data. A public database link can be used by any user allowing remote database instance connection for selecting schema data.

Which three statements are true about using SQL*Plus?. It can run scripts passed to it by a shell script. It can run Recovery Manager (RMAN) commands. It must be downloaded from the Oracle Technology Network (OTN). It has both command-line and graphical user interfaces (GUI). It can run scripts entered at the SQL prompt. It has its own commands that are separate from any SQL statements.

Which three statements are true about an SPFILE?. It can be created by SYS from an idle instance. It contains only static initialization parameters. It can be used to create a PFILE. It must exist for a database instance to start. It contains initialization parameters whose values can be changed using the ALTER SYSTEM statement.

What are Oracle Database Metrics?. Oracle Database Metrics monitor performance using thresholds to generate alerts. Oracle Database Metrics are part of the Oracle Database Notification system to email information about major database events. Oracle Database Metrics are a set of measured statistics per unit of time (per second), transaction, or sessions that are used to evaluate performance. Oracle Database Metrics are part of Oracle Enterprise Manager Cloud Control’s Notification system used to email alerts. Oracle Database Metrics are a set of statistics built in Oracle Enterprise Manager Cloud Control and used for automation.

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?. The role has the privileges to administer the PDB. The role has the privileges to perform DDL operations on all local schema objects. The role has the privileges to create and manage users within the PDB. No privileges are provided with the PDB_DBA role.

Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?. ALTER SYSTEM CHECKPOINT. ALTER SYSTEM FLUSH BUFFER_CACHE. ALTER SYSTEM SWITCH LOGFILE. ALTER SYSTEM SWITCH LOGFILE.

orcl.dmp contains a full export of the ORCL database. This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~]$ impdp system/oracle SCHEMAS=sh,oe REMAP_SCHEMA=sh:hr DUMPFILE=orcl.dmp EXCLUDE=index TABLE_EXISTS_ACTION=replace LOGFILE=impdp.log Which two statements are true?. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR. It skips only tables that exist in ORCL:SH and ORCL:OE. It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR. It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

At which two container database levels can COMMON Unified Audit Policies be used?. COMMON Unified Audit Policies can only be created at CDB level to monitor DBA operation at any level. At the CDB level. At the Application Root level of an Application Container. At any level by using the COMMON option in the policy. At the PDB level if the policy is created by a COMMON user.

Which three statements are true about Enterprise Manager Cloud Control?. It is integrated with My Oracle Support. It provides management for Oracle-engineered systems. It provides management for Oracle middleware. It uses a web-based console built into the Oracle database using XML DB. It is available to manage a database only when that database is open.

Which three actions are ways to apply the principle of least privilege?. Enabling Unified Auditing. Revoking EXECUTE privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from roles/users (assuming typo for duplicate option). Using Access Control Lists (ACLs). Setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUE. Setting the REMOTE_OS_AUTHENT parameter to TRUE.

What are the three components of Oracle Database Automatic Maintenance Tasks?. A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file. Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks. The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks. A packaging system that allows you to combine all error and failure logs to share with Oracle Support. A database alert log that stores details about major database operations and errors, which is used to manage cluster performance. A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.

Which two statements are true about the configuration and use of UNDO?. Active UNDO is always retained. Unexpired UNDO is always retained. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO. UNDO_RETENTION specifies how long all types of UNDO are retained. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

Which two statements are true about the DUAL table?. It can be accessed by any user who has the SELECT privilege in any schema. It consists of a single row and single column of VARCHAR2 data type. It can display multiple rows but only a single column. It can be accessed only by the SYS user. It can display multiple rows and columns. It can be used to display only constants or pseudo columns.

Which two statements are true about Fine-Grained Auditing (FGA)?. FGA policies by default can be created by a schema owner on an object in their schema. FGA policies can only be created by a user with SYSDBA privilege. FGA policies can be created by a user having the AUDIT_ADMIN privilege. FGA policies can be created by a user having the GRANTED the CREATE_FGA_POLICY role. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.

You execute this command: CREATE BIGFILE TABLESPACE big_tbs DATAFILE '/u01/oracle/data/big_f1.dbf' SIZE 20G; Sufficient storage is available in filesystem /u01. Which two statements are true about the BIG_TBS tablespace?. It will be a dictionary-managed tablespace by default. Additional data files may not be added. AUTOEXTEND is possible for the datafile. It will always have a 32K blocksize. It must be bigger than the largest SMALLFILE tablespace.

Which two statements are true about the UNLIMITED TABLESPACE system privilege and space quota?. It allows a user to have unlimited space in any tablespace in the database. It is overridden by a space quota specified for the user. It allows a user to have unlimited space only in their default permanent tablespace. It allows a role to have unlimited space in any tablespace in the database. By default, users have no quota on their default permanent tablespace.

Which two are benefits of external tables?. They support DELETEs, which transparently deletes records in the file system as if they were table rows. They can be queried while the database is in the MOUNT state like dynamic performance views. They support UPDATEs, which transparently updates records in the file system as if they were table rows. They can be queried, transformed, and joined with other tables without having to load the data first. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.

Which statement is true about database links?. A public database link can be created only by SYS. A database link can be created only between two Oracle databases. A database link created in a database allows a connection from that database’s instance to the target database’s instance, but not vice versa. A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance. Private database link creation requires the same user to exist in both the local and the remote databases.

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales1.dbf' TO '/u01/sales01.dbf' REUSE; Which two statements are true?. DML may be performed on tables with one or more extents in this data file during the execution of this command. If Oracle Managed Files (OMF) is used then the file is renamed but moved to DB_CREATE_FILE_DEST. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command. The file is renamed and stored in the same location. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

What is the result of the following command? ALTER PLUGGABLE DATABASE PDB1 DISCARD STATE;. It is unnecessary if the PDB is in the process of being upgraded. PDB1 is reverted to its default properties, which includes not to automatically open after a CDB restart. PDB1 is reverted to its default properties, which includes automatically opening after a CDB restart. It should be used whenever PDB1 open mode needs to be changed.

Which of the following is true about the status of a PDB that has been unplugged from a CDB?. The STATUS column in CDB_PDBS of the unplugged PDB will be UNPLUGGED. The STATUS column in CDB_PDBS of the unplugged PDB will be UNAVAILABLE. The STATUS column in CDB_PDBS of the unplugged PDB will be REMOVED. The STATUS column in CDB_PDBS of the unplugged PDB will be DISABLED.

Which three statements are true about the tools used to configure Oracle Net Services?. Oracle Net Manager can be used to centrally configure listeners on any database server target. The Oracle Net Configuration Assistant is only used when running the Oracle installer. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server. The lsnrctl utility requires a listener.ora file to exist before it is started. Oracle Net Manager can be used to locally configure naming methods on a database server.

Which three functions are performed by dispatchers in a shared server configuration?. Sending shared server session responses back to requesters on the appropriate connection. Writing inbound requests to the common request queue from all shared server connections. Broadcasting shared server session responses back to requesters on all connections. Receiving inbound requests from processes using shared server connections. Sending each connection input request to the appropriate shared server input queue. Checking for outbound shared server responses on the common outbound response queue.

Which two statements are true about the Automatic Diagnostic Repository (ADR)?. It is held inside an Oracle database schema. The ADR base defaults to $ORACLE_HOME/rdbms/admin if neither DIAGNOSTIC_DEST nor ORACLE_BASE is set. It supports diagnostics for Automatic Storage Management (ASM). It supports diagnostics for Oracle Clusterware. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameter and the ORACLE_BASE environment variable are not set.

Which four statements are true about the Oracle Server architecture?. A person or program can have more than one session with an instance by logging in with different users. The buffer cache and the redo log buffer are held in the large pool. A session represents the state of a user's login to an instance. Each server process or background process has their own Program Global Area (PGA). A connection represents the state of a user's login to an instance. A person or program can have more than one session with an instance by logging in with the same user.

Which of the following statements is true about external tables?. They are read/write tables. They describe how the external table layer presents data to the server. hey describe data stored in the database. They describe how data is stored in the external source.

What are Optimizer Statistics?. Optimizer Statistics are a set of data distribution statistics collected in real time as data is inserted, deleted, or updated, which are stored in AWR and used for generating SQL execution plans. Optimizer Statistics are statistics about data distribution within Oracle Datafiles. Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans. Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl No name server is used. Which statement is true about ORCL?. It must be the name of the database to whose instance HR wishes to connect. It must resolve to a valid connect descriptor in the client's tnsnames.ora file. It must be the name of the server running the database to whose instance HR wishes to connect. It must resolve to a valid connect descriptor in the server’s tnsnames.ora file. It must be the value of the SERVICE_NAMES parameter on the client side.

What services does the Automatic Workload Repository (AWR) provide for the database self-tuning functionality?. Creates a new PDB by plugging in a previously unplugged Non-CDB. Simplifies the process of migrating Non-CDB databases to the cloud. Enables the creation of a Non-CDB from a CDB. Creates a new PDB with the original SID of the Non-CDB.

Which two Oracle database space management features require the use of locally managed tablespaces?. Automatic data file extension (AUTOEXTEND). Free space management with bitmaps. Oracle Managed Files (OMF). Server-generated tablespace space alerts. Online segment shrink.

You want to apply the principle of Least Privilege in all your live databases. One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis. Which three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package?. Analysis of privileges that a user has on their own schema objects that they did not use. Analysis of all privileges used by all users including administrative users in the database. Analysis of all privileges used by all users but excluding administrative users in the database. Analysis of privileges granted directly to a role that are then used by a user who has been granted that role. Analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role. Analysis of privileges that a user has on their own schema objects that they did use.

Which two statements are true about advanced connection options supported by Oracle Net for connection to Oracle?. Connect Time Failover requires the use of Transparent Application Failover (TAF). Source Routing requires the use of encrypted connections. Connect Time Failover requires the connect string to have two or more listener addresses configured. Load Balancing requires the use of a name server. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration.