[Jan-2022] Latest 1Z0-060 Exam Dumps for Pass Guaranteed
Reliable Oracle Database 1Z0-060 Dumps PDF Jan 10, 2022 Recently Updated Questions
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 60
You issue the following command to alter the country column in the departments table:
Which statement is true?
- A. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table.
- B. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'.
- C. It produces an error because column definitions cannot be altered to add default values.
- D. It produces an error because the data type for the column is not specified.
Answer: B
NEW QUESTION 61
Which statement is true concerning compression during an Online Datafile Move?
- A. Only tables may be compressed during the Online Datafile Move.
- B. Uncompressed data files may be moved online to compress the entire file with Hybrid Columnar Compression.
- C. The DBA may choose which objects In the datafile to be moved get compressed.
- D. If an object is already compressed in the source location, then the compression type for that object remains unchanged after the move.
- E. All objects In a data file to be moved will always be be compressed.
Answer: B
NEW QUESTION 62
You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC? (Choose three.)
- A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
- B. ASM disk groups with ASM disks consisting of any zero-padded NFS-mounted files
- C. Database files stored in ZFS and accessed using conventional NFS mounts.
- D. Database files stored in any file system and accessed using the Oracle Direct NFS feature
- E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
- F. ASM disk groups with ASM disks consisting of LUNs on any Storage Area Network array
- G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
Answer: A,E,G
Explanation:
Explanation/Reference:
Explanation:
HCC requires the use of Oracle Storage - Exadata (A), Pillar Axiom (G) or Sun ZFS Storage Appliance (ZFSSA).
Note:
* Hybrid Columnar Compression, initially only available on Exadata, has been extended to support Pillar Axiom and Sun ZFS Storage Appliance (ZFSSA) storage when used with Oracle Database Enterprise Edition 11.2.0.3 and above
* Oracle offers the ability to manage NFS using a feature called Oracle Direct NFS (dNFS). Oracle Direct NFS implements NFS V3 protocol within the Oracle database kernel itself. Oracle Direct NFS client overcomes many of the challenges associated with using NFS with the Oracle Database with simple configuration, better performance than traditional NFS clients, and offers consistent configuration across platforms.
NEW QUESTION 63
Which statement is true concerning dropping a pluggable database (PDB)?
- A. The PDB data files are always removed from disk.
- B. The PDB must be open in read-only mode.
- C. The PDB must be in mount state.
- D. The PDB must be unplugged.
- E. A dropped PDB can never be plugged back into a multitenant container database (CDB).
Answer: D
NEW QUESTION 64
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?
- A. A DBAcancheck specific tables with the DMU
- B. The DMU can report columns that are not represented in the converted characterset.
- C. The DMU can report columns that are too long in the converted characterset.
- D. The database to be migrated must be opened read-only.
- E. The release of the database to be converted can be any release since 9.2.0.8.
Answer: A,B,C
Explanation:
A:In certain situations, you may want to exclude selected columns or tables
from
scanning or conversion steps of the migration process.
D:Exceed column limit
The cell data will not fit into a column after conversion.
E:Need conversion
The cell data needs to be converted, because its binary representation in the
target character set is different than the representation in the current character
set, but neither length limit issues nor invalid representation issues have been
found.
*Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation
migration tool providing an end-to-end solution for migrating your databases from legacy
encodings to Unicode.
Incorrect:
Not C:The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or
later.
NEW QUESTION 65
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
What are three possible causes for the latch-related wait events?
- A. The buffers are being read into the buffer cache, but some other session is changing the buffers.
- B. There are frequent logons and logoffs.
- C. Cursors are not being shared.
- D. A large number COMMITSare being performed.
- E. The size of the shared pool is too small.
Answer: A,C,E
NEW QUESTION 66
Examine the following command:
ALTER SYSTEM SET enable_ddl_logging=FALSE;
Which statement is true?
- A. None of the data definition language (DDL) statements are logged in the trace file.
- B. Only the DDL commands that resulted in errors are logged in the alert log file.
- C. Only the DDL commands that resulted in the creation of new database files are logged in a separate diagnostic directory.
- D. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
Answer: A
Explanation:
Explanation
ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL alert log.
The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL statements issued by the database. The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter is set to true. When this parameter is set to false, DDL statements are not included in any log.
NEW QUESTION 67
You are administering a database and you receive a requirement to apply the following restrictions:
1.A connection must be terminated after four unsuccessful login attempts by user.
2.A user should not be able to create more than four simultaneous sessions.
3.User session must be terminated after 15 minutes of inactivity.
4.Users must be prompted to change their passwords every 15 days.
How would you accomplish these requirements?
- A. by granting a secure application role to the users
- B. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
- C. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
- D. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
- E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.
Answer: A
Explanation:
You can design your applications to automatically grant a role to the user who is
trying to log in, provided the user meets criteria that you specify. To do so, you create a secure
application role, which is a role that is associated with a PL/SQL procedure (or PL/SQL package
that contains multiple procedures). The procedure validates the user: if the user fails the
validation, then the user cannot log in. If the user passes the validation, then the procedure grants
the user a role so that he or she can use the application. The user has this role only as long as he
or she is logged in to the application. When the user logs out, the role is revoked.
Incorrect:
Not B: REMOTE_OS_AUTHENT specifies whether remote clients will be authenticated with the
value of the OS_AUTHENT_PREFIX parameter.
Not C, not E: SEC_MAX_FAILED_LOGIN_ATTEMPTS specifies the number of authentication
attempts that can be made by a client on a connection to the server process. After the specified
number of failure attempts, the connection will be automatically dropped by the server process.
Not D: REMOTE_LOGIN_PASSWORDFILE specifies whether Oracle checks for a password file.
Values:
shared
One or more databases can use the password file. The password file can contain SYS as well as
non-SYS users.
exclusive
The password file can be used by only one database. The password file can contain SYS as well
as non-SYS users.
none
Oracle ignores any password file. Therefore, privileged users must be authenticated by the
operating system.
Note:
The REMOTE_OS_AUTHENT parameter is deprecated. It is retained for backward compatibility
only.
NEW QUESTION 68
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKMprivilege to the password file?
- A. Grant SYSBACKUP, SYSDG, and SYSKMprivileges to the intended users.
- B. Re-create the password file with SYSBACKUP, SYSDG, and SYSKMprivilege, and FORCEarguments set to Yes.
- C. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
- D. Re-create the password file in the Oracle Database 12c format.
- E. Re-create the password file with SYSBACKUP, SYSDG, and SYSKMprivilege and the FORCEargument set to No.
Answer: A,B
Explanation:
* orapwd
/ You can create a database password file using the password file creation utility, ORAPWD.
The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}]
[DBUNIQUENAME=dbname] [FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}]
[SYSKM={y|n}] [DELETE={y|n}] [INPUT_FILE=input-fname]
force - whether to overwrite existing file (optional),
* v$PWFILE_users
/ 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.
/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges Incorrect Answers:
E: The format of the v$PWFILE_users file is already in 12c format.
NEW QUESTION 69
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? (Choose two.)
- A. It contains the usernames and passwords of users for whom auditing is enabled.
- B. It is used by Oracle to authenticate users for remote database administration.
- C. It records the usernames and passwords of users when granted the DBA role.
- D. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
- E. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
Answer: B,D
NEW QUESTION 70
Which two statements are true about the Oracle Direct Network File system (DNFS)? (Choose two.)
- A. It utilizes the OS file system cache.
- B. Direct NFS is available only in UNIX platforms.
- C. Direct NFS can load-balance I/O traffic across multiple network adapters.
- D. Oracle Disk Manager can manage NFS on its own, without using the operating kernel NFS driver.
- E. A traditional NFS mount is not required when using Direct NFS.
Answer: C,D
Explanation:
Explanation
E: Performance is improved by load balancing across multiple network interfaces (if available).
Note:
* To enable Direct NFS Client, you must replace the standard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.
NEW QUESTION 71
You plan to drop the column of a table that has Flashback Archiving enabled.
You want to ensure minimal service disruption.
How would you do this in your Oracle 12c Database?
- A. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
- B. Drop the column using the ALTER TABLE statement.
- C. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.
- D. Disassociate the Flashback Archive using the
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, drop the column, and re- associate the Flashback Archive using the procedure.
DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA - E. Disassociate the Flashback Archive using the
DBMS_FLASHBACK_ARCHIVE.DISASSOCIATE_FBA procedure, set the column unused, and re-associate the Flashback Archive using the procedure.
DBMS_FLASHBACK_ARCHIVE.RESASSOCIATE_FBA
Answer: B
NEW QUESTION 72
Which three SQL statements would display the value 1890.55 as $1, 890.55?
- A. Option E
- B. Option D
- C. Option B
- D. Option A
- E. Option C
Answer: A,B,D
NEW QUESTION 73
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces are created by default in HR_PDB?
- A. EXAMPLE
- B. TEMP
- C. SYSTEM
- D. SYSAUX
- E. UNDO
- F. USERS
Answer: A,C,D
Explanation:
*A PDB would have its SYSTEM, SYSAUX, TEMP tablespaces.It can also contains other user created tablespaces in it. * *Oracle Database creates both the SYSTEM and SYSAUX tablespaces as part of every database.
*tablespace_datafile_clauses
Use these clauses to specify attributes for all data files comprising the SYSTEM and
SYSAUX tablespaces in the seed PDB.
Incorrect:
Not D:a PDB can not have an undo tablespace. Instead, it uses the undo tablespace
belonging to the CDB.
Note:
* Example: CONN pdb_admin@pdb1
SELECT tablespace_name FROM dba_tablespaces;
TABLESPACE_NAME
SYSTEM SYSAUX TEMP USERS
SQL>
NEW QUESTION 74
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?
- 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: A,B
Explanation:
A: 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.
D:
*Normally a separate process is fired up to do that rebalance. This will take a certain amount of time. If you want it to happen faster, fire up more processes. You tell ASM it can add more processes by increasing the rebalance power.
*ASMB ASM Background Process Communicates with the ASM instance, managing storage and providing statistics
Incorrect:
Not B: A higher, not a lower, value of DISK_REPAIR_TIME would be helpful here.
Not E: If you implement database writer I/O slaves by setting the DBWR_IO_SLAVES parameter,
you configure a single (master) DBWR process that has slave processes that are subservient to it.
In addition, I/O slaves can be used to "simulate" asynchronous I/O on platforms that do not
support asynchronous I/O or implement it inefficiently. Database I/O slaves provide non-blocking,
asynchronous requests to simulate asynchronous I/O.
NEW QUESTION 75
Identify two situations in which the alert log file is updated.
- A. Creating a table returns ORA-00955: name us already in used by an existing objects.
- B. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.
- C. Inserting a value into a table returns ORA-01722: invalid number.
- D. Running a query on a table returns ORA-600: Internal Error.
- E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
Answer: D,E
Explanation:
The alert log is a chronological log of messages and errors, and includes the following items:
*All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
*Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
*Messages and errors relating to the functions of shared server and dispatcher processes
*Errors occurring during the automatic refresh of a materialized view
*The values of all initialization parameters that had nondefault values at the time the database and instance start Note:
*The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc.
This file should constantly be monitored to detect
unexpected messages and corruptions.
NEW QUESTION 76
Which three operations can be performed as multipartition operations in Oracle Database 12c? (Choose three.)
- A. Merge partitions of a reference-partitioned index.
- B. Rename partitions of a range partitioned table.
- C. Merge partitions of a list partitioned table.
- D. Move partitions of a range-partitioned table.
- E. Coalesce partitions of a hash-partitioned global index.
- F. Drop partitions of a list partitioned table.
Answer: A,C,F
Explanation:
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:
NEW QUESTION 77
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 78
Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOGmode. An RMAN backup exists for the databases.
You issue the following commands and get an error:
Examine the following commands:
Identify two correct sequences of commands to perform a recovery and make the data available.
- A. 1,2,3,4,7,8
- B. 10,3,4,8,9
- C. 1,2,5,6,7,8
- D. 1,2,10,5,6,9
Answer: C,D
NEW QUESTION 79
......
Latest 2022 Realistic Verified 1Z0-060 Dumps: https://www.passexamdumps.com/1Z0-060-valid-exam-dumps.html
