Oracle Database 11g: New Features with regard to Administrators 1Z0-050 Test
QUESTION NO: 1Identify each primary options out of where SQL strategies may be rich in the SQL plan baselines.(Choose two.)
A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots
Answer: A, C
QUESTION NO: 2Which not one but two claims about workload record plus replay surgical treatments usually are true? (Choose two.)
A. The clientele have to be created personally within the check units for you to conduct additional realistic testing.B. Restart the particular repository with RESTRICTED style before beginning workload replay to allow some sort of sparkling state intended for workload replay.C. Restart this collection in RESTRICTED style before starting point workload record in order to allow a clean state with regard to capturing the actual workload.D. The program express of the take procedure must be the same towards program state on the replay procedure if the workload replay begins.
Answer: C, D
QUESTION NO: 3View the Exhibit exhibit1 to look at the series of SQL commands.
View the particular Exhibit exhibit2 to look at the particular plans easily obtainable in the actual SQL approach baseline.
Page just one of 62The primary while in the earliest row on the Exhibit can be created when OPTIMIZER_MODE appeared to be arranged toFIRST_ROWS.Which affirmation well spoken if your SQL issue inside exhibit1 is executed all over again when the worth ofOPTIMIZER_MODE is focused to FIRST_ROWS?
A. The optimizer functions a different package for the reason that none of them on the projects inside the exhibit2 are generally fixed plans.B. The optimizer makes use of that plan while in the second row belonging to the exhibit2 since it is usually an established plan.C. The optimizer uses the plan inside the first strip in the exhibit2 because doing so may be the latest made plan.D. The optimizer makes use of this program from the initial row of the exhibit2 since OPTIMIZER_MODE was fixed to help FIRST_ROW during its creation.
Answer: B
QUESTION NO: 4Which affirmation talks about the effect of dining room table redefinition around the invokes that come with this table?
A. All sets off on the actual stand continue being valid.B. All leads to about the stand will be invalidated and they are automatically revalidated with all the following DML execution about the table.C. All sets off for the family table are usually invalidated and also need to be manually recompiled leading to a future DML delivery for the table.D. Only activates which are generally suffering from the adjustments that will the shape of the table tend to be invalidated plus routinely revalidated considering the up coming DML delivery for the table.
Answer: B
QUESTION NO: 5USER_DATA is a nonencrypted tablespace which contains a set regarding tables having data. You want toconvert many recent files within the USER_DATA tablespace and also the different data to the encryptedformat. Which solutions can you make use of to quickly attain this? (Choose almost all in which apply.)
A. Use Data Pump for you to copy the prevailing data to somewhat of a new encrypted tablespace.B. Use ALTER TABLE..MOVE to copy the prevailing data with a brand new encrypted tablespace.C. Use CREATE TABLE AS SELECT that will copy the earlier information to somewhat of a fresh encrypted tablespace.
Page 2 regarding 62D. Enable line action with regard to each and every stand to be encrypted in addition to then use ALTER TABLESPACE to encrypt the actual tablespace.E. Encrypt the USER_DATA tablespace when using the ALTER TABLESPACE declaration in order that all the data within the actual tablespace is actually immediately encrypted.
Answer: A, B, C
QUESTION NO: 6Evaluate the examples below block connected with 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 may be the final result in the previously mentioned code?
A. It releases a good mistake just because a absolutely experienced host name is required to be specified.B. It produces a good mistake for the reason that collection with plug-ins for this servers will not be specified.C. It creates an admittance manage record (ACL) when using the consumer ACCT_MGR who obtains the actual CONNECT and also RESOLVE privileges.D. It results in a great accessibility control variety (ACL) considering the individual ACCT_MGR exactly who becomes the CONNECT freedom but not your RESOLVE privilege.
Answer: C
QUESTION NO: 7Which steps are generally essential that will permit Direct NFS?1. Mount all required file programs with the kernel NFS driver.2. Create an oranfstab file that contain the actual characteristics for each NFS equipment being used using Direct NFS.3. Replace that ODM stockpile libodm11.so_stub with libodm11.so.
A. 2 and 3B. 1 and also 3C. 1 plus 2D. 1, 2 and 3
Answer: B
QUESTION NO: 8Which claims are usually accurate regarding the style regarding issues plus incidents in the faultdiagnosability national infrastructure regarding Oracle Database 11g? (Choose all that apply.)
A. The dilemma critical is the just like this experience number.B. Every problem features a trouble key, that is certainly a new copy string of which describes the problem.C. The database can make an obtain into the alert record archive when complications and happenings occur.D. The repository directs a great experience alert into the Oracle Enterprise Manager Database Home page.E. Only this event metadata and also dumps will be kept in this Automatic Diagnostic Repository (ADR).
Page 3 involving 62Answer: B, C, D
QUESTION NO: 9You tend to be managing a good Oracle Database 11g database. You desire to require a backup upon tape drivesof your USERS tablespace that features a solo files record regarding 900 MB. You have tape drives of three MBeach. To accomplish the particular backup, people released these RMAN command:RMAN>BACKUPSECTION SIZE 300MTABLESPACE users;What configuration ought to be enacted to perform faster as well as optimized backups utilizing theabove command?
A. The SBT channel have to be configured, when using the MAXPIECESIZE placed that will 300 MB.B. The SBT channel have to be configured, when using the parallelism placing for your SBT system arranged for you to 3.C. The COMPATIBLE initialization parameter intended for that repository instance have to be collection to a minimum of 10.0.D. The SBT sales channel has to be configured, considering the default parallelism setting for that SBT apparatus set to be able to 1.
Answer: B
QUESTION NO: 10When performing some sort of SQL workload, you ultimately choose to get delivery programs only, without having collectingexecution statistics. Which two phrases identify the particular benefits associated with this? (Choose two.)
A. It makes a lesser amount of exact outcome in the comparison analysis.B. It on auto-pilot cell phone calls the particular SQL Tuning Advisor for recommendations.C. It shortens enough time of performance plus reduces the impact on program resources.D. Only this changes in the execution plan, instead of overall performance regression, are generally detected.
Answer: A, C
QUESTION NO: 11You usually are controlling an Oracle Database 11g database using the ASM storage. The databases ishaving major record tablespaces. You want files to be able to start quicker and also a reduced amount of storage that they are included in theshared billiards to regulate the amount maps. What configuration would you effect to obtain yourobjective? (Choose just about all in which apply.)
A. Set the ASM match-ups attribute with the ASM file number to be able to 11.1.0.B. Set your RDBMS compatibility credit for your ASM file group to be able to 11.1.0.C. Set the particular COMPATIBLE initialization parameter with the ASM example to help 11.1.0.D. Set this COMPATIBLE initialization parameter for your database occasion to be able to 11.1.0.
Answer: A, D
QUESTION NO: 12You wish to have your stop-gap of the USERS tablespace. It carries a solitary records archive regarding nine hundred MB.. Youhave tape motoring of 300 MB each. The SBT channel is definitely designed to get the particular RMAN. To accomplishthe backup, you written the following RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which two statements are true about the execution from the earlier mentioned command? (Choose two.)
A. The backup piece width are going to be restricted that will three MB.B. The operation is definitely accomplished using your default channel available.
Page 4 associated with 62C. The RMAN parallelizes the back-up although this parallelism just isn't arranged to get a channel.D. Three channels for your tape travel should be configured by means of setting up the parallelism to three.
Answer: A, B
QUESTION NO: 13View the actual Exhibit.
Examine the following command line which is executed for any TRANSPORT family table inside SH schema:SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe','(country_id,cust_state_province)') FROM dual;Which statement describes the significance of the command?
A. It accumulates studies in the pending spot in the facts dictionary.B. It results in some sort of exclusive concealed column with the CUSTOMERS_OBE table.C. It collects stats together with AUTO_SAMPLE_SIZE pertaining to ESTIMATE_PERCENT.D. It translates into some sort of histogram to support skewed info on your data inside the columns.
Answer: B
QUESTION NO: 14View that Exhibit to look at the particular parameter values.
Page a few associated with 62
Original Resource :
Visit 1Z0-050 Link : 1Z0-050 Download PDF Link : 1Z0-050
iAutoblog the premier autoblogger software
No comments:
Post a Comment