Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Question No: 81
Which three statements are true about Oracle Restart?
It can be configured to automatically attempt to restart various components after a hardware or software failure.
While starting any components, it automatically attempts to start all dependencies first and in properorder.
It can be configured to automatically restart a database in case of normal shutdown of the database instance.
It can be used to only start Oracle components.
It runs periodic check operations to monitor the health of Oracle components.
Question No: 82
You created a database with DBCA by using one of the Oracle supplied templates. Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
Answer: A Explanation:
This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.
Question No: 83
You are administering a multitenant container database (CDB) cdb1 that has multiple pluggable databases (PDBs). As the sys user on cdb$root, you execute the commands:
SQLgt; CREATE USER C##ADMIN IDENTIFIED BY orc1123;
SQLgt; GRANT CREATE SESSION to C##ADMIN CONTAINER=ALL; SQLgt; GRANT CREATE USER TO C##ADMIN CONTAINER=ALL;
Which two statements are true about the c##admin user that is created in all PDBs?
It can create only local users in all the PDBs.
It has a common schema for all the PDBs.
It can create common users only when it is logged in to the CDB.
It can create only local users in the CDB.
It can be granted only common roles in the PDBs.
Question No: 84
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want toensure the following:
i.Long-running queries are not affected. ii.No extra space is used.
Data manipulation language (DML) operations on the table succeed at all times throughout theprocess.
Unused space is reclaimed both above and below the high water mark. Which alter TABLE option would you recommend?
SHRINK SPACE CASCADE
SHRINK SPACE COMPACT
ROW STORE COMPRESS BASIC
Question No: 85
SQLgt; ALTER SESSION SET RECYCLBIN = ON;
SQLgt; DROP TABLE emp; -(First EMP table) Total dropped.
SQLgt; CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:
SQLgt; DROP TABLE emp; – (Second EMP table) Table dropped.
SQLgt; FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?
It recovers the structure, data, and indexes of the first emp table.
It recovers only the structure of the second emp table.
It returns an error because two tables with the same name exist in the recycle bin.
It recovers the structure, data, and indexes of the second emp table.
Question No: 86
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameterto YYYY-MM- DD. The default format of which two data types would be affected by this setting?
INTERVAL YEAR TO MONTH
INTERVAL DAY TO SECOND
TIMESTAMP WITH LOCAL TIME ZONE
Question No: 87
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it.
This consumes a lot of undo tablespace and is affecting undo retention. Which two actions would you take to solve this problem?
Enable temporary undo for the database.
Enable undo retention guarantee.
Increase the size of the redo log buffer.
Enable Automatic Memory Management (AMM).
Increase the size of the temporary tablespace.
Question No: 88
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter: DB_FLASH_CACHE_FILE= ‘ /dev/f lash_device_1′,’ /dev/f lash_device_2′ How should the D3_flash_cache_size be configured to use both devices?
Set D3_FLASH_CACHE_SIZE=64G, 64G.
db_flash_cache_SI2E is automatically configuredby the instance at startup.
Explanation: * Smart Flash Cache concept is not new in Oracle 12C – DB Smart Flash Cache in Oracle 11g.
In this release Oracle has made changes related to both initialization parameters used by DB Smart Flash cache. Now you can define many files|devices and its sizes for “Database Smart Flash Cache” area. In previous releases only one file|device could be defined.
DB_FLASH_CACHE_FILE = /dev/sda, /dev/sdb, /dev/sdc DB_FLASH_CACHE_SIZE = 32G, 32G, 64G
So above settings defines 3 devices which will be in use by “DB Smart Flash Cache”
/dev/sda – size 32G
/dev/sdb – size 32G
/dev/sdc – size 64G
New view V$FLASHFILESTAT – it’s used to determine the cumulative latency and read counts of each file|device and compute the average latency
Question No: 89
Examine the command to back up the ASM metadata: ASMCMDgt;md_backup /backup/ASM_backup
In which three situations can you use the backup?
when one or more disks in an ASM disk group are lost
when the data file on an ASM disk group gets corrupted
when one of the disks in a disk group is accidentally unplugged
when one or more file directory paths are accidentally deleted from an ASM disk group
when all the ASM disk groups for the ASM instance are lost
Question No: 90
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.
You create a common role c##role1 with the create table and select any table privileges. You then execute the commands:
SQLgt; GRANTc##role1 TOcMadmin CONTAINER=ALL;
SQLgt; GRANTc##role1TO b_admin CONTAINER=CURRENT;
Which two statements are true?
C##admin can create and select any table, and grant the c##role1 role to users only in the root container.
B_admin can create and select any table in both the root container and kr_pdb.
c##admin can create and select any table in the root container and all the PDBs.
B_admin can create and select any table only in hr_pdb.
The grant c=禄role1 to b_admin command returns an error because container shouldbe set to ALL.
|Lowest Price Guarantee||Yes||No||No|
|Free VCE Simulator||Yes||No||No|