Best Quality 1z0-062 Exam Questions Oracle Test To Gain Brilliante Result!
Preparations of 1z0-062 Exam 2021 Oracle Database Unlimited 380 Questions
NEW QUESTION 101
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? (Choose two.)
- A. Creating a new tablespace with autoextend enabled and changing the default tablespace of the HR user to the new tablespace
- B. Altering the data file associated with the USERStablespace to extend automatically
- C. Changing segment space management for the USERS tablespace to manual
- D. Enabling resumable space allocation by setting the RESUMABLE_TIMEOUT parameter to a nonzero value
- E. Adding a data file to the USERS tablespace
Answer: B,E
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 102
You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema.
Examine the following steps:
1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS ('SH', 'CUSTOMERS') FROM dual statement.
2. Execute the DBMS_STATS.SEED_COL_USAGE (null, 'SH', 500) procedure.
3. Execute the required queries on the CUSTOMERS table.
4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE ('SH', 'CUSTOMERS') FROM dual statement.
Identify the correct sequence of steps.
- A. 3, 2, 1, 4
- B. 3, 2, 4, 1
- C. 2, 3, 4, 1
- D. 4, 1, 3, 2
Answer: C
Explanation:
Step 1 (2). Seed column usage
Oracle must observe a representative workload, in order to determine the appropriate column groups. Using the new procedure DBMS_STATS.SEED_COL_USAGE, you tell Oracle how long it should observe the workload.
Step 2: (3) You don't need to execute all of the queries in your work during this window. You can simply run explain plan for some of your longer running queries to ensure column group information is recorded for these queries.
Step 3. (1) Create the column groups
At this point you can get Oracle to automatically create the column groups for each of the tables based on the usage information captured during the monitoring window. You simply have to call the DBMS_STATS.CREATE_EXTENDED_STATS function for each table.This function requires just two arguments, the schema name and the table name. From then on, statistics will be maintained for each column group whenever statistics are gathered on the table.
Note:
* DBMS_STATS.REPORT_COL_USAGE reports column usage information and records all the SQL operations the database has processed for a given object.
* The Oracle SQL optimizer has always been ignorant of the implied relationships between data columns within the same table. While the optimizer has traditionally analyzed the distribution of values within a column, he does not collect value-based relationships between columns.
* Creating extended statisticsHere are the steps to create extended statistics for related table columns withdbms_stats.created_extended_stats:
1 - The first step is to create column histograms for the related columns.2 - Next, we run dbms_stats.create_extended_stats to relate the columns together.
Unlike a traditional procedure that is invoked via an execute ("exec") statement, Oracle extended statistics are created via a select statement.
NEW QUESTION 103
Your database is in ARCHIVELOG mode.
You want to disable archiving for the database.
Examine these steps:
1. Execute the ALTER DATABASE NOARCHIVELOGcommand
2. Execute SHUTDOWN IMMEDIATE
3. Execute STARTUP MOUNT
4. Set the DB_RECOVERY_FILE_DESTparameter to $ORACLE_HOME/dbs/
5. Execute STARTUP NOMOUNT
6. Open the database
7. Execute SHUTDOWN TRANSACTIONAL
Identify the required steps in the correct sequence.
- A. 2, 3, 1, 6
- B. 4, 2, 5, 1, 6
- C. 1, 2, 3, 4, 6
- D. 2, 5, 1, 6
Answer: D
Explanation:
Explanation/Reference: http://dba-oracle.com/bk_disable_archive_log_mode.htm
NEW QUESTION 104
You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time
FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?
- A. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance
- B. The time when the first flashback operation in our database was performed
- C. The approximate time and the lowest system change number (SCN) to which you can flash back your database
- D. The time when the last flashback operation in your database was performed
Answer: C
NEW QUESTION 105
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 assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
- B. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
- C. Field names should be the first line in the both the SQL* Loader data files.
- D. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
- E. The SQL* Loader operation fails because no record terminators are specified.
Answer: A,B,D
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 106
Which two categories of segments are analyzed by the Automatic Segment Advisor? (Choose two.)
- A. segments that have unusable indexes
- B. segments in tablespaces that have exceeded a critical or warning space threshold
- C. segments that are sparsely populated and have more than 10% of free space below the high water mark.
- D. segments that have the highest growth rate in a database
- E. segments for tables created using ADVANCED ROW COMPRESSION
Answer: B,D
Explanation:
Explanation
References:
http://www.dba-oracle.com/t_segment_advisor_10g.htm
NEW QUESTION 107
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. The valid time columns employee_time_start and employee_time_end are automatically created.
- B. The valid time columns are visible by default when the table is described.
- C. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP
and PERIOD FOR clauses. - D. 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. - E. The valid time columns are not populated by the Oracle Server automatically.
Answer: A,C,D
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 108
DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.
Which two are true? (Choose two.)
- A. PCTFREE can help to minimize row chaining during inserts
- B. 80% of every data block in daily_ords_list is reserved for row inserts
- C. PCTFREE can help reduce row migration during updates
- D. 20% of each data block in the table is reserved for row updates
- E. PCTFREE eliminates row chaining during inserts
Answer: C,D
NEW QUESTION 109
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?
- A. Set DB_FLASH_CACHE_ZISE = 64G.
- B. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.
- C. Set DB_FLASH_CACHE_ZISE = 64G, 64G
- D. Set DB_FLASH_CACHE_ZISE = 128G.
Answer: C
Explanation:
* Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for "Database Smart Flash Cache" area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc
DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by "DB Smart Flash Cache"
/dev/sda - size 32G
/dev/sdb - size 32G
/dev/sdc - size 64G
New view V$FLASHFILESTAT - it's used to determine the cumulative latency and read counts of each file|device and compute the average latency
NEW QUESTION 110
Examine the following parameters for a database instance:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=0
SGA_TARGET=0
PGA_AGGREGATE_TARGET=500m
Which three initialization parameters are not controlled by Automatic Shared Memory Management (ASMM)?
(Choose three.)
- A. DB_KEEP_CACHE_SIZE
- B. JAVA_POOL_SIZE
- C. DB_16K_CACHE_SZIE
- D. SORT_AREA_SIZE
- E. LOG_BUFFER
- F. STREAMS_POOL_SIZE
Answer: A,C,E
Explanation:
Manually Sized SGA Components that Use SGA_TARGET Space
SGA Component, Initialization Parameter
/ The log buffer
LOG_BUFFER
/ The keep and recycle buffer caches
DB_KEEP_CACHE_SIZE
DB_RECYCLE_CACHE_SIZE
/ Nonstandard block size buffer caches
DB_nK_CACHE_SIZE
Note:
* In addition to setting SGA_TARGET to a nonzero value, you must set to zero all initialization parameters listed in the table below to enable full automatic tuning of the automatically sized SGA components.
* Table, Automatically Sized SGA Components and Corresponding Parameters
NEW QUESTION 111
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?
- A. Set DB_FLASH_CACHE_ZISE = 64G.
- B. DB_FLASH_CACHE_SIZE is automatically configured by the instance at startup.
- C. Set DB_FLASH_CACHE_ZISE = 64G, 64G
- D. Set DB_FLASH_CACHE_ZISE = 128G.
Answer: C
Explanation:
* Smart Flash Cache concept is not new in Oracle 12C - DB Smart Flash Cache in Oracle
1 1g.
In this release Oracle has made changes related to both initialization parameters used by
DB Smart Flash cache. Now you can define many files|devices and its sizes for "Database
Smart Flash Cache" area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc
DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by "DB Smart Flash Cache"
/dev/sda - size 32G
/dev/sdb - size 32G
/dev/sdc - size 64G
New view V$FLASHFILESTAT - it's used to determine the cumulative latency and read counts of each file|device and compute the average latency
NEW QUESTION 112
Which three statements are true about server-generated alerts? (Choose three.)
- A. Server-generated alerts notify administrators of problems that cannot be resolved automatically.
- B. Stateful alerts can be queried only from theDBA_ALERT_HISTORYview.
- C. Alerts are not issued for locally managed read-only tablespaces.
- D. When an alert is cleared, it is moved to theDBA_ALERT_HISTORYview.
- E. Response actions cannot be specified for server-generated alerts.
Answer: A,C,D
Explanation:
Referenceshttps://docs.oracle.com/cd/B28359_01/server.111/b28310/schema001.htm#AD
MIN10120
NEW QUESTION 113
Which two resources might be prioritized between competing pluggable databases when creating a multitenant
container database plan (CDB plan) using Oracle Database Resource Manager?
- A. CPU
- B. Parallel server limit
- C. Maximum Idle time
- D. Maximum Undo per consumer group
- E. Local file system I/O
- F. Exadata I/O
Answer: A,B
NEW QUESTION 114
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute
the following commands in the root container:
Which two statements are true? (Choose two.)
- A. The statement for granting a role to a user fails because the CONTAINER clause is not used.
- B. The C # # ROLE1 role is created only in the root database because the container clause is not used.
- C. Privileges are granted to the C##A_ADMIN user only in the root database.
- D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs.
- E. The C # # ROLE1 role is created in the root database and all the PDBs.
Answer: C,E
Explanation:
Explanation/Reference:
Explanation:
* You can include the CONTAINER clause in several SQL statements, such as the CREATE USER,
ALTER USER, CREATE ROLE, GRANT, REVOKE, and ALTER SYSTEM statements.
* * CREATE ROLE with CONTAINER (optional) clause
/CONTAINER = ALL
Creates a common role.
/CONTAINER = CURRENT
Creates a local role in the current PDB.
NEW QUESTION 115
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
- A. Oracle Recovery Manager (RMAN)
- B. Oracle Data Pump
- C. Oracle Real Application Security
- D. Oracle Database Vault
- E. Oracle Label Security
Answer: B
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 116
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 117
Which three statements are true about checkpointing? (Choose three.)
- A. It prompts the Database Writer (DBWn) process to write checkpoint information into data file headers
and the control file. - B. It prompts the Checkpoint (CKPT) process to write data to the data files and redo information to the
online redo log files. - C. Frequent thread checkpoints can degrade database performance.
- D. It reduces the time required for recovery in case of an instance failure.
- E. It ensures that all dirty buffers are written to data files during consistent shutdown.
Answer: C,D,E
NEW QUESTION 118
Your database is configured in ARCHIVELOG mode.
Examine the RMAN configuration parameters:
Examine the command:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
What is the outcome?
- A. It fails because the DELETE INPUT option can be used only with the BACKUP AS COPY command.
- B. It executes successfully and creates a backup set of the database along with archived log files and then deletes the original archived log files.
- C. It executes successfully and creates an image copy of the database along with archive log files and then deletes the original archived log files.
- D. It fails because the DELETE INPUT option can be used only with the BACKUP AS BACKUPSET command.
Answer: B
Explanation:
Explanation
References: https://docs.oracle.com/cd/B13789_01/server.101/b10734/rcmbackp.htm
NEW QUESTION 119
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance
Oracle 11g R2 database to Oracle Database 12c?
- A. copying the listener.ora file to the new ORACLE_HOME
- B. running the Pre-Upgrade Information Tool
- C. executing the catctl.pl script to run the upgrade processes in parallel
- D. shutting down the database instance that is being upgraded
Answer: B
NEW QUESTION 120
Your production database uses file system storage. You want to move storage to Oracle Automatic Storage Management (ASM).
How would you achieve this?
- A. by using RMAN
- B. by using the Database Upgrade Assistant (DBUA)
- C. by using a transportable database
- D. by using Data Pump
Answer: A
Explanation:
Explanation
References:
http://docs.oracle.com/cd/E11882_01/server.112/e18951.pdf (p.184)
NEW QUESTION 121
Identify the access that is initially available to connect to your Database as a Service
(DBaaS) environment.
- A. SSL/TLS on port 443
- B. Cloud Control on port 7799
- C. SSH on port 22
- D. Enterprise Manager on port 1158
- E. telnet on port 23
Answer: C
NEW QUESTION 122
You are using RMAN to back up your database. All the data files are in read/write mode.
Examine the RMAN configuration parameters:
Which two statements are true about a whole consistent backup of a database running in ARCHIVELOG mode? (Choose two.)
- A. The backup consists of blocks that have been formatted.
- B. The database instance must be shut down to take the backup.
- C. The backup can be used as an incremental level 0 backup.
- D. The system Change Number (SCN) is the same for all the data files in the backup.
- E. The database must be in MOUNT state to take the backup.
Answer: B,D
NEW QUESTION 123
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)
- A. The index remains invisible.
- B. The index becomes unusable but the table is updated by the DML.
- C. The index automatically becomes visible in order to have it updated by DML on the table.
- D. The index is not updated by the DML statements on the indexed table.
- E. The index is updated by the DML on the table.
Answer: A,E
Explanation:
Unlike unusable indexes, an invisible index is maintained during DML statements.
Note:
* Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled using the ALTER INDEX command.
NEW QUESTION 124
......
Focus on 1z0-062 All-in-One Exam Guide For Quick Preparation: https://www.itexamreview.com/1z0-062-exam-dumps.html
1z0-062 All-in-One Exam Guide For Quick Preparation: https://drive.google.com/open?id=1n3847ZEAKiHqNqmXfc1NkummDKvpxXBQ
