How to pass Oracle 1z0-062 exam with the help of dumps?

Question # 1

When is the UNDO_RETENTION parameter value ignored by a transaction?

A. when there are multiple undo tablespaces available in a database
B. when the data file of the undo tablespace is autoextensible
C. when the undo tablespace is of a fixed size and retention guarantee is not enabled
D. when Flashback Database is enabled

Show Answer

Question # 2

Which two services may you see on the My Service Dashboard page? (Choose two.) 

A. Network Cloud Service 
B. User Cloud Service 
C. Compute Cloud Service 

Show Answer

Question # 3

You are managing an Oracle Database 12c database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.   Which three statements are true about these backups? (Choose three.)

A. The backups would be consistent.
 B. The backups would be possible only if the database is running in ARCHIVELOG mode.
C. The backups need to be restored and the database has to be recovered in case of a media failure.
D. The backups would be inconsistent.
E. The backups by default consist of all the data blocks within the chosen files or the full database

Show Answer

Question # 4

The HR.DEPARTMENTS table is the parent of the HR.EMPLOYEES table. The EMPLOYEES.DEPARTMENT_ID column has a foreign key constraint with the ON DELETE CASCADE option that refers to the DEPARTMENTS.DEPARTMENT_ID column. An index exists on the DEPARTMENTS.DEPARTMENT_ID column. A transaction deletes a primary key in the DEPARTMENTS table, which has child rows in the EMPLOYEES table. Which statement is true? 

A. The transaction acquires a table lock only on the DEPARTMENTS table until the transaction is complete. 
B. The transaction acquires a table lock on the DEPARTMENTS table. This lock enables other sessions to query but not update the DEPARTMENTS table until the transaction on the DEPARTMENTS table is complete.
C. The transaction acquires a table lock on the EMPLOYEES table. This lock enables other sessions to query but not update the EMPLOYEES table until the transaction on the DEPARTMENTS table is complete.

Show Answer

Question # 5

Which three statements are true about server-generated alerts? (Choose three.) 

A. Server-generated alerts notify administrators of problems that cannot be resolved automatically
B. Alerts are not issued for locally managed read-only tablespaces. 
C. Response actions cannot be specified for server-generated alerts. 
D. Stateful alerts can be queried only from the DBA_ALERT_HISTORY view. 
E. When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view. 

Show Answer

Question # 6

Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup.   Which two statements are true in this scenario? (Choose two.)

A. The user-managed backup consists of only formatted data blocks.
 B. The database must be shut down to take a user-managed backup.
 C. The RMAN backup contains only data files.
 D. The RMAN backup can be performed while the database is open.
 E. The database must be in MOUNT state to take RMAN backup.

Show Answer

Question # 7

Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with DEPARTMENTS that exists in another tablespace, MASTERTBS. Which two actions will permit the TSPITR to work? (Choose two.)

A. Taking the MASTERTBS tablespace offline 
B. Dropping the relationship between the tables 
C. Adding the MASTERTBS tablespace to the recovery set 

Show Answer

Question # 8

Which statement is true about the loss of a data file belonging to the default undo tablespace?

A. The database remains open in read-only mode.
 B. The database is put in MOUNT state and requires recovery to be opened.
 C. The database remains open for querying but no DML statements can be executed except by the users with SYSDBA privilege.
D. All the noncommitted transactions are lost.
 E. The database instance aborts.

Show Answer

Question # 9

In your database, archive logging and control file autobackup are enabled. The data files and redo log files are intact but control files are impacted due to media failure. In which two recovery scenarios must you use the RESETLOGS option? (Choose two.) 

A. One control file copy is intact so the spfile is changed to refer to only one copy. 
B. One control file copy is intact and damaged control file copies have to be restored to the default location.
C. All copies of the control file are damaged and the CREATE CONTROLFILE statement is executed manually.
D. All copies of the control file are damaged and the auto backed up control file is used for recovery

Show Answer

Question # 10

Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.)

A. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time.
B. AWR data is stored in memory and in a database.
 C. All AWR tables belong to the SYSTEM schema.
 D. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database.
 E. An AWR snapshot contains system-wide tracing and logging information. 

Show Answer

Question # 11

You want execution of large database operations to suspend, and then resume, in the event of space allocation failures. You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600. Which two statements are true? (Choose two.)

A. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.
B. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block
C. A resumable statement can be suspended and resumed only once during execution.
D. A suspended statement will report an error if no corrective action has taken place during a timeout period.

Show Answer

Question # 12

In one of your databases, unified auditing is enabled and an SH.SALES table exists.  You can successfully execute these commands:Which statement is true about SALES_POL?

A. Audit records are always stored in an external audit file.
 B. It is enabled for all users having SELECT privilege on SH.SALES.
 C. It is only enabled for SH.
 D. Only successful queries of SH.SALES are written to the audit trail.

Show Answer

Question # 13

Examine the details of the uncompressed, non-partitioned heap table CITIES. Examine the command: SQL> ALTER TABLE cities SHRINK SPACE COMPACT; What must you do before executing it? 

A. Ensure free space that is approximately equal to the space used by the table should be available.
B. Ensure there are no pending transactions on the table. 
C. Enable row movement is enabled. 

Show Answer

Question # 14

Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup. In which three scenarios do you need media recovery? (Choose three.) 

A. loss of all the copies of the control file 
B. loss of all the inactive online redo log group members 
C. loss of a data file that belongs to the active undo tablespace 
D. loss of data files that belong to the SYSTEM tablespace 

Show Answer

Question # 15

What must you use to read data from a table in your database and write it to an external table?

A. Use SQL* LOADER conventional path load. 
B. Use SQL* LOADER direct path load. 
C. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_LOADER access driver.
D. Use CREATE TABLE. . ORGANIZATION EXTERNAL command with ORACLE_DATAPUMP access driver

Show Answer

Question # 16

Which two statements are true about SQL *Loader Express Mode in an Oracle 12c database? (Choose two.)

A. The DEGREE_OF_PARALLELISM parameter is set to AUTO.
 B. You cannot have multiple SQL *Loader data files.
 C. If no data file is specified, it assumes the data file to be <table-name>.dat in the current directory and uses it.
 D. You can have multiple bad files created when loading in parallel.
 E. You can selectively load rows into a table based on a filter.

Show Answer

Question # 17

Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

A. A schedule can be specified to a single job only. 
B. A scheduler job can point to a chain instead of pointing to a single program object. 
C. A job may get started automatically when a window opens. 
D. A program and job can be specified as part of a schedule definition. 
E. A job is specified as part of a program specification. 
F. A program can be used in the definition of multiple jobs. 
G. A program and schedule can be specified as part of a job definition. 

Show Answer

Question # 18

Examine the command:   SQL> CONNECT hr/hr@orcl   Which two configurations allow this command to execute successfully? (Choose two.)

A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.
 B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host.
 C. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.
 D. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.
 E. The TNS_ADMIN environment variable should be set to orcl on the client. 

Show Answer

Question # 19

When is the UNDO_RETENTION parameter value ignored by a transaction?

A. when there are multiple undo tablespaces available in a database 
B. when the data file of the undo tablespace is autoextensible 
C. when the undo tablespace is of a fixed size and retention guarantee is not enabled 

Show Answer

Question # 20

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

A. Multiple change tracking files can be created for a database. 
B. The change tracking file must be created after the first level 0 backup. 
C. RMAN does not support backup and recovery of the change tracking file. 
D. The database clears the change tracking file and starts tracking changes again, after whole database restore and recovery operations. 

Show Answer

Question # 21

Which set of statements is true about data dictionary views?   1. They are stored in the SYSTEM tablespace.  2. They are based on virtual tables.  3. They are owned by the SYS user.  4. They can be queried by a normal user only if the 07_DICTIONARY_ACCESSIBILITY parameter is set to TRUE.  5. The V$FIXED_TABLE view can be queried to list the names of these views.  6. They are owned by the SYSTEM user.

A. 2, 5, and 6
B. 1, 2, and 3
C. 1 and 3
D. 2, 3, 4, and 5

Show Answer

Question # 22

Which files must you copy from the Oracle home of the database that is being upgraded to the new Oracle home for Oracle Database 12c? (Choose three.)

A. the tnsnames.ora file 
B. the sqlnet.ora file 
C. the initialization parameter file 
D. the password file 
E. the listener.ora file 

Show Answer

Question # 23

Which three statements are true about the upgrade process? (Choose three.)

A. All system triggers are disabled during the upgrade process. 
B. Only queries on fixed views execute without errors until you run the catctl.pl script. 
C. The COMPATIBLE parameter must be set to at least 12.1.0 before issuing the command
D. All job queues remain active during the upgrade process. 
E. Only connections AS SYSDBA are allowed during the upgrade process. 

