Latest 1z0-062 Pass Guaranteed Exam Dumps Certification Sample Questions
New 1z0-062 Test Materials & Valid 1z0-062 Test Engine
The Oracle 1Z0-062 is one of the two certification exams that you need to pass in order to get the Oracle Database 12c Administrator Certified Associate certificate. The second test is 1Z0-071. The target audience for this exam is those individuals who want to prove their skills in fundamental database terminologies and concepts to guide vital functions for businesses, processes, and systems.
NEW QUESTION 138
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:
Which two statements are true about redefining the table?
- A. VPD policies are copied from the original table to the new table during online redefinition.
- B. You must copy the VPD policies manually from the original table to the new table during online redefinition.
- C. All the triggers for the table are disabled without changing any of the column names or column types in the table.
- D. The primary key constraint on the EMPLOYEES table is disabled during redefinition.
Answer: A,D
Explanation:
C (not D): CONS_VPD_AUTO Used to indicate to copy VPD policies automatically
*DBMS_RLS.ADD_POLICY / The DBMS_RLS package contains the fine-grained access control administrative interface, which is used to implement Virtual Private Database (VPD).DBMS_RLS is available with the Enterprise Edition only.
*CONS_USE_PK and CONS_USE_ROWID are constants used as input to the "options_flag"
parameter in both the START_REDEF_TABLE Procedure and CAN_REDEF_TABLE Procedure. CONS_USE_ROWID is used to indicate that the redefinition should be done using rowids while CONS_USE_PK implies that the redefinition should be done using primary keys or pseudo-primary keys (which are unique keys with all component columns having NOT NULL constraints).
*DBMS_REDEFINITION.START_REDEF_TABLE
To achieve online redefinition, incrementally maintainable local materialized views are used.
These logs keep track of the changes to the master tables and are used by the materialized views
during refresh synchronization.
*START_REDEF_TABLE Procedure
Prior to calling this procedure, you must manually create an empty interim table (in the same
schema as the table to be redefined) with the desired attributes of the post-redefinition table, and
then call this procedure to initiate the redefinition.
Note:
NEW QUESTION 139
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?
- A. logical corruption of data that is caused by a wrong transaction
- B. loss of all the copies of the control file
- C. abnormal termination of the database instance
- D. loss of data files that belong to theSYSTEMtablespace
- E. loss of all the inactive online redo log group members
- F. loss of a data file that belongs to the active undo tablespace
Answer: B,E,F
NEW QUESTION 140
The HR user receives the following error while inserting data into the sales table:
On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error?
- A. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value
- B. Altering the data file associated with the USERS tablespace to ex automatically
- C. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace
- D. Changing segment space management for the USERS tablespace to manual
- E. Adding a data file to the USERS tablespace
Answer: B,C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 141
Which two statements correctly describe the relationship between data files and logical database structures?
- A. The size of an Oracle data blockin a data file should be the same as the size of an OS block.
- B. A data file can belong to only one tablespace.
- C. An extent cannot span data files.
- D. A segment cannot span data files.
Answer: B,C
Explanation:
References:
NEW QUESTION 142
Which two statements are true about resumable space allocation? (Choose two.)
- A. SELECTstatements that run out of temporary space for sort areas are candidates for resumable execution.
- B. A database-level LOGONtrigger can be used to automatically configure resumable statement settings for individual sessions.
- C. Resumable space allocation does not apply when a database instance uses asynchronous commit.
- D. Free space in a segment is automatically reclaimed when a resumable statement is suspended because of an out-of-space condition.
- E. Resumable space allocation does not apply when users exceed their assigned space quota in a tablespace.
- F. A resumable statement can be suspended and resumed only once during a session.
Answer: A,B
Explanation:
Explanation
NEW QUESTION 143
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The
application has multiple modules. You enable tracing at the service level by executing the following command:
SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE ('SRV1');
The possible outcome and actions to aggregate the trace files are as follows:
1. The command fails because a module name is not specified.
2. A trace file is created for each session that is running the SRV1 service.
3. An aggregated trace file is created for all the sessions that are running the SRV1 service.
4. The trace files may be aggregated by using the trcess utility.
5. The trace files be aggregated by using the tkprof utility.
Identify the correct outcome and the step to aggregate by using tkprof utility?
- A. 2 and 5
- B. 0
- C. 3 and 4
- D. 2 and 4
- E. 3 and 5
Answer: D
Explanation:
Tracing information is present in multiple trace files and you must use the trcsess tool to collect it into a single file.
Incorrect:
Not 1: Parameter service_name
Name of the service for which tracing is enabled.
module_name
Name of the MODULE. An optional additional qualifier for the service.
Note:
* The procedure enables a trace for a given combination of Service, MODULE and ACTION name. The specification is
strictly hierarchical: Service Name or Service Name/MODULE, or Service Name, MODULE, and ACTION name must be
specified. Omitting a qualifier behaves like a wild-card, so that not specifying an ACTION means all ACTIONs. Using
the ALL_ACTIONS constant achieves the same purpose.
* SERV_MOD_ACT_TRACE_ENABLE Procedure
This procedure will enable SQL tracing for a given combination of Service Name, MODULE and ACTION globally unless
an instance_name is specified.
* DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(
service_name IN VARCHAR2,
module_name IN VARCHAR2 DEFAULT ANY_MODULE,
action_name IN VARCHAR2 DEFAULT ANY_ACTION,
waits IN BOOLEAN DEFAULT TRUE,
binds IN BOOLEAN DEFAULT FALSE,
instance_name IN VARCHAR2 DEFAULT NULL);
NEW QUESTION 144
You want to create a role that:
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package
How would you create this role?
- A. with external authentication
- B. with global authentication
- C. withdefiner's rights
- D. as a secure application role
Answer: D
Explanation:
References:https://docs.oracle.com/cd/B28359_01/network.111/b28531/authorization.htm#
DBSEG97973
NEW QUESTION 145
You execute the commands:
Which two statements are true? (Choose two.)
- A. The user Sidneycan connect to the database instance but cannot perform sort operations because no space quota is specified for the temptablespace.
- B. The user Sidneyis created and authenticated by the operating system.
- C. The create usercommand fails if any role with the name Sidney exists in the database.
- D. The user Sidneycan connect to the database instance but requires relevant privileges to create objects in the userstablespace.
- E. The user Sidneyis created but cannot connect to the database instance because no profile is assigned to the user.
Answer: C,D
Explanation:
Explanation/Reference:
References:
NEW QUESTION 146
A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
- A. SCOTT sessions, because he is the owner of the table
- B. SYSTEM sessions, regardless of the roles that are set in the session
- C. SYS sessions, regardless of the roles that are set in the session
- D. SCOTT sessions, only if the MGR role is set in the session
- E. SYSTEM session, only if the MGR role is set in the session
- F. SCOTT sessions, only if the MGR role is granted to SCOTT
Answer: B,C,F
NEW QUESTION 147
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 fails because DB_CACHE_SIZE is a static initialization parameter.
- B. It fails because ASMM is enabled and individual SGA components cannot be sized.
- C. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next
instance startup. - D. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.
Answer: D
NEW QUESTION 148
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 aprogram 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 149
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. The value is changed only in the PFILE and takes effect at the next instance startup.
- B. The value is changed for the current instance and in the PFILE.
- C. Change is applied to the current instance, but does not persist after instance restart.
- D. It fails because the SCOPE clause is missing.
Answer: C
NEW QUESTION 150
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
- A. configuration of unified auditing mode
- B. usage of the AUDIT statement
- C. creation of a fine-grained audit policy
- D. execution of SQL statements by users connected with the SYSDBA privilege
Answer: D
Explanation:
References
https://docs.oracle.com/cd/B28359_01/network.111/b28531/auditing.htm#DBSEG0622
NEW QUESTION 151
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?
- A. Restart the database instance.
- B. Re-enable redaction policies that use FULL data redaction.
- C. Flush the shared pool.
- D. Re-create redaction policies that use FULL data redaction.
- E. Re-connect the sessions that access objects with redaction policies defined on them.
Answer: A
Explanation:
About Altering the Default Full Data Redaction Value
You can alter the default displayed values for full Data Redaction polices. By default, 0 is the redacted value when Oracle Database performs full redaction (DBMS_REDACT.FULL) on a column of the NUMBER data type. If you want to change it to another value (for example, 7), then you can run the DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES procedure to modify this value.
The modification applies to all of the Data Redaction policies in the current database instance. After you modify a value, you must restart the database for it to take effect.
Note:
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* UPDATE_FULL_REDACTION_VALUES Procedure
This procedure modifies the default displayed values for a Data Redaction policy for full redaction.
* After you create the Data Redaction policy, it is automatically enabled and ready to redact data.
* Oracle Data Redaction enables you to mask (redact) data that is returned from queries issued by low-privileged users or applications. You can redact column data by using one of the following methods:
/ Full redaction.
/ Partial redaction.
/ Regular expressions.
/ Random redaction.
/ No redaction.
References:
NEW QUESTION 152
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? (Choose three.)
- A. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
- B. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
- C. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.
- D. The C # # A_ADMIN user can perform wallet operations.
- E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
Answer: A,B,C
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:
Not 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 153
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 CUSTOMERS table when database stats are gathered.
- B. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
- C. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
- D. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.
- E. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
Answer: B,C,E
Explanation:
Explanation/Reference:
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 154
Examine the command:
SQL> CONNECT hr/hr@orcl
Which two configurations allow this command to execute successfully? (Choose two.)
- A. The SERVICE_NAMES initialization parametershould contain the name orcl in the database host.
- B. The orcl TNS alias should be defined such that it is resolvable by a client running on the database host.
- C. The TNS_ADMIN environment variable should be set to orcl on the client.
- D. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name.
- E. The orcl TNS alias should be defined in the tnsnames.ora file on both the client and the database host.
Answer: A,B
NEW QUESTION 155
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the ORCL1 and ORCL2 databases
both have their instances running.
Which two statements are true?
- A. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added
to the Oracle Restart configuration. - B. The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.
- C. Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.
- D. The crsctl start has command must be used to start software services for Oracle Automatic Storage Management
(ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete. - E. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
Answer: B,E
NEW QUESTION 156
Your database is configured in ARCHIVELOGmode.
Examine the RMAN configuration parameters:
Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which two are true? (Choose two.)
- A. It creates a backupset of archive log files
- B. It fails because the DELETE INPUToption can be used only with the BACKUP AS BACKUPSETcommand
- C. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPYcommand
- D. It creates image copies of the archivelogs
- E. It creates image copies of the database files
Answer: B,D
NEW QUESTION 157
You want to prevent a group of users in your database from performing long-running transactions that
consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during
execution of a data manipulation language (DML) statement, the operation should abort and return an
error. However, queries should still be allowed, even if users have exceeded the undo space limitation.
How would you achieve this?
- A. Implement a profile for these users.
- B. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users
perform transactions. - C. Specify the maximum amount of quota a user can be allocated in the undo tablespace.
- D. Implement a Database Resource Manager plan.
Answer: D
NEW QUESTION 158
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. 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. - 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 Performance Analyzer (SPA) on
the workload captured in the STS. - D. Run the Automatic Workload Repository Monitor (ADDM).
Answer: A
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.
References:
NEW QUESTION 159
Which two are true concerning a multitenant container database with three pluggable database?
- A. Pluggable databases are only used for database consolidation.
- B. The pluggable databases increase patching time.
- C. The pluggable databases are patched together.
- D. The pluggable databases reduce administration effort.
- E. All administration tasks must be done to a specific pluggable database.
Answer: A,C
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 160
Examine the contents of SQL loader control file:
Which three statements are true regarding the SQL* Loader operation performed using the control file?
(Choose three.)
- A. The SQL* Loader operation fails because no record terminators are specified.
- B. Field names should be the first line in the both the SQL* Loader data files.
- C. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the
loaded data. - D. The SQL* Loader operation assumes that the file must be a stream record format file with the normal
carriage return string as the record terminator. - E. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
Answer: C,D,E
Explanation:
Explanation/Reference:
Explanation:
A: The APPEND keyword tells SQL*Loader to preserve any preexisting data in the table. Other options
allow you to delete preexisting data, or to fail with an error if the table is not empty to begin with.
B (not D):
Note:
* SQL*Loader-00210: first data file is empty, cannot process the FIELD NAMES record
Cause: The data file listed in the next message was empty. Therefore, the FIELD NAMES FIRST FILE
directive could not be processed.
Action: Check the listed data file and fix it. Then retry the operation
E:
* A comma-separated values (CSV) (also sometimes called character-separated values, because the
separator character does not have to be a comma) file stores tabular data (numbers and text) in plain-text
form. Plain text means that the file is a sequence of characters, with no data that has to be interpreted
instead, as binary numbers. A CSV file consists of any number of records, separated by line breaks of
some kind; each record consists of fields, separated by some other character or string, most commonly a
literal comma or tab. Usually, all records have an identical sequence of fields.
* Fields with embedded commas must be quoted.
Example:
1997,Ford,E350,"Super, luxurious truck"
Note:
* SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database.
NEW QUESTION 161
You set the following parameters in the parameter file and restart the database instance:
Which two statements are true? (Choose two.)
- A. The value of the MEMORY_MAX_TARGET parameter remains zero for the database instance.
- B. The instance does not start up because Automatic Memory Management (AMM) is enabled but PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to nonzero values.
- C. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
- D. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
- E. The lower limits of the PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB respectively.
Answer: C,E
NEW QUESTION 162
Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.)
- A. ALTER TABLE TRUNCATE PARTITION
- B. ALTER TABLE DROP PARTITION
- C. ALTER TABLE ADD PARTITION
- D. ALTER TABLE MOVE PARTITION
- E. ALTER TABLE SPLIT PARTITION
- F. ALTER TABLE MERGE PARTITION
Answer: A,B
Explanation:
Explanation/Reference:
Explanation:
Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION
This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.
NEW QUESTION 163
......
Oracle 1Z0-062 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 exams:
- 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.
- 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.
- Navigate the Oracle 12c Questions using the “Previous” and “Next” buttons.
- Take a look at the progress bar at the top; it will tell how you are progressing throughout the exam.
- 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-062 exam dumps on-line Simulator.
- 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.
1z0-062 Sample with Accurate & Updated Questions: https://examcollection.dumpsvalid.com/1z0-062-brain-dumps.html