Oracle Database 11g: New Features pertaining to Administrators 1Z0-050 Test
QUESTION NO: 1Identify the two immediate sources from when SQL projects can certainly become full in the SQL package baselines.(Choose two.)
A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots
Answer: A, C
QUESTION NO: 2Which a pair of phrases with regards to workload take in addition to replay operations usually are true? (Choose two.)
A. The consumers must be created personally for the test machines to perform extra realistic testing.B. Restart that database in RESTRICTED method before beginning workload replay for you to enable a clean state for workload replay.C. Restart the actual repository around RESTRICTED method prior to beginning workload take to enable a sparkling point out pertaining to acquiring that workload.D. The application point out from the record system have got to become similar for the application express regarding that replay system if the workload replay begins.
Answer: C, D
QUESTION NO: 3View the particular Exhibit exhibit1 to analyze the actual series of SQL commands.
View the actual Exhibit exhibit2 to look at the actual blueprints for sale in this SQL plan baseline.
Page 1 of 62The base line throughout the primary line from the Exhibit can be created as soon as OPTIMIZER_MODE appeared to be established toFIRST_ROWS.Which report very well when the SQL question in exhibit1 is usually done again if the price ofOPTIMIZER_MODE is defined to help FIRST_ROWS?
A. The optimizer purposes an innovative package because none of them on the ideas inside exhibit2 are usually fixed plans.B. The optimizer employs your approach while in the following line regarding the actual exhibit2 because doing so will be an accepted plan.C. The optimizer utilizes the particular plan within the primary row with the exhibit2 because it is the latest generated plan.D. The optimizer makes use of the package from the first line in the exhibit2 because OPTIMIZER_MODE appeared to be established for you to FIRST_ROW during its creation.
Answer: B
QUESTION NO: 4Which report describes the particular result associated with desk redefinition to the invokes mounted on the table?
A. All activates about the kitchen table continue valid.B. All leads to to the table are invalidated and are on auto-pilot revalidated using the up coming DML execution to the table.C. All triggers on the dining room table usually are invalidated as well as must be personally recompiled prior to up coming DML execution to the table.D. Only activates which have been affected by your variations to help the actual framework from the table usually are invalidated in addition to routinely revalidated considering the following DML delivery for the table.
Answer: B
QUESTION NO: 5USER_DATA is often a nonencrypted tablespace which contains a collection of tables with data. You desire toconvert many current records in the USER_DATA tablespace as well as the brand new data to the encryptedformat. Which strategies would you utilize to attain this? (Choose all that apply.)
A. Use Data Pump to be able to transfer the earlier records in order to an innovative encrypted tablespace.B. Use ALTER TABLE..MOVE to help shift the existing files into a new encrypted tablespace.C. Use CREATE TABLE AS SELECT to transfer the prevailing data to some different encrypted tablespace.
Page a couple of with 62D. Enable line activity regarding just about every stand to be encrypted after which it apply ALTER TABLESPACE that will encrypt the tablespace.E. Encrypt the actual USER_DATA tablespace with the ALTER TABLESPACE report in order that the many records in the tablespace will be on auto-pilot encrypted.
Answer: A, B, C
QUESTION NO: 6Evaluate these prevent regarding code:BEGINDBMS_NETWORK_ACL_ADMIN.CREATE_ACL (acl => 'mycompany-com-permissions.xml',principal => 'ACCT_MGR',is_grant => TRUE,privilege => 'connect');DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL (acl => 'mycompany-com-permissions.xml',host => '*.mycompany.net');END;What will be the final result of your on top of code?
A. It yields an malfunction just because a thoroughly qualified intended for title is required to be specified.B. It generates an error because the stove involving jacks from the website hosts will not be specified.C. It translates into an obtain command variety (ACL) considering the customer ACCT_MGR exactly who gets the particular CONNECT plus RESOLVE privileges.D. It translates into an accessibility handle variety (ACL) with the consumer ACCT_MGR which makes the actual CONNECT freedom but not the RESOLVE privilege.
Answer: C
QUESTION NO: 7Which steps usually are mandatory to help enable Direct NFS?1. Mount all needed file systems with the kernel NFS driver.2. Create an oranfstab file made up of that qualities for each NFS device in order to possibly be accessed employing Direct NFS.3. Replace the actual ODM stockpile libodm11.so_stub using libodm11.so.
A. 2 plus 3B. 1 in addition to 3C. a single and also 2D. 1, a couple of in addition to 3
Answer: B
QUESTION NO: 8Which transactions will be real concerning the principle involving difficulties along with incidents within the faultdiagnosability commercial infrastructure to get Oracle Database 11g? (Choose just about all this apply.)
A. The trouble crucial is usually exactly like the event number.B. Every problem is known for a problem key, that is certainly a wording chain that explains the problem.C. The collection would make a strong connection in the inform firewood report as soon as complications in addition to situations occur.D. The list sends an episode tell towards Oracle Enterprise Manager Database Home page.E. Only the particular episode metadata plus dumps are saved in the Automatic Diagnostic Repository (ADR).
Page 3 with 62Answer: B, C, D
QUESTION NO: 9You will be running an Oracle Database 11g database. You would like to look at some sort of backup on tape drivesof your USERS tablespace that includes a single records file involving 900 MB. You have got tape devices of more than 200 MBeach. To accomplish this backup, you granted this RMAN command:RMAN>BACKUPSECTION SIZE 300MTABLESPACE users;What configuration ought to be put in place to perform more quickly along with optimized backups by making use of theabove command?
A. The SBT funnel have to be configured, using the MAXPIECESIZE established to be able to 3 hundred MB.B. The SBT funnel must be configured, when using the parallelism setting up for the SBT apparatus set to 3.C. The COMPATIBLE initialization parameter to the collection occasion should be fixed for you to at lowest 10.0.D. The SBT siphon has to be configured, with all the default parallelism environment for the SBT machine established to be able to 1.
Answer: B
QUESTION NO: 10When doing your SQL workload, you select to make performance plans only, without collectingexecution statistics. Which a couple claims express that implications of this? (Choose two.)
A. It generates less accurate outcome on the comparison analysis.B. It automatically message or calls this SQL Tuning Advisor for recommendations.C. It shortens the time of performance as well as lowers the affect program resources.D. Only the alterations within the delivery plan, but not operation regression, are usually detected.
Answer: A, C
QUESTION NO: 11You will be coping with an Oracle Database 11g data source with all the ASM storage. The database ishaving major file tablespaces. You wish data files to be able to open up sooner as well as a reduced amount of memory to become found in theshared pool to handle this extent maps. What configuration could people effect to attain yourobjective? (Choose most of this apply.)
A. Set that ASM compatibility attribute regarding the ASM storage class to help 11.1.0.B. Set the particular RDBMS match-ups feature for that ASM drive group in order to 11.1.0.C. Set the actual COMPATIBLE initialization parameter for the ASM case in point that will 11.1.0.D. Set the actual COMPATIBLE initialization parameter for any collection case that will 11.1.0.
Answer: A, D
QUESTION NO: 12You need to take the burn of this USERS tablespace. It features a single info report of 900 MB.. Youhave tape motoring of 3 hundred MB each. The SBT route is configured with the RMAN. To accomplishthe backup, everyone given this particular RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which two claims will be genuine relating to that performance belonging to the above command? (Choose two.)
A. The back-up article size will be confined in order to 300 MB.B. The operation is accomplished with the default sales channel available.
Page 4 with 62C. The RMAN parallelizes your back up even though the parallelism just isn't collection for a channel.D. Three stations with the tape travel have got to possibly be set up simply by establishing your parallelism that will three.
Answer: A, B
QUESTION NO: 13View your Exhibit.
Examine this particular command line that is certainly accomplished for the TRANSPORT stand while in the SH schema:SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe','(country_id,cust_state_province)') FROM dual;Which declaration talks about the worthiness of your command?
A. It collects studies to the approaching area in the info dictionary.B. It results in a exclusive hidden column in the CUSTOMERS_OBE table.C. It collects data together with AUTO_SAMPLE_SIZE regarding ESTIMATE_PERCENT.D. It creates some sort of histogram to cling skewed more knowledge about the slide images in the columns.
Answer: B
QUESTION NO: 14View your Exhibit to look at your parameter values.
Page some of 62
Original Resource :
Visit 1Z0-050 Link : 1Z0-050 Download PDF Link : 1Z0-050
iAutoblog the premier autoblogger software
No comments:
Post a Comment