Dec-2021 Oracle 1Z0-060 Certification Real 2021 Mock Exam [Q79-Q101]

Share

Dec-2021 Oracle 1Z0-060 Certification Real 2021 Mock Exam

1Z0-060 Exam Questions and Valid PMP Dumps PDF 


Oracle 1Z0-060 Dumps

Oracle 12c Dumps are tests created to demonstrate all the features of our Oracle 12c Questions Web Simulator. You will be able to access to many questions and will have the ability to test your knowledge on-line.

There are several components you can interact with when you take our practice tests:

  • Keep an eye on the countdown. This will tell you how much time is left. When the countdown expires, the test will be automatically submitted.
  • Once the test is submitted, the result section will expand. Here, you will be able to review all the questions of the test. From here, you can also navigate directly to each question.
  • Navigate the Oracle 12c Questions using the “Previous” and “Next” buttons.
  • Read the question and select only the answer(s) you think are correct by checking the corresponding check box.
  • if you want to take a look at the correct answers for a question, just click the “Solution” button. In the solution section you will be able to check your answers as well as find a full explanation.
  • Mark the Oracle 12c Certification Questions you wish to review later. All the questions you have marked will be listed in the right section “marked questions”. You will be able to jump directly to the question from this list.
  • Start now our 1Z0-060 dumps on-line Simulator.
  • Take a look at the progress bar at the top; it will tell how you are progressing throughout the exam.

More Info

For more info visit: Oracle 12c Official 1Z0-060 Exam Reference

 

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

  • A. The database must be opened with the RESETLOGSoption after the flashback is complete.
  • B. The database must be MOUNTED for the flashback to succeed.
  • C. The database must be opened in restricted mode for the flashback to succeed.
  • D. The database must have multiplexed redo logs for the flashback to succeed.
  • E. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
  • F. The database must use block change tracking for the flashback to succeed.

Answer: B,C

Explanation:
B:The target database must be mounted with a current control file, that is, the control file cannot be a backup or have been re-created.
D: You must OPEN RESETLOGS after running FLASHBACK DATABASE. If datafiles are not flashed back because they are offline, then the RESETLOGS may fail with an error.
Note:
*RMAN uses flashback logs to undo changes to a point before the target time or SCN, and
then uses archived redo logs to recover the database forward to make it consistent. RMAN
automatically restores from backup any archived logs that are needed.
*SCN: System Change Number
*FLASHBACK DATABASE to One Hour Ago: Example
The following command flashes the database by 1/24 of a day, or one hour:
RMAN> FLASHBACK DATABASE TO TIMESTAMP (SYSDATE-1/24);

 

NEW QUESTION 80
Which two statements are true when row-archival management is enabled? (Choose two.)

  • A. The ORA_ARCHIVE_STATEcolumn is updated in an overnight maintenance job based on activity tracking.
  • B. The ORA_ARCHIVE_STATEcolumn is only displayed if it is referenced in the column select list of a query.
  • C. The ORA_ARCHIVE_STATEcolumn may only be queried by users with the DBArole set.
  • D. The ROW ARCHIVAL VISIBILITYsession parameter defaults to active rows.
  • E. Visibility of the ORA_ARCHIVE_STATEcolumn may only be updated by users with the DBArole set.

Answer: B,D

 

NEW QUESTION 81
Examine this command:
SQL > exec DBMS_STATS.SET_TABLE_PREFS ('SH', 'CUSTOMERS', 'PUBLISH', 'false');
Which three statements are true about the effect of this command?

  • A. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
  • B. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
  • C. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
  • D. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
  • E. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.

Answer: A,B,C

Explanation:
* SET_TABLE_PREFS Procedure
This procedure is used to set the statistics preferences of the specified table in the specified schema.
* Example: Using Pending Statistics
Assume many modifications have been made to the employees table since the last time statistics were gathered. To ensure that the cost-based optimizer is still picking the best plan, statistics should be gathered once again; however, the user is concerned that new statistics will cause the optimizer to choose bad plans when the current ones are acceptable. The user can do the
following:
EXEC DBMS_STATS.SET_TABLE_PREFS('hr', 'employees', 'PUBLISH', 'false');
By setting the employees tables publish preference to FALSE, any statistics gather from now on
will not be automatically published. The newly gathered statistics will be marked as pending.

 