Show Answer

Question # 24

Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo.   Which two actions would you take to solve this problem? (Choose two.)

A. Increase the size of the temporary tablespace.
B. Enable Automatic Memory Management (AMM).
C. Enable undo retention guarantee.
D. Enable temporary undo for the database.
E. Increase the size of the redo log buffer.

Show Answer

Question # 25

Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in the USERS tablespace is damaged. Which command must you execute before starting the recovery of this tablespace?

A. ALTER TABLESPACE users OFFLINE 
B. STARTUP FORCE NOMOUNT 
C. STARTUP FORCE 

Show Answer

Question # 26

You create a locally managed tablespace ORDERS_TBS with automatic segment management. You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command. CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20; How does the PCTFREE storage parameter influence data storage for this table?

A. It allows only 80% of space to be occupied in all data blocks of this table. 
B. It minimizes row chaining during row insertion. 
C. It minimizes row migration during existing row data updation. 

Show Answer

Question # 27

Which two statements are true about Oracle network connections? (Choose two.) 

A. A listener may listen on behalf of only one database instance at a time. 
B. A server process checks a user’s authentication credentials and creates a session if the credentials are valid.
C. The listener continuously monitors a connection after the user process connects to a service handler.
D. The listener always spawns a new server process to deal with each new connection. 
E. A connection request from a client is always first received by a listener running on the port that is used for the connection request for the database server.

Show Answer

Question # 28

What is pre-requisite to alter a role?

A. You should be granted the DBA role
B. You should set the OS_ROLES parameter to true. 
C. You should be granted the role with the GRANT OPTION.
D. You should have the ALTER ANY ROLE system privilege.

Show Answer

Question # 29

Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)

A. listener configured by using NETCA 
B. database service created by using SRVCTL 
C. database created by using a SQL statement
D. database created by using DBCA
E. ASM instance created by using ASMCA 

Show Answer

Question # 30

Which task is performed by a background process in a database instance?

A. Connecting between a client process and a dispatcher
 B. Executing PL/SQL code
 C. Creating dedicated server connections
 D. Copying online redo log files to offline storage 

Show Answer

Question # 31

SMD is a smallfile locally managed tablespace with manual segment space management.The SH user receives the following error while inserting data into the sales table:Which three actions can be taken to enable the user to insert data? (Choose three.)

A. altering the data file associated with the SMD tablespace to grow automatically
 B. adding a data file to the SMD tablespace, provided the tablespace has not reached its maximum number of file
 C. changing segment space management for the SMD tablespace to automatic
 D. resizing the data file associated with the SMD tablespace to make it larger, provided all data files have not yet reached their maximum size
 E. increasing the space quota on the SMD tablespace for the SH user, provided the files have not yet reached their maximum size 

Show Answer

Question # 32

One of your databases supports an OLTP workload.The default UNDO tablespace is fixed size with:1. RETENTION NOGUARANTEE2. UNDO_RETENTION is 12 minutesUser SCOTT gets this error after a query on the SALES table has run for more than 15minutes:ORA-01555: snapshot too oldWhich three factors taken separately or in some combination might be the cause?(Choose three.)

A. An update was made to the SALES table after the query began 
B. An update to the SALES table was committed after the query began 
C. A committed delete to the SALES table was made more than 12 minutes before the query began
D. An uncommitted update to the SALES table was made more than 12 minutes before the query began
E. A committed update to the SALES table was made more than 12 minutes before the query began

Show Answer

Question # 33

Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express).

A. Grant the APEX_PUBLIC_USER role to the SYSMAN user. 
B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server. 
C. Install Oracle HTTP Server. 
D. Configure at least one dispatcher for the TCP/IP protocol. 

Show Answer

Question # 34

Examine the parameters: Your database instance is started with a PFILE. You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache. You execute the command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M; Which is the outcome?

A. Change is applied to the current instance, but does not persist after instance restart. 
B. The value is changed only in the PFILE and takes effect at the next instance startup. 

Show Answer

Question # 35

Which two statements are true about initialization parameter files? (Choose two.)

A. A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log.
 B. A PFILE must exist for an SPFILE to be created.
 C. The ALTER SYSTEM command cannot be used to change the value of any parameter if a database instance has started using a PFILE.
 D. Both the SPFILE and PFILE must always reside on a file system accessible from the database host server.
 E. On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE. 

