최신 1z0-062 무료덤프 - Oracle Database 12c: Installation and Administration
Which statement is true about the Oracle central inventory directory (oraInventory)?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
You want to create a role that:
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package How would you create this role?
- is protected from unauthorized usage
- does not use a password embedded in the application source code or stored in a table
- is enabled for a user based on security policies defined in a PL/SQL package How would you create this role?
정답: C
설명: (DumpTOP 회원만 볼 수 있음)
You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLE option would you recommend?
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLE option would you recommend?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
Which three statements are true about Enterprise Manager Database Express? (Choose three.)
정답: B,C,E
The HR user receives the following error while inserting data into the sales table:
On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)
On investigation, you find that the users tablespace uses Automatic Segment Space Management (ASSM). It is the default tablespace for the HR user with an unlimited quota on it.
Which two methods would you use to resolve this error? (Choose two.)
정답: A,E
Examine the command to perform a data pump export operation on a source database:
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On the target database, you execute the data pump import command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept Which three statements are true? (Choose three.)
$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept On the target database, you execute the data pump import command:
$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_dept Which three statements are true? (Choose three.)
정답: A,D,E
Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for the database.
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB is corrupted.
What should you do before executing the commands to restore and recover the data file in ACCOUNTS_PDB?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1, which is created as follows:
What happens when the FAILGRP1 failure group is corrupted?
What happens when the FAILGRP1 failure group is corrupted?
정답: B
A PFILE exists for your database. You want to increase the value of the PROCESSES parameter from 300 to
400 and make it persistent for your database instance.
You plan to use the ALTER SYSTEM command.
Which two methods can be used? (Choose two.)
400 and make it persistent for your database instance.
You plan to use the ALTER SYSTEM command.
Which two methods can be used? (Choose two.)
정답: A,B
Which three statements are true about space usage alerts? (Choose three.)
정답: A,B,C
설명: (DumpTOP 회원만 볼 수 있음)
What happens if a maintenance window closes before a job that collects optimizer statistics completes?
정답: B
설명: (DumpTOP 회원만 볼 수 있음)
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
Examine the table definition:
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table? (Choose three.)
정답: B,D,E
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/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?
You have set the DB_SMART_FLASH_FILE parameter:
DB_FLASH_CACHE_FILE= '/dev/flash_device_1 ',' /dev/flash_device_2'
How should the DB_FLASH_CACHE_SIZE be configured to use both devices?
정답: D
설명: (DumpTOP 회원만 볼 수 있음)
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? (Choose two.)
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? (Choose two.)
정답: A,D
설명: (DumpTOP 회원만 볼 수 있음)