NEW QUESTION 82
Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect to RMAN.
You want to issue the following RMAN command:
RMAN> BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

  • A. Place the root container in ARCHIVELOG mode.
  • B. Take the USERDATA tablespace offline.
  • C. Place the root container in the nomount stage.
  • D. Ensure that HR_PDB is open.

Answer: A

Explanation:
Explanation
RMAN> select name,open_mode from v$pdbs;
using target database control file instead of recovery catalogNAME OPEN_MODE----------
----PDB$SEED READ ONLYORA12P1 READ WRITEORA12P2 MOUNTED
RMAN> backup tablespace ora12p2:users;
Starting backup at 31-MAR-14allocated channel: ORA_DISK_1channel ORA_DISK_1: SID=137 device type=DISKchannel ORA_DISK_1: starting full datafile backup setchannel ORA_DISK_1: specifying datafile(s) in backup setinput datafile file number=00013 name=/appl/oradata/cdbroot/ORA12C1/F5D05369C4B23E83E0430100007F6D99/datafile/o1_mf_users_9mhr0 ORA_DISK_1: starting piece 1 at 31-MAR-14channel ORA_DISK_1: finished piece 1 at 31-MAR-14piece handle=/appl/oradata/flash_recovery/ORA12C1/F5D05369C4B23E83E0430100007F6D99/backupset/2014_03_ tag=TAG20140331T001832 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time:
00:00:01Finished backup at 31-MAR-14
Starting Control File and SPFILE Autobackup at 31-MAR-14piece
handle=/appl/oradata/flash_recovery/ORA12C1/autobackup/2014_03_31/o1_mf_s_843610715_9mhzdcv8_.bkp comment=NONEFinished Control File and SPFILE Autobackup at 31-MAR-14 RMAN> The above example illustrates that if root container is open and in archivelog it can do the backup of tablespace whether the pdb is mounted or open.

 

NEW QUESTION 83
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

  • A. By default, EM express is available for a database after database creation.
  • B. You cannot start up or shut down a database Instance by using EM express.
  • C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
  • D. You can use EM express to manage multiple databases running on the same server.
  • E. You can create and configure pluggable databases by using EM express.

Answer: B

Explanation:
Enterprise Database Express is available only when the database is open. This mean that Enterprise Manager Database Express can not be used to startup the database and other operations that require that the database change state, such as enable, disable ARCHIVELOG mode, are also not available in Enterprise Database Express.

 

NEW QUESTION 84
You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

  • A. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
    OCP.EXAM_RESULTS; connected as SYSTEM.
  • B. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
    EXAM_RESULTS; connected as the OCP user.
  • C. Recover the table using traditional Tablespace Point In Time Recovery.
  • D. Recovery the table sing Database Point In Time Recovery.
  • E. Recover the table using Automated Tablespace Point In Time Recovery.

Answer: E

Explanation:
RMAN tablespace point-in-time recovery (TSPITR).
Recovery Manager (RMAN) TSPITR enables quick recovery of one or more tablespaces in a database to an earlier time without affecting the rest of the tablespaces and objects in the database.
Fully Automated (the default)
In this mode, RMAN manages the entire TSPITR process including the auxiliary instance. You specify the tablespaces of the recovery set, an auxiliary destination, the target time, and you allow RMAN to manage all other aspects of TSPITR.
The default mode is recommended unless you specifically need more control over the location of recovery set files after TSPITR, auxiliary set files during TSPITR, channel settings and parameters or some other aspect of your auxiliary instance.

 

NEW QUESTION 85
In your Oracle 12c database, you create two roles: AUDITORand AUDIT_ADMIN. You then execute the following commands:

To create a privilege analysis policy for the AUDIT_ADMINrole, you execute the following PL/SQLblock:

Which statement is correct about the procedure?

  • A. It only captures the use of the privileges used through the AUDIT_ADMIN role when the ACCOUNT PAYABLE module is used.
  • B. It captures the use of the privileges used through the AUDIT_ADMIN and AUDITORroles when the ACCOUNT PAYABLEmodule is used.
  • C. It always captures the use of the CREATE VIEW and CREATE TABLE privileges.
  • D. It always captures the use of the privileges exercised through the AUDITORand AUDIT_ADMIN roles.

Answer: A

Explanation:
Explanation
Explanation/Reference:
References: https://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM591

 

