Real Exam Questions 1Z0-060 Dumps Exam Questions in here [Sep-2021]
Get Latest Sep-2021 Conduct effective penetration tests using 1Z0-060
NEW QUESTION 66
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be used to back up only the PDB1 pluggable database? (Choose two.)
- A. BACKUP PLUGGABLE DATABASE PDB1 while connected to the PDB1 container
- B. BACKUP PLUGGABLE DATABASE PDB1 while connected to the ROOT container
- C. BACKUP DATABASE while connected to the PDB1 container
- D. BACKUP DATABASE while connected to the ROOT container
- E. BACKUP PLUGGABLE DATABASE PDB1 while connected to PDB2
Answer: B,C
Explanation:
Explanation
To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.
* (A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command.
* (C)If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command.
NEW QUESTION 67
Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.
What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?
- A. Run the Automatic Workload Repository (AWR) report.
- B. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
- C. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
- D. Run the Automatic Database Diagnostic Monitor (ADDM).
- E. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
* SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views. SQL Tuning Advisor makes other types of recommendations, such as creating SQL profiles and restructuring SQL statements.
* The query optimizer can also help you tune SQL statements. By using SQL Tuning Advisor and SQL Access Advisor, you can invoke the query optimizer in advisory mode to examine a SQL statement or set of statements and determine how to improve their efficiency. SQL Tuning Advisor and SQL Access Advisor can make various recommendations, such as creating SQL profiles, restructuring SQL statements, creating additional indexes or materialized views, and refreshing optimizer statistics.
Note:
* Decision support system (DSS) workload
* The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code. This cache contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles.
NEW QUESTION 68
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?
- A. It fails and reports an error because the CONTAINER=CURRENT clause is not used.
- B. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
- C. It fails and reports an error because the CONTAINER=ALL clause is not used.
- D. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
- E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
Answer: E
Explanation:
REVOKE ..FROM
If the current container is the root:
/Specify CONTAINER = CURRENT to revoke a locally granted system privilege, object privilege, or role from a common user or common role. The privilege or role is revoked from the user or role only in the root. This clause does not revoke privileges granted with CONTAINER = ALL.
/Specify CONTAINER = ALL to revoke a commonly granted system privilege, object privilege on a common object, or role from a common user or common role. The privilege or role is revoked from the user or role across the entire CDB. This clause can revoke only a privilege or role granted with CONTAINER = ALL from the specified common user or common role. This clause does not revoke privileges granted locally with CONTAINER = CURRENT. However, any locally granted privileges that depend on the commonly granted privilege being revoked are also revoked.
If you omit this clause, then CONTAINER = CURRENT is the default.
Reference: OracleDatabase SQL Language Reference12c, Revoke
NEW QUESTION 69
Which three operations can be performed as multipartition operations in Oracle?
- A. Drop partitions of a list partitioned table
- B. Coalesce partitions of a hash-partitioned global index.
- C. Rename partitions of a range partitioned table
- D. Merge partitions of a list partitioned table
- E. Merge partitions of a reference partitioned index
- F. Move partitions of a range-partitioned table
Answer: A,D,E
Explanation:
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.
A: Merge Multiple Partitions:
The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.
B: Drop Multiple Partitions:
The new "ALTER TABLE ... DROP PARTITIONS " help drop multiple partitions or subpartitions
with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;
Table altered
SQL> Restrictions :
-You can't drop all partitions of the table.
-If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.
NEW QUESTION 70
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 nomount stage.
- B. Alt existing PDBs must be closed.
- C. The CDB must be open.
- D. The CDB must be in the mount stage.
Answer: C
Explanation:
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 71
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? (Choose three.)
- A. Statistics collection is not done for the CUSTOMERStable when schema stats are gathered.
- B. Statistics gathered on the CUSTOMERStable when database stats are gathered are stored as pending statistics.
- C. Any existing statistics for the CUSTOMERStable are still available to the optimizer at parse time.
- D. Statistics collection is not done for the CUSTOMERStable when database stats are gathered.
- E. Statistics gathered on the CUSTOMERStable when schema stats are gathered are stored as pending statistics.
Answer: B,C,E
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 72
You notice that the elapsed time for an important database scheduler Job is unacceptably long.
The job belongs to a scheduler job class and runs in a scheduler window.
Which two actions could reduce the job's elapsed time?
- A. increasing the job's relative priority within the job class to which it belongs
- B. increasing the priority of the job class to which the job belongs
- C. moving the job to an existing higher priority scheduler window with the same schedule and duration
- D. increasing the value of the JOB_QUEUE_PROCESSESparameter
- E. increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window
- F. increasing the priority of the scheduler window to which the job belongs
Answer: A,E
Explanation:
Explanation/Reference:
Explanation:
http://www.dba-oracle.com/job_scheduling/job_classes.htmhttp://docs.oracle.com/database/121/ADMIN/ schedover.htm#i1106396
NEW QUESTION 73
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 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 ARHCHIVELOG mode.
- B. Take the user data tablespace offline.
- C. Ensure that HR_PDB is open.
- D. Place the root container in the nomount stage.
Answer: C
Explanation:
* Because tablespaces in different PDBs can have the same name, to eliminate ambiguity you must connect directly to a PDB to back up one or more of its tablespaces.
* To back up tablespaces or data files:
Start RMAN and connect to a target database and a recovery catalog (if used).
If the database instance is not started, then either mount or open the database.
Run the BACKUP TABLESPACE command or BACKUP DATAFILE command at the RMAN prompt.
NEW QUESTION 74
Which two statements are true when row archival management is enabled?
- A. The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
- B. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
- C. The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
- D. The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
- E. The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
Answer: A,E
Explanation:
A: Below we see a case where we set the row archival visibility parameter to "all"
thereby allowing us to see all of the rows that have been logically deleted:
alter session set row archival visibility = all;
We can then turn-on row invisibility back on by changing row archival visibility = "active":
alter session set row archival visibility = all;
B: To use ora_archive_state as an alternative to deleting rows, you need the following settings and parameters:
1.Create the table with the row archival clause
2.Now that the table is marked as row archival, you have two methods for removing rows, a permanent solution with the standard delete DML, plus the new syntax where you set ora_archive_state to a non-zero value:
update mytab set ora_archive_state=2 where col2='FRED';
3.To make "invisible rows" visible again, you simply set the rows ora_archive_state to zero:
create table mytab (col1 number, col2 char(200)) row archival; update mytab set ora_archive_state=0 where col2='FRED';
Note:
* Starting in Oracle 12c, Oracle provides a new feature that allow you to "logically delete" a row in a table without physically removing the row. This effectively makes deleted rows "invisible" to all SQL and DML, but they can be revealed at any time, providing a sort of "instant" rollback method.
To use ora_archive_state as an alternative to deleting rows.
NEW QUESTION 75
You database is running an ARCHIVELOG mode.
The following parameter are set in your database instance: LOG_ARCHIVE_FORMAT = arch+%t_%r.arc LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' DB_RECOVERY_FILE_DEST_SIZE = 50G DB_RECOVERY_FILE = '/u01/oradata' Which statement is true about the archived redo log files?
- A. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and in the default location $ORACLE_HOME/dbs/arch.
- B. They are created in the location specified by the LOG_ARCHIVE_DEST_1 parameter and the location specified by the DB_RECOVERY_FILE_DEST parameter.
- C. They are created only in the Fast Recovery Area.
- D. They are created only in the location specified by the LOG_ARCHIVE_DEST_1 parameter.
Answer: D
Explanation:
You can choose to archive redo logs to a single destination or to multiple destinations. Destinations can be local-within the local file system or an Oracle Automatic Storage Management (Oracle ASM) disk group-or remote (on a standby database). When you archive to multiple destinations, a copy of each filled redo log file is written to each destination. These redundant copies help ensure that archived logs are always available in the event of a failure at one of the destinations. To archive to only a single destination, specify that destination using the LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters. ARCHIVE_DEST initialization parameter. To archive to multiple destinations, you can choose to archive to two or more locations using the LOG_ARCHIVE_DEST_n initialization parameters, or to archive only to a primary and secondary destination using the LOG_ ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST initialization parameters.
NEW QUESTION 76
You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connections?
- A. Location of the runtime area for DML and DDL Statements
- B. Persistent area containing bind variable values that are supplied to a SQL statement at run time
- C. Stack space
- D. Location of a part of the runtime area for SELECT statements
- E. User session data
Answer: B,E
NEW QUESTION 77
The tnsnames.ora file has an entry for the service alias ORCL as follows:
The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?
- A. The DEFAULT_DOMAINparameter is set to the wrong value in the sqlnet.orafile.
- B. The listener is not running on the database node.
- C. The TNS_ADMINenvironment variable is set to the wrong value.
- D. The orcl.oracle.com database service is not registered with the listener.
- E. The listener is running on a different port.
Answer: D
Explanation:
Service registration enables the listener to determine whether a database service and its service handlers are available. A service handler is a dedicated server process or dispatcher that acts as a connection point to a database. During registration, the LREG process provides the listener with the instance name, database service names, and the type and addresses of service handlers. This information enables the listener to start a service handler when a client request arrives.
NEW QUESTION 78
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME "TO_DATE ('08/20/12','MM/DD/YY')";
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashed back schema?
- A. 3 and 1
- B. Only 3
- C. 1 and 2
- D. Only 1
- E. Only 2
Answer: A
Explanation:
Explanation
http://www.oracle-base.com/articles/12c/multitentant-flashback-of-container-database-12cr1.php
NEW QUESTION 79
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:
There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
- A. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
- B. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
- C. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
- D. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
- E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
Answer: A
Explanation:
CREATE DISKGROUP NORMAL REDUNDANCY * For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files).
NEW QUESTION 80
You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machine twice with a time difference of four hours.
For which three reasons would you use the Compare Period ADDM report after the replay?
(Choose three.)
- A. to check the performance improvement and degradation caused during the change
- B. to review the hardware resources used during the two runs
- C. to review the change in the initialization parameters between the two runs
- D. to compare the performance change of top SQL statements for the two runs
- E. to find the resource consumption by SQL statements that are common to both periods
- F. to check the database time consumed for the two time periods
Answer: A,B,E
NEW QUESTION 81
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?
- A. Parallel compilation of only the stored PL/SQL code
- B. Sequential recompilation of only the stored PL/SQL code
- C. Sequential recompilation of Java code
- D. Sequential recompilation of any stored PL/SQL code
- E. Parallel recompilation of Java code
- F. Parallel recompilation of any stored PL/SQL code
Answer: E,F
Explanation:
utlrp.sql and utlprp.sql
The utlrp.sql and utlprp.sql scripts are provided by Oracle to recompile all invalid objects in the database. They are typically run after major database changes such as upgrades or patches. They are located in the $ORACLE_HOME/rdbms/admin directory and provide a wrapper on the UTL_RECOMP package. The utlrp.sql script simply calls the utlprp.sql script with a command line parameter of "0". The utlprp.sql accepts a single integer parameter that indicates the level of parallelism as follows.
0 - The level of parallelism is derived based on the CPU_COUNT parameter.
1 - The recompilation is run serially, one object at a time.
N - The recompilation is run in parallel with "N" number of threads.
Both scripts must be run as the SYS user, or another user with SYSDBA, to work correctly.
Reference: Recompiling Invalid Schema Objects
NEW QUESTION 82
Which two statements are true about the RMAN validate database command?
- A. It checks the database for intrablock corruptions.
- B. It checks the database for interblock corruptions.
- C. It can detect corrupt pfiles.
- D. It can detect corrupt block change tracking files.
- E. It can detect corrupt spfiles.
Answer: A,B
Explanation:
Oracle Database supports different techniques for detecting, repairing, and monitoring block corruption. The technique depends on whether the corruption is interblock corruption or intrablock corruption. In intrablock corruption, the corruption occurs within the block itself. This corruption can be either physical or logical. In an interblock corruption, the corruption occurs between blocks and can only be logical.
Note:
* The main purpose of RMAN validation is to check for corrupt blocks and missing files. You can also use RMAN to determine whether backups can be restored. You can use the following RMAN commands to perform validation:
VALIDATE BACKUP ... VALIDATE RESTORE ... VALIDATE
NEW QUESTION 83
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:
What is the result of the last SET CONTAINERstatement and why is it so?
- A. It succeeds because the PDB_ADMIN user has the required privileges.
- B. It fails because local users are unable to use the SET CONTAINER statement.
- C. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).
- D. It fails because common users are unable to use the SET CONTAINER statement.
Answer: B
Explanation:
http://docs.oracle.com/cd/E16655_01/server.121/e17636/cdb_admin.htm
NEW QUESTION 84
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
1. Mount the CDB.
2. Close all the PDBs.
3. Open the database.
4. Apply the archive redo logs.
5. Restore the data file.
6. Take the SYSAUX tablespace offline.
7. Place the SYSAUX tablespace online.
8. Open all the PDBs with RESETLOGS.
9. Open the database with RESETLOGS.
10. Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?
- A. 10, 1, 2, 5, 8
- B. 10, 1, 5, 8, 10
- C. 6, 5, 4, 7
- D. 10, 1, 2, 5, 4, 9, 8
Answer: C
Explanation:
Explanation
RMAN> ALTER TABLESPACE sysaux OFFLINE IMMEDIATE;
RMAN> RESTORE TABLESPACE sysaux;
RMAN> RECOVER TABLESPACE sysaux;
RMAN> ALTER TABLESPACE sysaux ONLINE;
* Example:
While evaluating the 12c beta3 I was not able to do the recover while testing "all pdb files lost".
Cannot close the pdb as the system datafile was missing...
So only option to recover was:
Shutdown cdb (10)
startup mount; (1)
restore pluggable database
recover pluggable database
alter database open;
alter pluggable database name open;
Oracle support says: You should be able to close the pdb and restore/recover the system tablespace of PDB.
* Inconsistent backups are usually created by taking online database backups. You can also make an inconsistent backup by backing up data files while a database is closed, either:
/ Immediately after the crash of an Oracle instance (or, in an Oracle RAC configuration, all instances)
/ After shutting down the database using SHUTDOWN ABORT
Inconsistent backups are only useful if the database is in ARCHIVELOG mode and all archived redo logs created since the backup are available.
* Open the database with the RESETLOGS option after finishing recovery:
SQL> ALTER DATABASE OPEN RESETLOGS;
NEW QUESTION 85
Which three are true about the large pool for an Oracle database instance that supports shared server connections?
- A. Allocates memory for RMAN backup and restore operations
- B. Allocates memory for shared and private SQL areas
- C. Contains a hash area performing hash joins of tables
- D. Contains stack space
- E. Contains a cursor area for storing runtime information about cursors
Answer: A,B,E
Explanation:
Explanation/Reference:
Explanation:
The large pool can provide large memory allocations for the following:
/(B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases)
/Message buffers used in the parallel execution of statements
/(A) Buffers for Recovery Manager (RMAN) I/O slaves
Note:
* large pool
Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.
* Oracle XA
An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database.
* UGA
User global area. Session memory that stores session variables, such as logon information, and can also contain the OLAP pool.
* Configuring the Large Pool
Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle Database features:
* Shared server
In a shared server architecture, the session memory for each client process is included in the shared pool.
* Parallel query
Parallel query uses shared pool memory to cache parallel execution message buffers.
* Recovery Manager
Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.
NEW QUESTION 86
......
Authentic Best resources for 1Z0-060 Online Practice Exam: https://www.passtorrent.com/1Z0-060-latest-torrent.html