Ultimate Guide to Prepare 1Z0-060 Certification Exam for Oracle Database in 2021
Use Real 1Z0-060 Dumps - Oracle Correct Answers updated on 2021
NEW QUESTION 32
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:
There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
- A. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
- B. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
- C. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
- D. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
- E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
Answer: A
Explanation:
CREATE DISKGROUP NORMAL REDUNDANCY * For Oracle ASM to mirror files, specify the redundancy level as NORMAL REDUNDANCY (2-way mirroring by default for most file types) or HIGH REDUNDANCY (3-way mirroring for all files).
NEW QUESTION 33
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 connections?
- A. Location of the runtime area for DML and DDL Statements
- B. Persistent area containing bind variable values that are supplied to a SQL statement at run time
- C. Stack space
- D. Location of a part of the runtime area for SELECT statements
- E. User session data
Answer: B,E
NEW QUESTION 34
Examine the query and its output executed In an RDBMS Instance:
Which three statements are true about the users (other than sys) in the output?
- A. The C # # A_ADMINuser can perform wallet operations.
- B. The C # # B_ADMINuser can perform all backup and recovery operations using RMAN only.
- C. The C # # D_ADMINuser can perform backup and recovery operations for Automatic Storage Management (ASM).
- D. The C # # C_ADMINuser can perform the data guard operation with Data Guard Broker.
- E. The C # # B_ADMINuser can perform all backup and recovery operations using RMAN or SQL* Plus.
Answer: C,D,E
Explanation:
Explanation/Reference:
Explanation:
B: SYSDG administrative privilege has ability to perform Data Guard operations (including startup and shutdown) using Data Guard Broker or dgmgrl.
D: SYSASM
The new (introduced in 11g) SYSASM role to manage the ASM instance, variable extent sizes to reduce shared pool usage, and the ability of an instance to read from a specific disk of a diskgroup E (Not A): SYSDBA is like a role in the sense that it is granted, but SYSDBA is a special built-in privilege to allow the DBA full control over the database
Incorrect Answers:
C: SYSKM. SYSKM administrative privilege has ability to perform transparent data encryption wallet operations.
Note:
Use the V$PWFILE_USERS view to see the users who have been granted administrative privileges.
NEW QUESTION 35
A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted?
- A. SYS sessions, regardless of the roles that are set in the session
- B. SCOTT sessions, only if the MGR role is granted to SCOTT
- C. SYSTEM sessions, regardless of the roles that are set in the session
- D. SCOTT sessions, because he is the owner of the table
- E. SYSTEM session, only if the MGR role is set in the session
- F. SCOTT sessions, only if the MGR role is set in the session
Answer: A,B,C
Explanation:
Both users SYS and SYSTEM automatically have the EXEMPT REDACTION POLICY system privilege. (SYSTEM has the EXP_FULL_DATABASE role, which includes the EXEMPT REDACTION POLICY system privilege.) This means that the SYS and SYSTEM users can always bypass any existing Oracle Data Redaction policies, and will always be able to view data from tables (or views) that have Data Redaction policies defined on them
NEW QUESTION 36
In which two scenarios do you use SQL* Loader to load data?
- A. Use transparent parallel processing without having to split the external data first.
- B. Load data into multiple tables during the same load statement.
- C. Transform the data while it is being loaded into the database.
- D. Generate unique sequential key values in specified columns.
Answer: B,D
Explanation:
http://docs.oracle.com/cd/E16655_01/server.121/e17639/ldr_concepts.htm#SUTIL978 SQL*Loader loads data from external files into tables of an Oracle database.
It has a powerful data parsing engine that puts little limitation on the format of the data in the data file.
You can use SQL*Loader to do the following:
Load data across a network if your data files are on a different system than the database.
Load data from multiple data files during the same load session.
Load data into multiple tables during the same load session.
Specify the character set of the data.
Selectively load data (you can load records based on the records'values).
Manipulate the data before loading it, using SQL functions.
Generate unique sequential key values in specified columns.
Use the operating system's file system to access the data files.
Load data from disk, tape, or named pipe.
Generate sophisticated error reports, which greatly aid troubleshooting.
Load arbitrarily complex object-relational data.
Use secondary data files for loading LOBs and collections.
NEW QUESTION 37
You find this query being used in your Oracle 12c database:
Which method is used by the optimizer to limit the rows being returned?
- A. A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows.
- B. A TOP-N query is created to limit the rows to 20 percent of the total rows
- C. All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.
- D. A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.
Answer: D
NEW QUESTION 38
Which three statements are true concerning unplugging a pluggable database (PDB)? (Choose three.)
- A. The PDB data files are automatically removed from disk.
- B. The PDB must be open in read-only mode.
- C. The PDB must be closed.
- D. The unplugged PDB becomes a non-CDB.
- E. The unplugged PDB can be plugged into another CDB.
- F. The unplugged PDB can be plugged into the same multitenant container database (CDB).
Answer: C,E,F
Explanation:
Explanation/Reference: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_unplug_plug/ pdb_unplug_plug.html
NEW QUESTION 39
Which three are true about the large pool for an Oracle database instance that supports shared server connections?
- A. Allocates memory for RMAN backup and restore operations
- B. Allocates memory for shared and private SQL areas
- C. Contains a hash area performing hash joins of tables
- D. Contains stack space
- E. Contains a cursor area for storing runtime information about cursors
Answer: A,B,E
Explanation:
The large pool can provide large memory allocations for the following: / (B)UGA (User Global Area) for the shared server and the Oracle XA interface (used where transactions interact with multiple databases) /Message buffers used in the parallel execution of statements / (A) Buffers for Recovery Manager (RMAN) I/O slaves
Note:
*large pool Optional area in the SGA that provides large memory allocations for backup and restore operations, I/O server processes, and session memory for the shared server and Oracle XA.
*Oracle XA An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database.
*UGA User global area. Session memory that stores session variables, such as logon information, and can also contain the OLAP pool.
*Configuring the Large Pool
Unlike the shared pool, the large pool does not have an LRU list (not D). Oracle Database does not attempt to age objects out of the large pool. Consider configuring a large pool if the database instance uses any of the following Oracle Database features:
*Shared server In a shared server architecture, the session memory for each client process is included in the shared pool.
*Parallel query
Parallel query uses shared pool memory to cache parallel execution message buffers.
*Recovery Manager Recovery Manager (RMAN) uses the shared pool to cache I/O buffers during backup and restore operations. For I/O server processes, backup, and restore operations, Oracle Database allocates buffers that are a few hundred kilobytes in size.
NEW QUESTION 40
You are administering a database stored in Automatic Storage management (ASM). The files are stored in the DATA disk group. You execute the following command:
What is the result?
- A. The file '+data.231.45678' is renamed as 'myfile.dbf', and copied to '+data/prod'.
- B. The file '+data.231.45678' remains in the same location and a synonym 'myfile.dbf' is created.
- C. The file 'myfile.dbf' is created in '+data/prod' and the reference to '+data.231.45678' in the data dictionary removed.
- D. The file '+data.231.45678' is physically relocated to '+data/prod' and renamed as 'myfile.dbf'.
Answer: B
Explanation:
ADD ALIAS
Use this clause to create an alias name for an Oracle ASM filename. The alias_name consists of the full directory path and the alias itself.
NEW QUESTION 41
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. Drop the column using the ALTER TABLE statement.
- B. Disable Flashback Archiving, drop the column unused, and re-enable Flashback Archiving.
- C. 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 - D. Disable Flashback Archiving, set the column unused, and re-enable Flashback Archiving.
- E. 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
Answer: A
NEW QUESTION 42
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 CREATE DATABASE . . . ENABLE PLUGGABLE DATABASE statement to provision a PDB by copying file from the SEED.
- C. Use the DBMS_PDB package to plug an Oracle 12c non-CDB database into an existing CDB.
- 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 clone an existing PDB.
Answer: A,C,E
Explanation:
Use the CREATE PLUGGABLE DATABASE statement to create a pluggable database (PDB).
This statement enables you to perform the following tasks:
* (A) Create a PDB by using the seed as a template
Use the create_pdb_from_seed clause to create a PDB by using the seed in the multitenant container database (CDB) as a template. The files associated with the seed are copied to a new location and the copied files are then associated with the new PDB.
* (C) Create a PDB by cloning an existing PDB
Use the create_pdb_clone clause to create a PDB by copying an existing PDB (the source PDB) and then plugging the copy into the CDB. The files associated with the source PDB are copied to a new location and the copied files are associated with the new PDB. This operation is called cloning a PDB.
The source PDB can be plugged in or unplugged. If plugged in, then the source PDB can be in the same CDB or in a remote CDB. If the source PDB is in a remote CDB, then a database link is used to connect to the remote CDB and copy the files.
* Create a PDB by plugging an unplugged PDB or a non-CDB into a CDB
Use the create_pdb_from_xml clause to plug an unplugged PDB or a non-CDB into a CDB, using an XML metadata file.
NEW QUESTION 43
Which statement is true concerning dropping a pluggable database (PDB)?
- A. The PDB must be open in read-only mode.
- B. The PDB must be unplugged.
- C. The PDB must be in mount state.
- D. A dropped PDB can never be plugged back into a multitenant container database (CDB).
- E. The PDB data files are always removed from disk.
Answer: C
Explanation:
Explanation/Reference:
Explanation:
http://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13658
NEW QUESTION 44
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):
Which three are prerequisites for successful execution of the command? (Choose three.)
- A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
- B. The path of data files on the target database must be the same as that on the source database.
- C. The export dump file must be created before starting the import on the target database.
- D. The impdp operation must be performed by the same user that performed the expdp operation.
- E. All the user-defined tablespaces must be in read-only mode on the source database.
- F. The source and target database must be running on the same platform with the same endianness.
Answer: A,E,F
Explanation:
A - OK
Start SQL*Plus and connect to the target database as the administrator who will transport the database with Data Pump import. This user must have DATAPUMP_IMP_FULL_DATABASE role to transport the database.
During the import operation, the database link must connect to a user on the source database with DATAPUMP_EXP_FULL_DATABASE role. The user on the source database cannot be a user with SYSDBA administrative privilege.
B - OK
Make all of the user-defined tablespaces in the database read-only.
D - OK
The source database and target database are running on the same platform with the same endianness.
http://docs.oracle.com/database/121/ADMIN/transport.htm#ADMIN13873
NEW QUESTION 45
You created an encrypted tablespace:
You then closed the encryption wallet because you were advised that this is secure.
Later in the day, you attempt to create the EMPLOYEEStable in the SECURESPACEtablespace with the SALToption on the EMPLOYEEcolumn.
Which is true about the result?
- A. It generates an error when creating the table because the wallet is closed.
- B. It creates the table successfully but does not encrypt any inserted data in the EMPNAME column because the wallet must be opened to encrypt columns with SALT.
- C. It creates the table successfully, and encrypts any inserted data in the EMPNAME column because the wallet needs to be open only for tablespace creation.
- D. It generates error when creating the table, because the salt option cannot be used with encrypted tablespaces.
Answer: A
Explanation:
http://docs.oracle.com/cd/B28359_01/network.111/b28530/asotrans.htm#CJACFCDG
NEW QUESTION 46
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario?
- A. The database must have multiplexed redo logs for the flashback to succeed.
- B. The database must use block change tracking for the flashback to succeed.
- C. The database must be MOUNTED for the flashback to succeed.
- D. The database must be opened with the RESETLOGS option after the flashback is complete.
- E. The database must be opened in restricted mode for the flashback to succeed.
- F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
Answer: C,D
Explanation:
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmflash.htm#BRADV80055
NEW QUESTION 47
You issue the following commands:
The directories '/u0l/app/oracle/oradata/orcl'and '/u0l/app/oracle/mydata'exist.
Which statement describes the outcome?
- A. The TEMP101tablespace is created with its temp file in the DB_CREATE_FILE_DESTlocation and the AUGUST_SALEStablespace is created with its data file in the '/u01/app/oracle/mydata/ mysales.dbf'location.
- B. The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATEcommands.
- C. Tablespace creation ignores the data file and temp file locations specified in the CREATEcommands, and creates both the tablespaces in the DB_CREATE_FILE_DESTlocation.
- D. The AUGUST_SALEStablespace is created with its data file in the DB_CREATE_FILE_DESTlocation and the TEMP101tablespace is created with its temp file in the '/u01/app/oracle/mydata'location.
Answer: B
NEW QUESTION 48
Examine the parameter for your database instance:
You generated the execution plan for the following query in the plan table and noticed that the nested loop join was done. After actual execution of the query, you notice that the hash join was done in the execution plan:
Identify the reason why the optimizer chose different execution plans.
- A. The optimizer used re-optimization cardinality feedback for the query.
- B. The optimizer chose different plans because automatic dynamic sampling was enabled.
- C. The optimizer chose different plan because extended statistics were created for the columns used.
- D. The optimizer used a dynamic plan for the query.
Answer: B
Explanation:
Explanation/Reference:
Explanation:
* optimizer_dynamic_sampling
OPTIMIZER_DYNAMIC_SAMPLING controls both when the database gathers dynamic statistics, and the size of the sample that the optimizer uses to gather the statistics.
Range of values0 to 11
NEW QUESTION 49
Your multitenant container database, CDB1, is running in ARCHIVELOGmode and has two pluggable databases, HR_PDBand ACCOUNTS_PDB. An RMANbackup exists for the database.
You issue the command to open ACCOUNTS_PDBand find that the USERDATA.DBFdata file for the default permanent tablespace USERDATAbelonging to ACCOUNTS_PDBis corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
- A. Place CDB1 in the mount stage and then take the USERDATAtablespace offline in ACCOUNTS_PDB.
- B. Take the USERDATAtablespace offline in ACCOUNTS_PDB.
- C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb OPEN RESTRICTEDcommand.
- D. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE accounts_pdb CLOSE IMMEDIATEcommand.
Answer: B
Explanation:
Explanation/Reference:
Explanation:
* You can take an online tablespace offline so that it is temporarily unavailable for general use. The rest of the database remains open and available for users to access data. Conversely, you can bring an offline tablespace online to make the schema objects within the tablespace available to database users. The database must be open to alter the availability of a tablespace.
NEW QUESTION 50
Which three statements are true about using flashback database in a multitenant container database (CDB)?
- A. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
- B. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the CDB.
- C. To enable flashback database, the CDB must be mounted.
- D. Individual PDBs can be flashed back without flashing back the entire CDB.
- E. The root container can be flashed back without flashing back the pluggable databases (PDBs).
Answer: A,B,C
NEW QUESTION 51
......
Oracle Database -1Z0-060 Exam-Practice-Dumps: https://www.actual4exams.com/1Z0-060-valid-dump.html