Upgrade to Oracle Database 12c
Question No: 41
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?
The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
The C # # A_ADMIN user can perform wallet operations.
The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
Answer: B,D,E Explanation:
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
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
Not C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.
Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.
Question No: 42
You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor?
It may advise the use of online table redefinition for tables in dictionary managed tablespace.
It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
It may advise the use of online table redefinition for tables in locally managed
It will detect and advise about chained rows.
It may advise the use of segment shrink for free list managed tables.
Explanation: (http://docs.oracle.com/database/121/ADMIN/schema.htm#ADMIN11601) The Segment Advisor generates the following types of advice:
If the Segment Advisor determines that an object has a significant amount of free space, it recommends online segment shrink. If the object is a table that is not eligible for shrinking, as in the case of a table in a tablespace without automatic segment space management, the Segment Advisor recommends online table redefinition.
If the Segment Advisor determines that a table could benefit from compression with the advanced row compression method, it makes a recommendation to that effect. (Automatic Segment Advisor only. See quot;Automatic Segment Advisorquot;.)
If the Segment Advisor encounters a table with row chaining above a certain threshold, it records that fact that the table has an excess of chained rows.
Question No: 43
Examine these two statements:
Which three are true about the MRKT tablespace?
The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
The MRKT tablespace may be dropped if it has no contents.
Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
No more data files can be added to the tablespace.
The relative file number of the tablespace is not stored in rowids for the table rows that
are stored in the MRKT tablespace.
Question No: 44
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 gt; REVOKE create table FROM C # # A_ADMIN; What is the result?
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
It fails and reports an error because the CONTAINER=ALL clause is not used.
It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
It fails and reports an error because the CONTAINER=CURRENT clause is not used.
It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
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: Oracle Database SQL Language Reference 12c, Revoke
Question No: 45
You notice that the performance of your production 24/7 Oracle database significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?
Enable Memory Access Mode, which reads performance data from SGA.
Use emergency monitoring to fetch data directly from SGA analysis.
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
Run ADDM in diagnostic mode.
Question No: 46
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?
The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
All the components may be moved into SYSAUX tablespace.
All the components may be moved from the SYSAUX tablespace.
Answer: A,B Explanation:
Question No: 47
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
Create a policy to capture the privilege used by a user for privilege analysis.
Generate a report with the data captured for a specified privilege capture.
Start analyzing the data captured by the policy.
Revoke the unused privileges.
Compare the used and unused privileges’ lists.
Stop analyzing the data.
Identify the correct sequence of steps.
A. 1, 3, 5, 6, 2, 4
B. 1, 3, 6, 2, 5, 4
C. 1, 3, 2, 5, 6, 4
D. 1, 3, 2, 5, 6, 4
E. 1, 3, 5, 2, 6, 4
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.
Revoke the unused privileges.
Question No: 48
A new report process containing a complex query is written, with high impact on the database. You want to collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.
For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and the CONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC TUNING.
What should you do to accomplish this task?
Execute the query and view Active Session History (ASH) for information about the query.
Enable SQL trace for the query.
Create a database operation, execute the query, and use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the report.
Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
Explanation: The REPORT_SQL_MONITOR function is used to return a SQL monitoring report for a specific SQL statement.
Not A: Not interested in session statistics, only in statistics for the particular SQL query. Not B: We are interested in statistics, not tracing.
Not D: SET_SESSION_LONGOPS Procedure
This procedure sets a row in the V$SESSION_LONGOPS view. This is a view that is used to indicate the on-going progress of a long running operation. Some Oracle functions, such as parallel execution and Server Managed Recovery, use rows in this view to indicate the status of, for example, a database backup.
Applications may use the SET_SESSION_LONGOPS procedure to advertise information on the progress of application specific long running tasks so that the progress can be monitored by way of the V$SESSION_LONGOPS view.
Question No: 49
You Execute the Following command to create a password file in the database server:
$ orapwd file = ‘ DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file?
It records the usernames and passwords of users when granted the DBA role.
It contains the usernames and passwords of users for whom auditing is enabled.
Is used by Oracle to authenticate users for remote database administration.
It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
Question No: 50
Which three statements are true about Oracle Data Pump export and import operations?
You can detach from a data pump export job and reattach later.
Data pump uses parallel execution server processes to implement parallel import.
Data pump import requires the import file to be in a directory owned by the oracle owner.
The master table is the last object to be exported by the data pump.
You can detach from a data pump import job and reattach later.
100% Ensurepass Free Download!
–Download Free Demo:1z0-060 Demo PDF
100% Ensurepass Free Guaranteed!
–Download 2018 EnsurePass 1z0-060 Full Exam PDF and VCE
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|