NEW QUESTION 86
Which two statements are true about the RMAN VALIDATE DATABASEcommand? (Choose two.)

  • A. It checks the database for interblock corruptions.
  • B. It can detect corrupt block change tracking files.
  • C. It checks the database for intrablock corruptions.
  • D. It can detect corrupt spfiles.
  • E. It can detect corrupt pfiles.

Answer: C,D

Explanation:
Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock corruption.
th> corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption.
(key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVERIFY and the ANALYZE statement detect Interblock corruption.
VALIDATE Command Output **> List of Control File and SPFILE.
File TYPE >>> SPFILE or Control File.
Status >>> OK if no corruption, or FAILED If block corruption is found.
Blocks Failing >>> The number of blocks that fail the corruption check. These blocks are newly corrupt.
Blocks Examined >>> Total number of blocks in the file.
Oracle' Database Backup and Recovery User's Guide
12c Release 1 (12.1) - 16 Validating Database Files and Backups

 

NEW QUESTION 87
What are three purposes of the RMAN "FROM" clause?

  • A. to support file restores over the network in a Data Guard environment
  • B. to support PUSH-based active database duplication
  • C. to support file recovery over the network in a Data Guard environment
  • D. to support synchronization of a standby database with the primary database in a Data environment
  • E. to support PULL-based active database duplication

Answer: A,C,D

Explanation:
Explanation/Reference:
Explanation:
* With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible.
* RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.

 

NEW QUESTION 88
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?

  • A. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
  • B. The statement for granting a role to a user fails because the CONTAINER clause is not used.
  • C. Privileges are granted to the C##A_ADMIN user only in the root database.
  • D. The C # # ROLE1 role is created in the root database and all the PDBs.
  • E. The C # # ROLE1 role is created only in the root database because the container clause is not used.

Answer: C,E

Explanation:
* You can include the CONTAINER clause in several SQL statements, such as the CREATE USER, ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements. * * CREATE ROLE with CONTAINER (optional) clause / CONTAINER = ALL Creates a common role. / CONTAINER = CURRENT Creates a local role in the current PDB.

 

NEW QUESTION 89
A redaction policy was added to the SAL columnof the SCOTT.EMP table:

All users have their default set of system privileges.
For which three situations will data not be redacted?

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

Answer: A,C,E

Explanation:
* SYS_CONTEXT This is a twist on the SYS_CONTEXT function as it does not use USERENV. With this usage SYS_CONTEXT queries the list of the user's current default roles and returns TRUE if the role is granted.
Example:
SYS_CONTEXT('SYS_SESSION_ROLES', 'SUPERVISOR')
conn scott/tiger@pdborcl
SELECT sys_context('SYS_SESSION_ROLES', 'RESOURCE')
FROM dual;
SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR')
FALSE
conn sys@pdborcl as sysdba
GRANT resource TO scott;
conn scott/tiger@pdborcl
SELECT sys_context('SYS_SESSION_ROLES', 'RESOURCE')
FROM dual;
SYS_CONTEXT('SYS_SESSION_ROLES','SUPERVISOR')
TRUE

 

NEW QUESTION 90
Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the PDB HR_PDB. You execute the following command:

What is the result?

  • A. It executes successfully but neither tablespace nor the data file is created.
  • B. It fails and reports an error because the CONTAINER=ALLclause is not specified in the command.
  • C. It fails and reports an error because the CONTAINER=CURRENTclause is not specified in the command.
  • D. It executes successfully and creates an UNDOtablespace in HR_PDB.
  • E. It falls and reports an error because there can be only one UNDOtablespace in a CDB.

Answer: A

Explanation:
Explanation/Reference:
Explanation:
Interesting behavior in 12.1.0.1 DB of creating an undo tablespace in a PDB. With the new Multitenant architecture the undo tablespace resides at the CDB level and PDBs all share the same UNDO tablespace.
When the current container is a PDB, an attempt to create an undo tablespace fails without returning an error.

 

NEW QUESTION 91
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disruption to availability is required.
Which three statements are true about this requirement? (Choose three.)

  • A. The partitions can be compressed in the same tablespaces.
  • B. Global indexes must be rebuilt manually after moving the partitions.
  • C. The partitions can be moved online to new tablespaces.
  • D. Local indexes must be rebuilt manually after moving the partitions.
  • E. The partitions can be compressed in the new tablespaces.

Answer: A,C,E

Explanation:
Explanation
A: You can create and rebuild indexes online. Therefore, you can update base tables at the same time you are building or rebuilding indexes on that table. You can perform DML operations while the index build is taking place, but DDL operations are not allowed. Parallel execution is not supported when creating or rebuilding an index online.
D: Moving (Rebuilding) Index-Organized Tables
Because index-organized tables are primarily stored in a B-tree index, you can encounter fragmentation as a consequence of incremental updates. However, you can use the ALTER TABLE...MOVE statement to rebuild the index and reduce this fragmentation.
C: If a table can be compressed in the new tablespace, also it can be compressed in the same tablespace.

 

NEW QUESTION 92
Your multitenant container database (CDB) is running in ARCHIVELOG mode. You connect to the CDB RMAN.
Examine the following command and its output:

You execute the following command:
RMAN > BACKUP DATABASE PLUS ARCHIVELOG;
Which data files will be backed up?

  • A. Data files that belong to only the root container and PDB$SEED
  • B. Data files that belong to only the root container
  • C. Data files that belong to the root container and all the pluggable databases (PDBs)
  • D. Data files that belong to the root container and all the PDBs excluding PDB$SEED

Answer: C

Explanation:
Backing Up a Whole CDB
Backing up a whole CDB is similar to backing up a non-CDB. When you back up a whole CDB, RMAN backs up the root, all the PDBs, and the archived redo logs. You can then recover either the whole CDB, the root only, or one or more PDBs from the CDB backup.
Note:
*You can back up and recover a whole CDB, the root only, or one or more PDBs.
*Backing Up Archived Redo Logs with RMAN
Archived redo logs are the key to successful media recovery. Back them up regularly. You can back up logs with BACKUP ARCHIVELOG, or back up logs while backing up datafiles and control files by specifying BACKUP ... PLUS ARCHIVELOG.

 

NEW QUESTION 93
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

  • A. The CDB must be in the mount stage.
  • B. The CDB must be open.
  • C. Alt existing PDBs must be closed.
  • D. The CDB must be in the nomount stage.

Answer: B

Explanation:
Explanation/Reference:
Explanation:
* Creating a PDB
Rather than constructing the data dictionary tables that define an empty PDB from scratch, and then populating its Obj$ and Dependency$ tables, the empty PDB is created when the CDB is created. (Here, we use empty to mean containing no customer-created artifacts.) It is referred to as the seed PDB and has the name PDB$Seed. Every CDB non-negotiably contains a seed PDB; it is non-negotiably always open in read-only mode. This has no conceptual significance; rather, it is just an optimization device. The create PDB operation is implemented as a special case of the clone PDB operation. The size of the seed PDB is only about 1 gigabyte and it takes only a few seconds on a typical machine to copy it.

 

NEW QUESTION 94
Which three statements are true concerning the multitenant architecture? (Choose three.)

  • A. Different PDBs can have different default block sizes.
  • B. PDBs can share the SYSAUXtablespace.
  • C. PDBs share a common system tablespace.
  • D. Instance recovery is always performed at the CDB level.
  • E. A PDB can have a private TEMPtablespace.
  • F. Each pluggable database (PDB) has its own set of background processes.
  • G. Log switches occur only at the multitenant container database (CDB) level.

Answer: D,E,G

Explanation:
B:
* A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces. It can also contains other user created tablespaces in it.
* There is one default temporary tablespace for the entire CDB. However, you can create additional temporary tablespaces in individual PDBs.
D:
* There is a single redo log and a single control file for an entire CDB
* A log switch is the point at which the database stops writing to one redo log file and begins writing to another.
Normally, a log switch occurs when the current redo log file is completely filled and writing must continue to the next redo log file.
G: instance recovery
The automatic application of redo log records to uncommitted data blocks when an database instance is restarted after a failure.
Incorrect Answers:
A:
* There is one set of background processes shared by the root and all PDBs. -
* High consolidation density. The many pluggable databases in a single container database share its memory and background processes, letting you operate many more pluggable databases on a particular platform than you can single databases that use the old architecture.
C: There is a separate SYSAUX tablespace for the root and for each PDB.
F: There is a separate SYSTEM tablespace for the root and for each PDB. -

 

NEW QUESTION 95
Examine the current value for the following parameters in your database instance:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 700M
DB_8K_CACHE_SIZE = 124M
LOG_BUFFER = 200M
You issue the following command to increase the value of DB_8K_CACHE_SIZE: SQL> ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;
Which statement is true?

  • A. It succeeds only if memory is available from the autotuned components if SGA.
  • B. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.
  • C. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.
  • D. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: D

Explanation:
* The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced.
*Example:
For example, suppose you have an environment with the following configuration:
SGA_MAX_SIZE = 1024M SGA_TARGET = 512M DB_8K_CACHE_SIZE = 128M In this example, the value of SGA_TARGET can be resized up to 1024M and can also be reduced until one or more of the automatically sized components reaches its minimum size. The exact value depends on environmental factors such as the number of CPUs on the system. However, the value of DB_8K_CACHE_SIZE remains fixed at all times at 128M
*DB_8K_CACHE_SIZE Size of cache for 8K buffers
*For example, consider this configuration:
SGA_TARGET = 512M DB_8K_CACHE_SIZE = 128M In this example, increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducing DB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the automatically sized components.

 

NEW QUESTION 96
Which three statements are true about adaptive SQL plan management? (Choose three.)

  • A. It adds new, better plans automatically as fixed plans to the baseline.
  • B. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.
  • C. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
  • D. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.

Answer: B,C,D

 

NEW QUESTION 97
Identify three benefits of Unified Auditing. (Choose three.)

  • A. Decreased use of storage to store audit trail rows in the database.
  • B. It guarantees zero-loss auditing.
  • C. It automatically audits Recovery Manager (RMAN) events.
  • D. The audit trail cannot be easily modified because it is read-only.
  • E. It improves overall auditing performance.

Answer: C,D,E

Explanation:
Explanation
https://blogs.oracle.com/imc/entry/oracle_database_12c_new_unified

 

NEW QUESTION 98
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

  • A. You cannot start up or shut down a database Instance by using EM express.
  • B. By default, EM express is available for a database after database creation.
  • C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
  • D. You can use EM express to manage multiple databases running on the same server.
  • E. You can create and configure pluggable databases by using EM express.

Answer: B

Explanation:
Note:
*Oracle Enterprise Manager Database Express (EM Express) is a web-based database
management tool that is built inside the Oracle Database. It supports key performance
management and basic database administration functions. From an architectural
perspective, EM Express has no mid-tier or middleware components, ensuring that its
overhead on the database server is negligible.
Incorrect:
Not B: For one database at a time.
Not C, Not E: Enterprise Manager Database Express features can be used against non-
CDBs or Oracle RAC database instances.
Not D:After the installation, your instance is started and your database is open. In the
future, there will be times, perhaps for doing database maintenance or because of a power
or media failure, that you shut down your database instance and later restart it.

 

NEW QUESTION 99
An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours. The following are the parameter settings for the database instance:

You want to balance the memory between the System Global Area (SGA) components depending on the workload.
Which option would solve this problem?

  • A. setting the SGA_TARGET parameter to 300M
  • B. setting the SGA_MAX_SIZE parameter to 400M
  • C. setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M
  • D. setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to 400M

Answer: A

 

NEW QUESTION 100
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.

  • A. SYS, SYSTEM
  • B. Only for successful executions
  • C. Both successful and failed executions
  • D. SCOTT
  • E. Only for failed executions

Answer: A,C

Explanation:
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

 

NEW QUESTION 101
......


The Oracle 1Z0-060 exam validates your expertise when it comes to Oracle Database.

As you are getting ready for the Oracle 1Z0-060 certification exam, it is vital that you understand all that is entailed in this test. It is important to mention this is an exam that requires you to have more practical knowledge than theoretical concepts. The majority of those who have failed it focused their attention on cramming rather than gaining the actual skills. You should take a different perspective – be more practical.

Your journey towards earning the Oracle Certified Professional (OCP) certification begins with receiving the Oracle Certified Associate (OCA) credential. With the OCA certificate, you tell the world that you are equipped with vital skills needed to provide support for Oracle products. OCP is the benchmark of your professional career and shows that you have what it takes to implement enterprise-wide databases. Earning it begins with the single step of passing your Oracle 1Z0-060 exam. The test includes 80 questions. There will be 120 minutes to complete all of them. You have to pay 245$ for the 1Z0-060 exam.

 

1Z0-060 Question Bank: Free PDF Download Recently Updated Questions: https://www.surepassexams.com/1Z0-060-exam-bootcamp.html