Show Answer

Question # 36

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)? (Choose two.)

A. Configure Label Security 
B. Database Vault in ORACLE_HOME 
C. Oracle Suggested Backup Strategy 

Show Answer

Question # 37

The performance of your database degrades between 11:00 AM and 3:00 PM. Automatic Workload Repository (AWR) snapshots are collected on an hourly basis. What is the most efficient way of diagnosing this problem? 

A. Create a custom ADDM task for the period defined by the snapshots taken between 11:00 AM and 3:00 PM.
B. Analyze the latest Automatic Database Diagnostic Monitor (ADDM) report.
C. Analyze the hourly ADDM reports generated between 11:00 AM and 3:00 PM. 

Show Answer

Question # 38

Which three functions can be performed by the SQL Tuning Advisor? (Choose three.)

A. recommending creation of indexes based on SQL workload
B. recommending restructuring of SQL statements that have suboptimal plans
C. checking schema objects for missing and state statistics
D. recommending optimization of materialized views E. generating SQL profiles

Show Answer

Question # 39

Automatic Shared Memory Management is enabled for your database instance. You notice that there are SQL statements performing poorly because of repeated parsing activity. Which action generates recommendations to overcome the performance issues?

A. running the Memory Advisor for the buffer cache 
B. running the Memory Advisor for the library  
 C. running the Memory Advisor for the SGA

Show Answer

Question # 40

Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

A. It clears all user recycle bins in a database and releases their storage space. 
B. It writes a list of invalid SYS and SYSTEM object to the registry$sys_inv_objs table. 
C. It evaluates the dependencies of network utility packages. 
D. It identifies any deprecated and unsupported parameters. 

Show Answer

Question # 41

Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

A. PMON
B. SMON
C. MMNL 
D. MMAN
E. MMON 

Show Answer

Question # 42

One of your databases has archive logging enabled and RMAN backups are taken at regular intervals. The data file for the USERS tablespace is corrupt. Which command must you execute before starting the recovery of this tablespace?

A. STARTUP FORCE 
B. ALTER TABLESPACE users OFFLINE IMMEDIATE; 
C. SWITCH DATAFILE ALL; 
D. ALTER TABLESPACE users OFFLINE NORMAL; 
E. ALTER TABLESPACE users OFFLINE TEMPORARY; 

Show Answer

Question # 43

What should you do for a Scheduler to start a job when a file arrives on a remote system?

A. Start an Oracle database instance on the remote system and register the Scheduler agent with this database.
 B. Install the Scheduler agent on the remote system and register the agent with the database on the local system.
 C. Ensure dedicated server is enabled on both the local and remote databases.
 D. Shutdown the file watcher on the local system. 

Show Answer

Question # 44

You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid Infrastructure for a Standalone Server is already installed on the server.   Which three statements must be true for successful installation of the Oracle Database 12c software? (Choose three.)

A. The OSBACKUPDBA, OSDGDBA, and OSKMDBA OS groups must be created.
 B. An operating system OSDBA group must be created for users with the SYSDBA system privilege.
 C. The Oracle Database 12c software owner and the Oracle Grid Infrastructure owner must belong to the same Oracle Inventory Group.
 D. The Oracle Database 12c installation must have a separate Oracle inventory directory
E. An operating system OSOPER group be created for users with the SYSOPER system privilege.

Show Answer

Question # 45

In which three situations can you use threshold server-generated alerts to helpdiagnose and fix problems? (Choose three.)

A. when free space in a locally managed tablespace falls below a specified percentage
B. when the number of logons per second exceeds a specific value
C. when a resumable statement is suspended
D. when the total number of locked user account exceeds a specific value
E. when the total number of logons exceeds a specific value
F. when free space in a dictionary managed tablespace falls below a specified percentage

Show Answer

Question # 46

Which two tasks must you perform before you begin the upgrade process to Oracle Database 12c? (Choose two.)

A. Put all readonly tablespaces in read write mode
 B. Recompile all invalid objects
 C. Set the compatible parameter to 12.1.0.1
 D. Gather dictionary statistics
 E. Empty all user recycle bins 

Show Answer

Question # 47

A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to 400 and make it persistent for your database instance.  You plan to use the ALTER SYSTEM command.  Which two methods can be used? (Choose two.)

