Upgrade to Oracle Database 12c
Question No: 31
An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges.
A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE
Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?
You can conned as a common user by using the connect statement.
You can connect as a local user by using the connect statement.
You can connect by using easy connect.
You can connect by using OS authentication.
You can connect by using a Net Service name.
You can connect as a local user by using the SET CONTAINER statement.
Answer: A,C,D,E Explanation:
Question No: 32
What are three purposes of the RMAN “FROM” clause?
to support PUSH-based active database duplication
to support synchronization of a standby database with the primary database in a Data environment
To support PULL-based active database duplication
To support file restores over the network in a Data Guard environment
To support file recovery over the network in a Data Guard environment
Answer: B,D,E Explanation: DE:
With a control file autobackup, RMAN can recover the database even if the current control file, recovery catalog, and server parameter file are inaccessible.
RMAN uses a recovery catalog to track filenames for all database files in a Data Guard environment. A recovery catalog is a database schema used by RMAN to store metadata about one or more Oracle databases. The catalog also records where the online redo logs, standby redo logs, tempfiles, archived redo logs, backup sets, and image copies are created.
Question No: 33
You run a script that completes successfully using SQL*Plus that performs these actions:
Creates a multitenant container database (CDB)
Plugs in three pluggable databases (PDBs)
Shuts down the CDB instance
Starts up the CDB instance using STARTUP OPEN READ WRITE Which two statements are true about the outcome after running the script?
The seed will be in mount state.
The seed will be opened read-only.
The seed will be opened read/write.
The other PDBs will be in mount state.
The other PDBs will be opened read-only.
The PDBs will be opened read/write.
Explanation: B: The seed is always read-only.
D: Pluggable databases can be started and stopped using SQL*Plus commands or the ALTER PLUGGABLE DATABASE command.
Question No: 34
You execute the following piece of code with appropriate privileges:
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?
Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
Data is never redacted for the EMP_V.SAL column.
Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
Answer: A,C Explanation: Note:
DBMS_REDACT.FULL completely redacts the column data.
DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported.
The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence.
Question No: 35
Identify three benefits of Unified Auditing.
Decreased use of storage to store audit trail rows in the database.
It improves overall auditing performance.
It guarantees zero-loss auditing.
The audit trail cannot be easily modified because it is read-only.
It automatically audits Recovery Manager (RMAN) events.
Question No: 36
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions
The table has a local prefixed, range partitioned index.
Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions.
This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month.
You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned.
Which three methods could transparently help to achieve this result?
Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column.
Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
Question No: 37
You created a new database using the quot;create databasequot; statement without specifying the quot;ENABLE PLUGGABLEquot; clause.
What are two effects of not using the quot;ENABLE PLUGGABLE databasequot; clause?
The database is created as a non-CDB and can never contain a PDB.
The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).
The database is created as a non-CDB and can never be plugged into a CDB.
The database is created as a non-CDB but can be plugged into an existing CDB.
The database is created as a non-CDB but will become a CDB whenever the first PDB is
Explanation: A (not B,not E): The CREATE DATABASE … ENABLE PLUGGABLE DATABASE SQL statement creates a new CDB. If you do not specify the ENABLE PLUGGABLE DATABASE clause, then the newly created database is a non-CDB and can never contain PDBs.
D: You can create a PDB by plugging in a Non-CDB as a PDB. The following graphic depicts the options for creating a PDB:
Description of cncpt358.png follows Incorrect:
Not E: For the duration of its existence, a database is either a CDB or a non-CDB. You cannot transform a non-CDB into a CDB or vice versa. You must define a database as a CDB at creation, and then create PDBs within this CDB.
Question No: 38
Which three are true about the large pool for an Oracle database instance that supports shared server connections?
Allocates memory for RMAN backup and restore operations
Allocates memory for shared and private SQL areas
Contains a cursor area for storing runtime information about cursors
Contains stack space
Contains a hash area performing hash joins of tables
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
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.
An external interface that allows global transactions to be coordinated by a transaction manager other than Oracle Database.
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:
In a shared server architecture, the session memory for each client process is included in the shared pool.
Parallel query uses shared pool memory to cache parallel execution message buffers.
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.
Question No: 39
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:
SQL gt; ALTER DISKGROUP data ADD ALIAS ‘ data/prod/myfile.dbf’ FOR ‘
What is the result?
The file ‘ data.231.54769’ is physically relocated to ‘ data/prod’ and renamed as ‘myfile.dbf’.
The file ‘ data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘ data/prod’.
The file ‘ data.231.54769’ remains in the same location and a synonym #39;myfile.dbf#39; is created.
The file ‘myfile.dbf’ is created in ‘ data/prod’ and the reference to ‘ data.231.54769’ in the data dictionary removed.
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.
Question No: 40
To implement Automatic Management (AMM), you set the following parameters:
When you try to start the database instance with these parameter settings, you receive the
following error message:
SQL gt; startup
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings, see alert log for more information.
Identify the reason the instance failed to start.
The PGA_AGGREGATE_TARGET parameter is set to zero.
The STATISTICS_LEVEL parameter is set to BASIC.
Both the SGA_TARGET and MEMORY_TARGET parameters are set.
The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
Answer: B Explanation: Example:
SQLgt; startup force
ORA-00824: cannot set SGA_TARGET or MEMORY_TARGET due to existing internal settings
ORA-00848: STATISTICS_LEVEL cannot be set to BASIC with SGA_TARGET or MEMORY_TARGET
100% Free Download!
–Download Free Demo:1z0-060 Demo PDF
100% Pass Guaranteed!
–Download 2018 Latesttests 1z0-060 Full Exam PDF and VCE
Latesttests ExamCollection Testking Lowest Price Guarantee Yes No No Up-to-Dated Yes No No Real Questions Yes No No Explanation Yes No No PDF VCE Yes No No Free VCE Simulator Yes No No Instant Download Yes No No