Electrical power Pass4sure Oracle documentation 1Z0-062 exam inquiries and various check preparation products, the method that you combine your own fascination uncomplicated. Pass4sure 1Z0-062 check serp downloads available, inquiries, the best check the answers and various products to provide you a detailed in addition to sensible stories 1Z0-062 Oracle exam plans, offering an absolute check environment, these items depend on this kind of experience on your the actual 1Z0-062 check features on the items( 1Z0-062 ) examiner.
2021 Feb 1Z0-062 exams
Q31. Which two statements are true?
A. A role cannot be assigned external authentication.
B. A role can be granted to other roles.
C. A role can contain both system and object privileges.
D. The predefined resource role includes the unlimited_tablespace privilege.
E. All roles are owned by the sys user.
F. The predefined connect role is always automatically granted to all new users at the time of their creation.
Answer: B,C
Reference: http://docs.oracle.com/cd/E11882_01/network.112/e36292/authorization.htm#DBSEG9987
8 (the functionality of roles)
Q32. Which two statements are true about the logical storage structure of an Oracle database?
A. An extent contains data blocks that are always physically contiguous on disk.
B. An extent can span multiple segments,
C. Each data block always corresponds to one operating system block.
D. It is possible to have tablespaces of different block sizes.
E. A data block is the smallest unit of I/O in data files.
Answer: B,D
Reference: http://docs.oracle.com/cd/E11882_01/server.112/e40540/logical.htm#CNCPT250
Q33. A user establishes a connection to a database instance by using an Oracle Net connection. You want to ensure the following:
1. The user account must be locked after five unsuccessful login attempts.
2. Data read per session must be limited for the user.
3- The user cannot have more than three simultaneous sessions.
4. The user must have a maximum of 10 minutes session idle time before being logged off automatically.
How would you accomplish this?
A. by granting a secure application role to the user
B. by implementing Database Resource Manager
C. by using Oracle Label Security options
D. by assigning a profile to the user
Answer: D
Q34. You plan to create a database by using the Database Configuration Assistant (DBCA), with the following specifications:
Applications will connect to the database via a middle tier.
The number of concurrent user connections will be high.
The database will have mixed workload, with the execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
A. a General Purpose database template with default memory allocation
B. a Data Warehouse database template, with the dedicated server mode option and AMM enabled
C. a General Purpose database template, with the shared server mode option and Automatic Memory Management (AMM) enabled
D. a default database configuration
Answer: C
Reference: http://www.oracledistilled.com/oracle-database/administration/creating-a-database-using-database-configuration-assistant/
Q35. You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name.
What must this name be made up of?
A. It must be made up of a database name and a domain name.
B. It must be made up of the value in ORACLE_SID and HOSTNAME.
C. It must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.
D. It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.
Answer: A
Explanation: Using the DBCA to Create a Database (continued)
3. Database Identification: Enter the Global Database Name in The form database_name.domain_name, and the system identifier (SID). The SID defaults lo the database name and uniquely identifies the instance associated with the database.
4. Management Options: Use this page to set up your database so that it can be managed with Oracle Enterprise Manager. Select the default: "Configure the Database with Enterprise Manager." Optionally, this page allows you to configure alert notifications and daily disk backup area settings.
Note: Yon must configure the listener before you can configure Enterprise Manager (as shown earlier).
Avant-garde 1Z0-062 exam:
Q36. Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges?
A. Bind Variable Peeking
B. SQL Plan Baselines
C. Adaptive Cursor Sharing
D. Bind variable used in a SQL statement
E. Literals in a SQL statement
Answer: A,C,E
Explanation: * In bind variable peeking (also known as bind peeking), the optimizer looks at the value in a bind variable when the database performs a hard parse of a statement.
When a query uses literals, the optimizer can use the literal values to find the best plan. However, when a query uses bind variables, the optimizer must select the best plan without the presence of literals in the SQL text. This task can be extremely difficult. By peeking at bind values the optimizer can determine the selectivity of a WHERE clause condition as if literals had been used, thereby improving the plan.
C: Oracle 11g/12g uses Adaptive Cursor Sharing to solve this problem by allowing the server to compare the effectiveness of execution plans between executions with different bind variable values. If it notices suboptimal plans, it allows certain bind variable values, or ranges of values, to use alternate execution plans for the same statement. This functionality requires no additional configuration.
Q37. 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 flashback back schema?
A. Only 1
B. Only 2
C. Only 3
D. 3 and 1
E. 1 and 2
Answer: C
Explanation: Example (see step23):
Step 1:
Run the RMAN FLASHBACK DATABASE command.
You can specify the target time by using a form of the command shown in the following
examples:
FLASHBACK DATABASE TO SCN 46963;
FLASHBACK DATABASE
TO RESTORE POINT BEFORE_CHANGES;
FLASHBACK DATABASE TO TIME
"TO_DATE('09/20/05','MM/DD/YY')";
When the FLASHBACK DATABASE command completes, the database is left mounted and recovered to the specified target time.
Step 2:
Make the database available for updates by opening the database with the RESETLOGS option. If the database is currently open read-only, then execute the following commands in SQL*Plus:
SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE OPEN RESETLOGS;
Q38. Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?
A. ALTER TABLE SPLIT PARTITION
B. ALTER TABLE MERGE PARTITION
C. ALTER TABLE TRUNCATE PARTITION
D. ALTER TABLE ADD PARTITION
E. ALTER TABLE DROP PARTITION
F. ALTER TABLE MOVE PARTITION
Answer: C,E
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.
Reference: Oracle Database VLDB and Partitioning Guide 12c
Q39. Examine the parameters for your database instance:
NAMETYPE VALUE
undo_management string AUTO
undo_retentioninteger 12 00
undo_tablespace string UNDOTBS1
You execute the following command:
SQL> ALTER TABLESPACE undotbs1 RETENTION NOGUARANTEE;
Which statement is true in this scenario?
A. Undo data is written to flashback logs after 1200 seconds.
B. Inactive undo data is retained for 1200 seconds even if subsequent transactions fail due to lack of space in the undo tablespace.
C. You can perform a Flashback Database operation only within the duration of 1200 seconds.
D. An attempt is made to keep inactive undo for 1200 seconds but transactions may overwrite the undo before that time has elapsed.
Answer: A
Q40. Which two tasks can be performed on an external table?
A. partitioning the table
B. creating an invisible index
C. updating the table by using an update statement
D. creating a public synonym
E. creating a view
Answer: C,D