[Nov-2021] 1Z0-060 Pre-Exam Practice Tests | Exam Questions and Answers for Oracle Database Study Guide
Upgrade to Oracle Database 12c Certification Sample Questions
NEW QUESTION 15
Your multitenant container database (CDB) contains three pluggable database (PDBs). You find that the control file is damaged. You plan to use RMAN to recover the control file. There are no startup triggers associated with the PDBs.
Which three steps should you perform to recover the control file and make the database fully operational?
- A. Recover each pluggable database.
- B. Mount the container database (CDB) and restore the control file from the control file auto backup.
- C. Recover and open the CDB in NORMAL mode.
- D. Start the database instance in the nomount stage and restore the control file from control file auto backup.
- E. Mount the CDB and then recover and open the database, with the RESETLOGS option.
- F. Open all the pluggable databases.
Answer: D,E,F
Explanation:
Step 1: F Step 2: D Step 3: C: If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVERcommand, even if no data files have been restored, and open the database with the RESETLOGS option.
Note:
* RMAN and Oracle Enterprise Manager Cloud Control (Cloud Control) provide full support for backup and recovery in a multitenant environment. You can back up and recover a whole multitenant container database (CDB), root only, or one or more pluggable databases (PDBs).
NEW QUESTION 16
Which three statements are true about the working of system privileges in a multitenant control database (CDB) that has pluggable databases (PDBs)?
- A. System privileges apply only to the PDB in which they are used.
- B. Local users cannot use local system privileges on the schema of a common user.
- C. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
- D. The granter of system privileges must possess the set container privilege.
- E. Common users connected to a PDB can exercise privileges across other PDBs.
Answer: A,C,D
Explanation:
A, Not D:In a CDB, PUBLIC is a common role. In a PDB, privileges granted locally to PUBLIC enable all local and common users to exercise these privileges in this PDB only.
C:A user can only perform common operations on a common role, for example, granting privileges commonly to the role, when the following criteria are met:
The user is a common user whose current container is root.
The user has the SET CONTAINER privilege granted commonly, which means that the
privilege applies in all containers.
The user has privilege controlling the ability to perform the specified operation, and this
privilege has been granted commonly
Incorrect:
Note:
*Every privilege and role granted to Oracle-supplied users and roles is granted commonly
except for system privileges granted to PUBLIC, which are granted locally.
NEW QUESTION 17
You executed startup restrict foe a multitenant container database (CDB) containing several LUGGABLE databases (PDBs).
You then attempt an alter PLUGGABLE database PDBI open for a PDB called PDB1.
What is the result?
- A. PDB1 opens read-only with restricted sessions enabled.
- B. PDB1 opens read/write with restricted sessions disabled.
- C. PDB1 opens read-only with restricted sessions disabled.
- D. PDBI opens read/write with restricted sessions enabled.
- E. The statement will fail because PDBs may not be opened read write when the CDB is In restricted session mode.
Answer: E
NEW QUESTION 18
You upgraded yourdatabase frompre-12cto a multitenantcontainer database (CDB) containingpluggable databases (PDBs).
Examine the query and its output:
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?
- A. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
- B. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
- C. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
- D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to Yes.
- E. Re-create the password file in the Oracle Database 12c format.
Answer: A,C
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:
not E: The format of the v$PWFILE_users file is already in 12c format.
NEW QUESTION 19
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. Grant the EXECUTE privilege to users with GRANT OPTION on the CREATE_TEST procedure.
- C. Create the CREATE_TEST procedure with definer's rights.
- D. Create the CREATE_TEST procedure with invoker's rights.
Answer: D
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 20
Which four actions are possible during an Online Data file Move operation?
- A. Flashing back the database
- B. Performing file shrink of the data file being moved
- C. Querying tables in the data file being moved
- D. Performing Block Media Recovery for a data block in the data file being moved
- E. Creating and dropping tables in the data file being moved
- F. Executing DML statements on objects stored in the data file being moved
Answer: C,D,E,F
Explanation:
Block Media Recovery can be done while the data file was moved...and Media Recovery is not possible.
"The good news is that Oracle 12cR1 now offers the ability to move entire datafiles between different storage locations without ever having to take the datafiles offline. The datafiles being moved remain completely accessible to applications in almost all situations, including querying against or performing DML and DDL operations against existing objects, creating new objects, and even rebuilding indexes online. Online Move Datafile (OMD) also makes it possible to migrate a datafile between non-ASM and ASM storage (or vice-versa) while maintaining transparent application access to that datafile's underlying database objects. OMD is completely compatible with online block media recovery, the automatic extension of a datafile, the modification of a tablespace between READ WRITE and READ ONLY mode, and it even permits backup operations to continue against any datafiles that are being moved via this feature."
http://muhammad-asif-dba.blogspot.com.br/2013/11/oracle-12c-database-online-move- datafile.html
NEW QUESTION 21
Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)
- A. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
- B. The file system directions that are specified by OMF parameters are created automatically.
- C. OMF automatically creates unique file names for table spaces and control files.
- D. OMF cannot be used in a database that already has data files created with user-specified directions.
- E. OMF may affect the location of the redo log files and archived log files.
Answer: C,E
Explanation:
Explanation/Reference:
Explanation:
D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:
Tablespaces
Redo log files
Control files
Archived logs
Block change tracking files
Flashback logs
RMAN backups
Note:
* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle-managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle-managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace's datafile with the DATAFILE clause.
References: http://www.oracle-base.com/articles/9i/oracle-managed-files.php
http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm
NEW QUESTION 22
Which three statements are true about using flashback database in a multitenant container database (CDB)?
- A. To enable flashback database, the CDB must be mounted.
- B. The root container can be flashed back without flashing back the pluggable databases (PDBs).
- C. Individual PDBs can be flashed back without flashing back the entire CDB.
- D. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
- E. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
Answer: A,D,E
NEW QUESTION 23
You are planning the creation of a new multitenant container database (CDB) and want to store the ROOTand SEEDcontainer data files in separate directories.
You plan to create the database using SQL statements.
Which three techniques can you use to achieve this? (Choose three.)
- A. Specify the SEED FILE_NAME_CONVERTclause.
- B. Specify the PDB_FILE_NAME_CONVERTinitialization parameter.
- C. Specify the DB_FILE_NAME_CONVERTinitialization parameter.
- D. Specify all files names in the CREATE DATABASEstatement without using Oracle managed Files (OMF).
- E. Use Oracle Managed Files (OMF).
Answer: A,B,E
Explanation:
You must specify the names and locations of the seed's files in one of the following ways:
* (A) Oracle Managed Files
* (B) The SEED FILE_NAME_CONVERT Clause
* (C) The PDB_FILE_NAME_CONVERT Initialization Parameter
NEW QUESTION 24
You issue the following command to alter the country column in the departments table:
Which statement is true?
- A. It executes successfully and all the rows that have a null value for the country column will be updated with the value 'USA'.
- B. It produces an error because the data type for the column is not specified.
- C. It produces an error because column definitions cannot be altered to add default values.
- D. It executes successfully. The modification to add the default value takes effect only from subsequent insertions to the table.
Answer: A
NEW QUESTION 25
Identify two valid options for adding a pluggable database (PDB) to an existing multitenant container database (CDB).
- A. Use the CREATE PLUGGABLE DATABASE statement to create a PDB using the files from the SEED.
- B. Use the DBMS_PDB package to clone an existing PDB.
- C. Use the CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
- D. Use the DBMS_PDB package to plug an Oracle 11 g Release 2 (11.2.0.3.0) non-CDB database into an existing CDB.
- E. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
Answer: A,E
NEW QUESTION 26
You configure your database Instance to support shared server connections.
Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?
- A. User session data
- B. Stack space
- C. Location of a part of the runtime area for SELECT statements
- D. Private SQL area
- E. Location of the runtime area for DML and DDL Statements
Answer: B
Explanation:
* PGA memory allocation depends on whether the database uses dedicated or shared server connections.
Note:
*System global area (SGA) The SGA is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA is shared by all server and background processes. Examples of data stored in the SGA include cached data blocks and shared SQL areas.
*Program global area (PGA)
A PGA is a memory region that contains data and control information for a server process. It is nonshared memory created by Oracle Database when a server process is started. Access to the PGA is exclusive to the server process. There is one PGA for each server process. Background processes also allocate their own PGAs. The total memory used by all individual PGAs is known as the total instance PGA memory, and the collection of individual PGAs is referred to as the total instance PGA, or just instance PGA. You use database initialization parameters to set the size of the instance PGA, not individual PGAs.
Reference: Oracle Database Concepts 12c
NEW QUESTION 27
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges granted to users:
1. Create a policy to capture the privilege used by a user for
privilege analysis.
2. Generate a report with the data captured for a specified privilege
capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.
- A. 1, 3, 5, 2, 6, 4
- B. 1, 3, 6, 2, 5, 4
- C. 1, 3, 2, 5, 6, 4
- D. 1, 3, 5, 6, 2, 4
- E. 1, 3, 2, 5, 6, 4
Answer: B
Explanation:
http://docs.oracle.com/database/121/DVADM/priv_analysis.htm#DVADM1013
Define the privilege analysis policy.
Enable the privilege analysis policy.
This step begins recording the privilege use that the policy defined.
Disable the privilege analysis policy's recording of privilege use.
This step stops capturing the privilege use for the policy.
Generate privilege analysis results.
This step writes the results to the data dictionary views described in "Privilege Analysis Policy and Report Data Dictionary Views".
Optionally, disable and then drop the privilege analysis policy.
Dropping a privilege analysis policy deletes the data captured by the policy.
NEW QUESTION 28
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 in mount state.
- C. The PDB must be unplugged.
- D. The PDB must be open in read-only mode.
- E. A dropped PDB can never be plugged back into a multitenant container database (CDB).
Answer: B
Explanation:
Explanation/Reference:
Explanation:
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658
NEW QUESTION 29
You notice a high number of waits for the db file scattered read and db file sequential read events in the recent Automatic Database Diagnostic Monitor (ADDM) report. After further investigation, you find that queries are performing too many full table scans and indexes are not being used even though the filter columns are indexed.
Identify three possible reasons for this.
- A. Oversized buffer cache
- B. Undersized shared pool
- C. High value for the DB_FILE_MULTIBLOCK_READ_COUNTparameter
- D. Missing or stale histogram statistics
- E. High clustering factor for the indexes
Answer: C,D,E
Explanation:
Explanation/Reference:
Explanation:
D: DB_FILE_MULTIBLOCK_READ_COUNT is one of the parameters you can use to minimize I/O during table scans. It specifies the maximum number of blocks read in one I/O operation during a sequential scan.
The total number of I/Os needed to perform a full table scan depends on such factors as the size of the table, the multiblock read count, and whether parallel execution is being utilized for the operation.
NEW QUESTION 30
You are connected to a pluggable database (PDB) as a common user with DBA privileges.
The STATISTICS_LEVEL parameter is PDB_MODIFIABLE. You execute the following:
SQL > ALTER SYSTEM SET STATISTICS_LEVEL = ALL SID = `*' SCOPE = SPFILE; Which is true about the result of this command?
- A. The STATISTICS_LEVEL parameter is set to all whenever this PDB is re-opened.
- B. The STATISTICS_LEVEL parameter is set to all whenever the multitenant container database (CDB) is restarted.
- C. The STATISTICS_LEVEL parameter is set to ALL whenever any PDB is reopened.
- D. Nothing happens; because there is no SPFILE for each PDB, the statement is ignored.
Answer: A
Explanation:
SPFILE The initialization parameter setting is changed for the PDB in the SPFILE. The new setting takes effect in any of the following cases:
The PDB is closed and re-opened.
The CDB is shut down and re-opened.
In these cases, the new setting affects only the PDB.
http://docs.oracle.com/database/121/ADMIN/cdb_pdb_admin.htm#ADMIN14017
NEW QUESTION 31
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)
- A. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
- B. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
- C. The ASM compatibility attribute controls the format of the disk group metadata.
- D. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.
- E. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
Answer: B,C,E
Explanation:
Explanation
A, D: The value for the disk group COMPATIBLE.ASM attribute determines the minimum software version for an Oracle ASM instance that can use the disk group. This setting also affects the format of the data structures for the Oracle ASM metadata on the disk.
B: The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
For example, if the COMPATIBLE initialization parameters of the databases are set to either 11.1 or 11.2, then COMPATIBLE.RDBMS can be set to any value between 10.1 and 11.1 inclusively.
NEW QUESTION 32
Oracle Data Redaction is active on the SCOTT.EMPtable.
You queried the table twice.
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;
SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;
Which is guaranteed to be true concerning the redaction policy?
- A. FULL redaction is active on the SALcolumn
- B. RANDOM redaction is active on the HIREDATE column
- C. PARTIAL redaction is active on the MGRcolumn.
- D. RANDOM redaction is active on the MGR column
- E. PARTIAL redaction is active of the HIREDATEcolumn.
Answer: A
Explanation:
Explanation
NEW QUESTION 33
......
Oracle 1Z0-060 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 tests:
- 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.
- Read the question and select only the answer(s) you think are correct by checking the corresponding check box.
- Take a look at the progress bar at the top; it will tell how you are progressing throughout the exam.
- 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.
- Start now our 1Z0-060 dumps on-line Simulator.
- Navigate the Oracle 12c Questions using the “Previous” and “Next” buttons.
- 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.
- 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.
Oracle Exam Practice Test To Gain Brilliante Result: https://www.vceengine.com/1Z0-060-vce-test-engine.html