A. Edit PFILE manually, re-create the SPFILE from the edited PFILE, and restart the database instance by using the SPFILE.
 B. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=SPFILE command.
 C. Create an SPFILE, start the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=DEFERRED command. 
D. Create an SPFILE, STARTUP MOUNT the database instance by using the SPFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 command.
E. Start the database instance by using the PFILE, and then execute the ALTER SYSTEM SET PROCESSES=400 SCOPE=BOTH command.
F. Use the PFILE to STARTUP MOUNT the database instance, and then execute the ALTER SYSTEM SET PROCESSES=400 command. 

Show Answer

Question # 48

Which statement is true about unified auditing? 

A. The unified audit trail, by default, resides in a read-only table in the AUDSYS schema in the SYSAUX tablespace.
B. Only the CREATE, ALTER, and DROP statements are audited for all users, including SYS.
C. Unified auditing is enabled only if the AUDIT_TRAIL parameter is set to NONE

Show Answer

Question # 49

You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB.You execute the following command on the PRODDB database server:What should you do to resolve the error? 

A. Add network_link = devdb.us.oracle.com.
 B. Add the SYSTEM user to the schemas option.
 C. Change the dumpfile option value to schema.dat@devdb.us.oracle.com.
 D. Replace the schemas option with network_1ink = devdb.us.oracle.com.
 E. Replace the dumpfile option with network_1ink = devdb.us.oracle.com

Show Answer

Question # 50

Your database is configured in ARCHIVELOG mode, and daily full database backups are taken. RMAN is configured to perform control file autobackups.   Which statement is true about the loss of a duplexed control file?

A. The database remains open but transactions are not permitted.
 B. The database instance aborts, and media recovery is required after restoration of the control file to open the database.
 C. The database instance remains open and the control file can be restored without shutting down the database.
 D. The database instance aborts and a control file restore operation does not require media recovery.

Show Answer

Question # 51

In your database, the STATISTICS_LEVEL parameter is set to TYPICAL and an Automatic  Workload Repository (AWR) snapshot is taken every 30 minutes.   Which two statements are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.) 

A. It measures database performance by analyzing the wait time and CPU time of all non-idle user sessions.
 B. It always compares the latest snapshot with the baseline snapshot for analysis.
 C. It runs after each AWR snapshot is created and it requires at least two snapshots for analysis.
 D. It requires at least four AWR snapshots for analysis.
 E. It calls other advisors if required, but does not provide recommendations about the advisors to be used.

Show Answer

Question # 52

Which two statements describe the relationship between a scheduler window, a resource manager plan, and a job class? (Choose two.)

A. A scheduler window together with a job class, controls resource allocation for a job using that job class in that scheduler window.
 B. A job class specifies a scheduler window that will be open when that job class becomes active.
 C. A scheduler window specifies a resource manager plan that will be activated when that scheduler window becomes active.
 D. A scheduler window specifies a job class that will be activated when that scheduler window becomes active.
 E. A scheduler window can control resource allocation by itself. 

Show Answer

Question # 53

The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR.You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.BOSTON is defined as a service name in the tnsnames.ora of both the databases.You plan to use the command: CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY hr USING 'denver'; What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database? 

A. Execute this command as HR user in the BOSTON database and SYS user in the DENVER database.
 B. Execute this command as SYS user in both the databases.
 C. Execute this command as HR user in the DENVER database.
 D. Execute this command as HR user in the BOSTON database. 

Show Answer

Question # 54

Which two tools can be used to configure static service information in the listener.ora file? (Choose two.) 

A. Oracle Net Manager
 B. Oracle Enterprise Manager Cloud Control
 C. Oracle Net Configuration Assistant
 D. Listener Control Utility (LSNRCTL)
 E. Oracle Enterprise Manager Database Express 

Show Answer

Question # 55

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to tape drive fast enough.   What could be a solution to make streaming happen during the backup?

A. Configure backup optimization
 B. Configure the channel to increase MAXOPENFILES 
 C. Configure the channel to increase the capacity with the RATE parameter
 D. Configure the channel to adjust the tape buffer size with the BLKSIZE option 

Show Answer

Question # 56

Which two utilities can NOT configure a new listener on port 1526? (Choose two.)

A. dbca
 B. asmca
 C. netca
 D. netmgr
 E. lsnrctl 

Show Answer

Question # 57

