Pass Oracle Upgrade to Oracle Database 12c Exam in First Attempt Guaranteed Updated Dump from BraindumpsPrep!
Pass 1Z0-060 Exam with 205 Questions - Verified By BraindumpsPrep
NEW QUESTION 85
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode.
There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?
- A. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
- B. The statement results in an error because there are open PDBs.
- C. The shutdown proceeds immediately.
The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack. - D. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
Answer: D
NEW QUESTION 86
In your multitenant container database (CDB) containing pluggable database (PDBs), the HR user executes the following commands to create and grant privileges on a procedure:
CREATE OR REPLACE PROCEDURE create_test_v (v_emp_id NUMBER, v_ename
VARCHAR2, v_SALARY NUMBER, v_dept_id NUMBER)
BEGIN
INSERT INTO hr.test VALUES (V_emp_id, V_ename, V_salary, V_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO john, jim, smith, king;
How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?
- A. Create the CREATE_TEST procedure with definer's rights.
- B. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
- C. Create the CREATE_TEST procedure with invoker's rights.
- D. Create the CREATE_TEST procedure as part of a package and grant users the EXECUTE privilege the package.
Answer: C
Explanation:
If a program unit does not need to be executed with the escalated privileges of the
definer, you should specify that the program unit executes with the privileges of the caller, also
known as the invoker. Invoker's rights can mitigate the risk of SQL injection.
Incorrect:
Not A: By default, stored procedures and SQL methods execute with the privileges of their owner,
not their current user. Such definer-rights subprograms are bound to the schema in which they
reside.
not B: Using the GRANT option, a user can grant an Object privilege to another user or to
PUBLIC.
NEW QUESTION 87
Examine the current values 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 fails because an increase in DB_8K_CACHE_SIZEcannot be accommodated within SGA_MAX_SIZE.
- B. It fails because an increase in DB_8K_CACHE_SIZEcannot be accommodated within SGA_TARGET.
- C. It succeeds only if memory is available from the autotuned components if SGA.
- D. It fails because the DB_8K_CACHE_SIZEparameter cannot be changed dynamically.
Answer: C
NEW QUESTION 88
A senior DBA asked you to execute the following command to improve performance:
You checked the data in the SUBSCRIBE_LOGtable and found that it is a large table containing one million rows.
What could be a reason for this recommendation?
- A. The keep pool is not configured.
- B. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.
- C. Automatic Shared Memory Management is not enabled.
- D. Automatic Workarea Management is not configured.
- E. The data blocks in the SUBSCRIBE_LOG table are rarely accessed.
Answer: E
Explanation:
You can configure a RECYCLE buffer pool for blocks belonging to those segments that you do not want to keep in memory.
The purpose of the RECYCLE pool is to retain segments that are scanned rarely or are not referenced frequently
http://docs.oracle.com/database/121/TGDBA/tune_buffer_cache.htm#TGDBA552
NEW QUESTION 89
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?
- A. Setting the session valid time using DBMS_FLASHBACK_ARCHIVENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
- B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
- C. The valid time columns employee_time_start and employee_time_end are automatically created.
- D. The valid time columns are visible by default when the table is described.
- E. The valid time columns are not populated by the Oracle Server automatically.
Answer: A,B,C
Explanation:
A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause would be creating them internally.
E: ENABLE_AT_VALID_TIME Procedure
This procedure enables session level valid time flashback.
NEW QUESTION 90
In your Database, the TBS PERCENT USEDparameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?
- A. Setting the target tablespace offline
- B. Setting the target tablespace to read-only
- C. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- D. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
- E. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
Answer: B,E
Explanation:
Explanation/Reference:
Explanation:
The value for TBS_PERCENT_USED specifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.
NEW QUESTION 91
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_STATEcolumn is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
- C. The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
- 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
create table mytab (col1 number, col2 char(200)) row archival;
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:
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 92
Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Category_id number(30),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTStable?
- A. The invisible column cannot be made visible and can only be marked as unused.
- B. The DESCRIBEcommands in SQL *Plus will not display the invisible column in the output.
- C. The %ROWTYPEattribute declarations in PL/SQLto access a row will not display the invisible column in the output.
- D. Referential integrity constraint cannot be set on the invisible column.
- E. A primary key constraint can be added on the invisible column.
Answer: B,C,E
Explanation:
Explanation/Reference:
Explanation:
AB: You can make individual table columns invisible. Any generic access of a table does not show the invisible columns in the table. For example, the following operations do not display invisible columns in the output:
* SELECT * FROM statements in SQL
* DESCRIBE commands in SQL*Plus
* %ROWTYPE attribute declarations in PL/SQL
* Describes in Oracle Call Interface (OCI)
Incorrect Answers:
D: You can make invisible columns visible.
You can make a column invisible during table creation or when you add a column to a table, and you can later alter the table to make the same column visible.
NEW QUESTION 93
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privilege used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.
- A. 1, 3, 2, 5, 6, 4
- B. 1, 3, 2, 5, 6, 4
- C. 1, 3, 5, 6, 2, 4
- D. 1, 3, 5, 2, 6, 4
- E. 1, 3, 6, 2, 5, 4
Answer: E
Explanation:
Explanation
1. Create a policy to capture the privilege used by a user for privilege analysis.
3. Start analyzing the data captured by the policy.
6. Stop analyzing the data.
2. Generate a report with the data captured for a specified privilege capture.
5. Compare the used and unused privileges' lists.
4. Revoke the unused privileges.
NEW QUESTION 94
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKMprivilege to the password file?
- A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to Yes.
- B. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
- C. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
- D. Re-create the password file in the Oracle Database 12c format.
- E. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
Answer: B,C
Explanation:
*orapwd
/You can create a database password file using the password file creation utility, ORAPWD.
The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]
[DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]
[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]
force - whether to overwrite existing file (optional),
*v$PWFILE_users
/ 12c:V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.
/ 10c:sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges Incorrect:
not E: The format of the v$PWFILE_users file is already in 12c format.
NEW QUESTION 95
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output?
- A. The C # # A_ADMINuser can perform wallet operations.
- B. The C # # B_ADMINuser can perform all backup and recovery operations using RMAN only.
- C. The C # # D_ADMINuser can perform backup and recovery operations for Automatic Storage Management (ASM).
- D. The C # # C_ADMINuser can perform the data guard operation with Data Guard Broker.
- E. The C # # B_ADMINuser can perform all backup and recovery operations using RMAN or SQL* Plus.
Answer: C,D,E
Explanation:
Explanation/Reference:
Explanation:
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM
The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database
Incorrect Answers:
C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.
Note:
Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.
NEW QUESTION 96
Your multitenant container database (CDB) contains several pluggable databases (PDBs). Users c# #A admin and B_ADMIN have only connect privileges.
You create a common role c##_role1 with common privileges create table and select any table.
You then execute these commands to grant the role to users In the root container:
SQL> GRANT c##_role1 TO c##_a_admin CONTAINER=ALL;
Then,
SQL> CONN sys/oracle HR_PDB as sysdba
SQL> GRANT C# #_role1 TO b_admin CONTAINER=CURRENT;
Which two statements are true?
- A. B_admin can create and select any table in HR_PDB
- B. B_admin can create and select any table, and grant the c##_role1 role to users in HR_PDB.
- C. C# #_A_admin can create and select any table, and grant the c##_rolei role to users in the root container.
- D. C# #_A_admin can create and select any table In the root container as well as in all current PDBs.
- E. C# #_A_admin can create and select any table in the root container as well as in all current and future PDBs.
Answer: A,D
NEW QUESTION 97
Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c? (Choose two.)
- A. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
- B. You cannot start up or shut down a database instance by using EM express.
- C. Multiple databases on the same node (or host) may each be individually managed by using EM Express.
- D. By default, EM express is available for a database after database creation.
- E. You can create and configure pluggable databases by using EM express.
Answer: B,C
Explanation:
Explanation
O12c is integrated in database don't have his own agent like in O11G then you cannot start up or shut down a database.
NEW QUESTION 98
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?
- A. All users except SYS, SYSTEM, and SCOTT
- B. All users except SYS
- C. All users except SCOTT
- D. All users except SYS and SCOTT
Answer: C
Explanation:
Explanation
If you run multiple AUDIT statements on the same unified audit policy but specify different EXCEPT users, then Oracle Database uses the last exception user list, not any of the users from the preceding lists. This means the effect of the earlier AUDIT POLICY ... EXCEPT statements are overridden by the latest AUDIT POLICY
... EXCEPT statement.
Note:
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings.
By default, this policy is not enabled.
* You can use the keyword ALL to audit all actions. The following example shows how to audit all actions on the HR.EMPLOYEES table, except actions by user pmulligan.
Example Auditing All Actions on a Table
CREATE AUDIT POLICY all_actions_on_hr_emp_pol
ACTIONS ALL ON HR.EMPLOYEES;
AUDIT POLICY all_actions_on_hr_emp_pol EXCEPT pmulligan;
NEW QUESTION 99
Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality feedback?
- A. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.
- B. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.
- C. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.
- D. The optimizer enables monitoring for cardinality feedback after the first execution of a query.
- E. The optimizer can re optimize a query only once using cardinality feedback.
Answer: B,C,D
Explanation:
Explanation/Reference:
Explanation:
C: During the first execution of a SQL statement, an execution plan is generated as usual.
D: if multi-column statistics are not present for the relevant combination of columns, the optimizer can fall back on cardinality feedback.
(not B)* Cardinality feedback. This feature, enabled by default in 11.2, is intended to improve plans for repeated executions.
optimizer_dynamic_sampling
optimizer_features_enable
* dynamic sampling or multi-column statistics allow the optimizer to more accurately estimate selectivity of conjunctive predicates.
Note:
* OPTIMIZER_DYNAMIC_SAMPLING controls the level of dynamic sampling performed by the optimizer.
Range of values. 0 to 10
* Cardinality feedback was introduced in Oracle Database 11gR2. The purpose of this feature is to automatically improve plans for queries that are executed repeatedly, for which the optimizer does not estimate cardinalities in the plan properly. The optimizer may misestimate cardinalities for a variety of reasons, such as missing or inaccurate statistics, or complex predicates. Whatever the reason for the misestimate, cardinality feedback may be able to help.
NEW QUESTION 100
......
Penetration testers simulate 1Z0-060 exam: https://www.briandumpsprep.com/1Z0-060-prep-exam-braindumps.html
