Free Sales Ending Soon - Use Real 1Z0-060 PDF Questions [Jan 09, 2022]
Updated Jan-2022 Exam 1Z0-060 Dumps - Pass Your Certification Exam
Oracle 1Z0-060 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
NEW QUESTION 11
Flashback is enabled for your multitenant container database (CDB), which contains twopluggable 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. 1 and 2
- B. Only 3
- C. Only 2
- D. 3 and 1
- E. Only 1
Answer: B
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;
NEW QUESTION 12
Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)
- A. Pluggable databases are only used for database consolidation.
- B. All administration tasks must be done to a specific pluggable database.
- C. The pluggable databases reduce administration effort.
- D. The pluggable databases increase patching time.
- E. The pluggable databases are patched together.
Answer: A,C
Explanation:
Explanation
The benefits of Oracle Multitenant are brought by implementing a pure deployment choice. The following list calls out the most compelling examples.
* High consolidation density. (E)
The many pluggable databases in a single multitenant container database share its memory and background processes, letting you operate many more pluggable databases on a particular platform than you can single databases that use the old architecture. This is the same benefit that schema-based consolidation brings.
* Rapid provisioning and cloning using SQL.
* New paradigms for rapid patching and upgrades. (D, not B)
The investment of time and effort to patch one multitenant container database results in patching all of its many pluggable databases. To patch a single pluggable database, you simply unplug/plug to a multitenant container database at a different Oracle Database software version.
* (C, not A) Manage many databases as one.
By consolidating existing databases as pluggable databases, administrators can manage many databases as one.
For example, tasks like backup and disaster recovery are performed at the multitenant container database level.
* Dynamic between pluggable database resource management. In Oracle Database 12c, Resource Manager is extended with specific functionality to control the competition for resources between the pluggable databases within a multitenant container database.
Note:
* Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a multitenant container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application.
NEW QUESTION 13
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?
- A. The index remains invisible.
- B. The index is updated by the DML on the table.
- C. The index automatically becomes visible in order to have it updated by DML on the table.
- D. The index becomes unusable but the table is updated by the DML.
- E. The index is not updated by the DML statements on the indexed table.
Answer: A,B
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 14
Your multitenant container database has three pluggable databases (PDBs): PDB1, PDB2, and PDB3.
Which two RMAN commands may be used to back up only the PDB1 pluggable database? (Choose two.)
- A. BACKUP DATABASEwhile connected to the ROOTcontainer
- B. BACKUP PLUGGABLE DATABASE PDB1while connected to PDB2
- C. BACKUP PLUGGABLE DATABASE PDB1while connected to the ROOTcontainer
- D. BACKUP DATABASEwhile connected to the PDB1container
- E. BACKUP PLUGGABLE DATABASE PDB1while connected to the PDB1container
Answer: C,D
Explanation:
Explanation/Reference:
Explanation:
To perform operations on a single PDB, you can connect as target either to the root or directly to the PDB.
* (A) If you connect to the root, you must use the PLUGGABLE DATABASE syntax in your RMAN commands. For example, to back up a PDB, you use the BACKUP PLUGGABLE DATABASE command.
* (C)If instead you connect directly to a PDB, you can use the same commands that you would use when connecting to a non-CDB. For example, to back up a PDB, you would use the BACKUP DATABASE command.
NEW QUESTION 15
To enable the Database Smart Flash Cache, you configure the following parameters:
DB_FLASH_CACHE_FILE = '/dev/flash_device_1' , '/dev/flash_device_2'
DB_FLASH_CACHE_SIZE=64G
What is the result when you start up the database instance?
- A. One 64G flash cache file will be used.
- B. Two 64G flash cache files will be used.
- C. It results in an error because these parameter settings are invalid.
- D. Two 32G flash cache files will be used.
Answer: C
NEW QUESTION 16
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
* Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
* Character Set: AL32UTF8
* National Character Set: AL16UTF16
* O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
* Version: Oracle Database 12c Release 1 64-bit
* Character Set: AL32UTF8
* National Character Set: AL16UTF16
* O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
- A. Transportable tablespace
- B. The DBMS_PDB package
- C. Data Pump full export/import
- D. Transportable database
- E. RMAN
Answer: A
Explanation:
Transportable tablespaces were introduced in Oracle 8i to allow whole tablespaces to be copied between databases in the time it takes to copy the datafiles. It is supported in Oracle 11g.
Incorrect Answers:
A: Using Transportable database with the "FULL=Y TRANSPORTABLE=ALWAYS VERSION=12" parameters allows you to plug in an 11.2.0.3 or later non-CDB 11g database, not an 11.2.0.2.0 database.
D: The DBMS_PDB package allows you to generate an XML metadata file from a non-CDB 12c database. This allows the non-CDB to be plugged in as a PDB into an existing CDB. However, the non-CBD is an 11g (11.2.0.2.0) database.
NEW QUESTION 17
Examine the contents of SQL loader control file:
Which three statements are true regarding the SQL* Loader operation performed using the control file?
- 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. An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data.
- C. The SQL* Loader data file myfile1.dat has the column names for the EMP table.
- D. The SQL* Loader operation fails because no record terminators are specified.
- E. Field names should be the first line in the both the SQL* Loader data files.
Answer: A,B,C
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 18
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 schema stats are gathered.
- B. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.
- C. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
- D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.
- E. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.
Answer: B,C,D
Explanation:
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 19
The tnsnames.ora file has an entry for the service alias ORCL as follows:
The TNSPING command executes successfully when tested with ORCL; however, from the same OS user session, you are not able to connect to the database instance with the following command:
SQL > CONNECT scott/tiger@orcl
What could be the reason for this?
- A. The listener is running on a different port.
- B. The orcl.oracle.com database service is not registered with the listener.
- C. The TNS_ADMINenvironment variable is set to the wrong value.
- D. The listener is not running on the database node.
- E. The DEFAULT_DOMAINparameter is set to the wrong value in the sqlnet.orafile.
Answer: B
Explanation:
Service registration enables the listener to determine whether a database service and its service handlers are available. A service handler is a dedicated server process or dispatcher that acts as a connection point to a database. During registration, the LREG process provides the listener with the instance name, database service names, and the type and addresses of service handlers. This information enables the listener to start a service handler when a client request arrives.
NEW QUESTION 20
You notice that the elapsed time for an important database scheduler job is unacceptably long.
The job belongs to a scheduler job class and runs in a scheduler window.
Which two actions could reduce the job's elapsed time? (Choose two.)
- A. increasing the value of the JOB_QUEUE_PROCESSES parameter
- B. increasing resource allocation for the consumer group mapped to the job class in the resource manager plan associated with the scheduler window
- C. increasing the priority of the scheduler window to which the job belongs
- D. increasing the job's relative priority within the job class to which it belongs
- E. moving the job to an existing higher priority scheduler window with the same schedule and duration
- F. increasing the priority of the job class to which the job belongs
Answer: B,D
Explanation:
Explanation
http://www.dba-oracle.com/job_scheduling/job_classes.htm
http://docs.oracle.com/database/121/ADMIN/schedover.htm#i1106396
NEW QUESTION 21
Which three statements are true about Oracle Data Pump export and import operations?
- A. The master table is the last object to be exported by the data pump.
- B. Data pump uses parallel execution server processes to implement parallel import.
- C. You can detach from a data pump import job and reattach later.
- D. Data pump import requires the import file to be in a directory owned by the oracle owner.
- E. You can detach from a data pump export job and reattach later.
Answer: A,C,E
Explanation:
A - E - TRUE
When a Datapump Export or Import session is launched, a Datapump Job is automatically started.
This way, we can -> detach from and reattach to long-running jobs without affecting the job itself.
D - TRUE
At the end of an export job, the content of the master table is written to a file in the dump file set.
NEW QUESTION 22
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
- A. Configure Automata Shared Memory Management.
- B. Configure the RECYCLE buffer pool and alter the table with the corresponding storage clause.
- C. Increase the database buffer cache size.
- D. Configure the KEEP buffer pool and alter the table with the corresponding storage clause.
- E. Configure Automatic Memory Management-
Answer: D
Explanation:
Explanation
Schema objects are referenced with varying usage patterns; therefore, their cache behavior may be quite different. Multiple buffer pools enable you to address these differences. You can use a KEEP buffer pool to maintain objects in the buffer cache and a RECYCLE buffer pool to prevent objects from consuming unnecessary space in the cache. When an object is allocated to a cache, all blocks from that object are placed in that cache. Oracle maintains a DEFAULT buffer pool for objects that have not been assigned to one of the buffer pools.
NEW QUESTION 23
You use a recovery catalog for maintaining your database backups.
You execute the following command:
Which two statements are true? (Choose two.)
- A. Checks are performed to confirm whether all database files exist in correct locations
- B. Checks are performed for physical corruptions.
- C. Backup sets containing both data files and archive logs are created.
- D. Checks are performed for logical corruptions.
- E. Corrupted blocks, if any, are repaired.
Answer: A,B
Explanation:
Explanation
B (not C): You can validate that all database files and archived redo logs can be backed up by running a command as follows:
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;
This form of the command would check for physical corruption. To check for logical corruption, RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL; D: You can use the VALIDATE keyword of the BACKUP command to do the following:
Check datafiles for physical and logical corruption
Confirm that all database files exist and are in the correct locations.
Note:
You can use the VALIDATE option of the BACKUP command to verify that database files exist and are in the correct locations (D), and have no physical or logical corruptions that would prevent RMAN from creating backups of them. When performing a BACKUP...VALIDATE, RMAN reads the files to be backed up in their entirety, as it would during a real backup. It does not, however, actually produce any backup sets or image copies (Not A, not E).
NEW QUESTION 24
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. 1 and 2
- B. Only 3
- C. Only 2
- D. 3 and 1
- E. Only 1
Answer: B
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;
NEW QUESTION 25
Which three operations can be performed as multipartition operations in Oracle?
- A. Move partitions of a range-partitioned table
- B. Drop partitions of a list partitioned table
- C. Merge partitions of a list partitioned table
- D. Merge partitions of a reference partitioned index
- E. Coalesce partitions of a hash-partitioned global index.
- F. Rename partitions of a range partitioned table
Answer: B,C,D
Explanation:
Multipartition maintenance enables adding, dropping, truncate, merge, split operations on multiple partitions.
A:Merge Multiple Partitions:
The new "ALTER TABLE ... MERGE PARTITIONS " help merge multiple partitions or subpartitions with a single statement. When merging multiple partitions, local and global index operations and semantics for inheritance of unspecified physical attributes are the same for merging two partitions.
B:Drop Multiple Partitions:
The new "ALTER TABLE ... DROP PARTITIONS " help drop multiple partitions or subpartitions with a single statement.
Example:
view plaincopy to clipboardprint?
SQL> ALTER TABLE Tab_tst1 DROP PARTITIONS
Tab_tst1_PART5, Tab_tst1_PART6, Tab_tst1_PART7;
Table altered
SQL>
Restrictions :
-You can't drop all partitions of the table.
-If the table has a single partition, you will get the error: ORA-14083: cannot drop the only partition of a partitioned.
NEW QUESTION 26
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 as part of a package and grant users the EXECUTE privilege the package.
- B. Create the CREATE_TEST procedure with definer's rights.
- C. Create the CREATE_TEST procedure with invoker's rights.
- D. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
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 27
You plan to use the Flashback Drop feature to recover the SALES_EMP table that was dropped in error.
No other table with the same name exists in the SH schema, which owns the table.
You query the RECYCLEBIN and find multiple entries for the SALES_EMP table:
You then issue this statement to recover the table:
What would be the best?
- A. It retrieves the most recently dropped version of the table from the recycle bin for which indo is still available.
- B. It retrieves the least recently dropped version of the table from the recycle bin for which undo is still available.
- C. It retrieves the most recently dropped version of the table.
- D. It returns an error because the table name in the OBJECT_NAMEcolumn is not specified.
- E. It retrieves the least recently dropped version of the table.
Answer: B
NEW QUESTION 28
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again? (Choose two.)
- A. Increase the number of ASMB processes.
- B. Increase the value of the ASM_POWER_LIMIT parameter.
- C. Specify the statement that adds the disk back to the disk group.
- D. Increase the number of DBWR_IO_SLAVES in the ASM instance.
- E. Set the DISK_REPAIR_TIME disk attribute to a lower value.
Answer: B,C
Explanation:
Explanation
ASM_POWER_LIMIT specifies the maximum power on an Automatic Storage Management instance for disk rebalancing. The higher the limit, the faster rebalancing will complete. Lower values will take longer, but consume fewer processing and I/O resources.
Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing operations.
References:
http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG10070
NEW QUESTION 29
......
1Z0-060 Dumps To Pass Oracle Database Exam in One Day : https://www.prep4king.com/1Z0-060-exam-prep-material.html