You want to create a file watcher and an event-based job for detecting the arrival of files on the local server from various locations. To achieve this, you enable the raising of file arrival events from remote systems.   Which two conditions must be satisfied to receive file arrival events from a remote system? (Choose two.)

A. The remote system must have a running Oracle Database instance and a scheduler agent installed.
 B. The initialization parameter REMOTE_OS_AUTHENT must be set to TRUE on your database.
 C. The local database must be set up to run remote external jobs.
 D. The remote system's scheduler agent must be registered with your database.
E. Database links to remote databases must be created.

Show Answer

Question # 58

Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database.   Which two tools or utilities would you use to achieve this? (Choose two.)

A. Oracle Enterprise Manager Database Express (EM Express)
 B. Oracle Enterprise Manager Cloud Control
 C. Database Configuration Assistant (DBCA)
 D. Recovery Manager (RMAN) script invoked by using scheduler 

Show Answer

Question # 59

Which three statements are true about checkpointing? (Choose three.)

A. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the online redo log files.
 B. It ensures that all dirty buffers are written to data files during consistent shutdown.
 C. It reduces the time required for recovery in case of an instance failure. 
 D. Frequent thread checkpoints can degrade database performance.
 E. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers and the control file

Show Answer

Question # 60

Which two statements are true about availability audit features after migration to unified auditing? (Choose two.)

A. The ability of users to audit their own schema objects is not available in the postmigrated database.
 B. Operating system audit trail is available in the post-migrated database.
 C. Network auditing is available in the post-migrated database.
 D. Mandatory auditing of audit administrative actions is available in the post-migrated database. 

Show Answer

Question # 61

Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.) 

A. It can be used to create a database template from an existing database.
 B. It can be used to add a new tablespace.
 C. It can generate SQL database creation scripts.
 D. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
 E. It can configure Automatic Storage Management (ASM) diskgroups. 

Show Answer

Question # 62

Which three database operations can be performed only at MOUNT state? (Choose three.)

A. performing Flashback Database
 B. renaming control files
 C. enabling or disabling ARCHIVELOG mode
D. re-creating control files
 E. performing full database recovery 

Show Answer

Question # 63

Automatic Shared Memory Management (ASMM) is enabled for your database instance.  You execute the following command:   SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;   Which statement is true?

A. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.
 B. It fails because DB_CACHE_SIZE is a static initialization parameter.
 C. It fails because ASMM is enabled and individual SGA components cannot be sized.
 D. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next instance startup.

Show Answer

Question # 64

Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.)

A. Create objects in locally managed tablespaces with Automatic Segment Space Management (ASSM) enabled.
 B. Avoid coding long-running transactions.
 C. Allow the database to handle locks ln default locking mode.
 D. Create objects in locally managed tablespaces with manual segment space management enabled.
 E. Enable undo retention guarantee. 

Show Answer

Question # 65

Your database is running in NOARCHIVLOG mode. Examine the following parameters:You execute the following command after performing a STARTUP MOUNT:   SQL> ALTER DATABASE ARCHIVELOG;   Which statement is true about the execution of the command?

A. It executes successfully and sets the Fast Recovery Area as the local archive destination.
 B. It executes successfully and issues a warning to set LOG_ARCHIVE_DEST while opening the database.
 C. It fails and returns an error about LOG_ARCHIVE_DEST not being set.
 D. It executes successfully and sets $ORACLE_HOME/dbs as the default archive destination. 

Show Answer

Question # 66

Examine these statements:Which three are true about the effects of executing these statements? (Choose three.)

A. The HR account will get locked by Oracle after ten consecutive failed login attempts
B. User HR is permitted to create more than three concurrent sessions.
 C. Password complexity checking is enforced for user HR.
 D. User HR sessions will terminate after ten minutes of continuous inactivity.
 E. The HR account will be locked after three consecutive failed login attempts.
 F. The password complexity will not enforce on the HR account.

Show Answer

Question # 67

Which statement is true about the Oracle central inventory directory (oraInventory)?

A. oraInventory must not be shared by all Oracle software installations on a single system.
 B. If ORACLE_BASE is set to /u01/app/oracle for the oracle user during installation,  OUI creates the Oracle Inventory directory in the /u01/app/oracle/ oraInventory path.
 C. lf an OFA-compliant path is not created and the ORACLE_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation.
 D. Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group.

Show Answer

Question # 68

Which three statements are true about Database Resource Manager? (Choose three.) 

A. A resource plan change can be automated by using the Oracle Scheduler.
B. It can be used to control the consumption of only physical I/Os where excessive physical I/Os can trigger an automatic session termination but excessive logical I/Os cannot.
C. It can be used to control the usage of the undo tablespace by consumer groups
D. A resource plan can have multiple resource plan directives, each of which controls resource allocation for a different consumer group.
E. It can be used to enable resumable timeout for user sessions.
F. It can be used to control the usage of temp tablespace by consumer groups. 

Show Answer

Question # 69

Which two statements are true about Oracle Data Pump export and import operations? (Choose two.)

A. You cannot specify how partitioned tables should be handled during an import operation.
 B. Only data can be compressed during an export operation.
 C. Existing dump files can be overwritten during an export operation.
 D. Tables cannot be renamed during an import operation.
 E. Metadata that is exported and imported can be filtered based on objects and object types.

Show Answer

Question # 70

Your database is configured in ARCHIVELOG mode, and a daily full database backup is taken by using RMAN. Control file autobackup is configured.   Loss of which three database files can lead to an incomplete recovery? (Choose three.)

A. inactive online redo log file group
 B. a data file belonging to the default temporary tablespace
 C. a data file belonging to the SYSAUX tablespace
 D. server parameter le (SPFILE)
 E. active online redo log le group
 F. all the control flies 

Show Answer

Question # 71

Which three are true about the default database buffer cache? (Choose three.)

A. Buffers containing block images may be selected for reuse based only on a Least Recently Used (LRU) algorithm.
 B. It is in the fixed area of the SGA.
 C. Its buffers can contain data block images for blocks that have a corresponding image in a data file. 
 D. Buffers containing block images may be selected for reuse based only on a touch count algorithm.
E. It can contain block images only for database blocks whose block size is equal to the buffer size.
 F. The keep and recycle cache memory is sub-allocated from memory allocated to the default buffer cache.
 G. Its buffers can contain data block images for blocks that have no corresponding image in a data file. 

Show Answer

Question # 72

You want to create a database with a block size other than the default 8 kilobytes (KB) by using the Database Configuration Assistant (DBCA).   Which option should you use?

A. Automatic Storage Management (ASM) for storage of data files
 B. a file system for storage of data files
 C. a Data Warehouse database template
 D. a custom database template

Show Answer

Question # 73

Your single-instance Oracle 12c database home currently supports conventional auditing and uses Automatic Storage Management (ASM). You want to enable unified auditing by executing the command:   $ make –fins_rdbms.mk uniaud_on ioracle ORACLE_HOME=$ORACLE_HOME   Which two steps should you perform before executing this command? (Choose two.)

A. Ensure that the initialization parameter AUDIT_TRAIL is set to DB.
 B. Drop any existing fine-grained audit (FGA) policies.
 C. Stop the listener.
 D. Shut down the database instance.
 E. Disable auditing by setting the initialization parameter AUDIT_TRAIL to NONE.

Show Answer

Question # 74

Examine the command:   SQL> CREATE TABLESPACE test1  DATAFILE '/u01/app/oracle/oradata/orc1/test01.dbf' SIZE 5M  AUTOEXTEND ON UNIFORM;   Which statement is true?

A. The data file, TEST01.DBF, can be auto extended to a maximum size of 5M.
 B. The tablespace, TEST1, can contain a maximum of one data file.
 C. Allocated and free extents are tracked using bitmaps.
 D. Segment free space is tracked in the data dictionary.

Show Answer

Question # 75

Your database is running in ARCHIVELOG mode.   You want to take a consistent whole database backup.   Which two statements are true in this scenario? (Choose two.)

A. RMAN backups contain only data files.
 B. The database instance must be shut down to take a user-managed consistent backup.
 C. Consistent RMAN backups can be taken while the database is open.
 D. User-managed backups only contain formatted data blocks.
 E. The database must be in MOUNT state to take consistent RMAN backups.

Show Answer

Question # 76

Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c?

A. It automatically restarts a Data Pump Export or Import job after a failure is connected and the job continues from the point of failure.
 B. It can be used to migrate a database only if the source and target databases are hosted on the same endian format.
 C. It can be used to migrate a database only if the source database does not have any tablespace in read-only mode.
 D. It allows migration of a database directly over network links. 

Show Answer