Oracle Database 11g: New Features pertaining to Administrators 1Z0-050 Test
QUESTION NO: 1Identify the two direct resources from wherever SQL ideas is often rich on the SQL prepare baselines.(Choose two.)
A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots
Answer: A, C
QUESTION NO: 2Which two phrases with regards to workload capture and replay surgical procedures are generally true? (Choose two.)
A. The customers must possibly be developed by hand on the analyze machines that you perform additional natural testing.B. Restart the databases in RESTRICTED method ahead of beginning workload replay that will make it possible for a clean point out with regard to workload replay.C. Restart the actual data source throughout RESTRICTED method in advance of start workload record to be able to enable your thoroughly clean assert to get saving this workload.D. The program state from the record system has to be the exact same for the practical application condition of the replay program once the workload replay begins.
Answer: C, D
QUESTION NO: 3View the particular Exhibit exhibit1 to look at the line connected with SQL commands.
View this Exhibit exhibit2 to look at the ideas accessible in the SQL approach baseline.
Page 1 of 62The primary inside the primary line with the Exhibit is usually established when OPTIMIZER_MODE has been placed toFIRST_ROWS.Which report is true when the SQL search with exhibit1 is executed again once the value ofOPTIMIZER_MODE is determined to FIRST_ROWS?
A. The optimizer uses a innovative prepare for the reason that none of them in the plans while in the exhibit2 tend to be unchanging plans.B. The optimizer uses the actual approach in the second row of the exhibit2 given it is surely an recognised plan.C. The optimizer uses your prepare in that very first line on the exhibit2 because it is the latest resulted in plan.D. The optimizer utilizes the particular package from the first row in the exhibit2 because OPTIMIZER_MODE appeared to be collection to FIRST_ROW throughout its creation.
Answer: B
QUESTION NO: 4Which report talks about the effect of family table redefinition to the sets off that come with the table?
A. All leads to for the table remain valid.B. All leads to on the stand are invalidated and so are instantly revalidated with all the next DML delivery on the table.C. All triggers within the table usually are invalidated and also ought to be by hand recompiled prior to the up coming DML performance upon the actual table.D. Only triggers which are tormented by the particular modifications towards the composition belonging to the table will be invalidated plus instantly revalidated when using the following DML execution about the table.
Answer: B
QUESTION NO: 5USER_DATA is really a nonencrypted tablespace which contains a set of dining tables by using data. You want toconvert just about all existing facts with the USER_DATA tablespace as well as the new files to the encryptedformat. Which strategies could you utilize to attain this? (Choose almost all in which apply.)
A. Use Data Pump to be able to transfer the particular recent facts to your new encrypted tablespace.B. Use ALTER TABLE..MOVE in order to exchange the present data to a new encrypted tablespace.C. Use CREATE TABLE AS SELECT for you to shift the present files to your fresh encrypted tablespace.
Page 2 associated with 62D. Enable row motion for just about every desk to become encrypted then make use of ALTER TABLESPACE for you to encrypt the tablespace.E. Encrypt that USER_DATA tablespace using the ALTER TABLESPACE report making sure that many of the info inside tablespace is automatically encrypted.
Answer: A, B, C
QUESTION NO: 6Evaluate your next block 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 is a final result in the earlier mentioned code?
A. It creates a good fault because a fully qualified particular name ought to be specified.B. It creates an error as the assortment regarding vents from the contains has not been recently specified.C. It creates an access command record (ACL) using the person ACCT_MGR that makes the CONNECT as well as RESOLVE privileges.D. It results in an access control listing (ACL) using this user ACCT_MGR exactly who gets the CONNECT freedom but not your RESOLVE privilege.
Answer: C
QUESTION NO: 7Which methods tend to be essential to allow Direct NFS?1. Mount most of essential track techniques while using kernel NFS driver.2. Create an oranfstab report that contains this properties for each and every NFS host to be entered applying Direct NFS.3. Replace the particular ODM library libodm11.so_stub using libodm11.so.
A. 2 plus 3B. a single and 3C. 1 and also 2D. 1, 2 in addition to 3
Answer: B
QUESTION NO: 8Which statements are accurate regarding the concept connected with difficulties in addition to incidents inside faultdiagnosability infrastructure intended for Oracle Database 11g? (Choose most of which apply.)
A. The trouble essential will be the same as the actual incident number.B. Every trouble is known for a dilemma key, that is a copy stringed that represents that problem.C. The databases can make an admittance into that alert record file whenever issues and reports occur.D. The database ships a good experience alert towards Oracle Enterprise Manager Database Home page.E. Only your occurrence metadata and dumps are saved inside the Automatic Diagnostic Repository (ADR).
Page 3 regarding 62Answer: B, C, D
QUESTION NO: 9You will be running an Oracle Database 11g database. You prefer to receive a back up about tape drivesof the USERS tablespace which has a solitary information file associated with 900 MB. You have tape shots off the tee of 3 hundred MBeach. To accomplish this backup, people released the examples below RMAN command:RMAN>BACKUPSECTION SIZE 300MTABLESPACE users;What configuration ought to be put into place to complete speedier in addition to optimized backups by making use of theabove command?
A. The SBT channel must be configured, with all the MAXPIECESIZE fixed to be able to more than 200 MB.B. The SBT funnel need to be configured, with all the parallelism location for that SBT unit fixed for you to 3.C. The COMPATIBLE initialization parameter to the collection illustration have to be established to at least 10.0.D. The SBT sales channel needs to be configured, while using default parallelism setting for that SBT machine collection that will 1.
Answer: B
QUESTION NO: 10When doing a SQL workload, you choose to come up with execution projects only, without having collectingexecution statistics. Which a couple terms express your benefits involving this? (Choose two.)
A. It releases less precise results in the comparability analysis.B. It automatically calls the particular SQL Tuning Advisor intended for recommendations.C. It shortens time of performance as well as lowers that impact upon technique resources.D. Only your changes from the delivery plan, without performance regression, are detected.
Answer: A, C
QUESTION NO: 11You are running a great Oracle Database 11g collection when using the ASM storage. The list ishaving major archive tablespaces. You really want records to open up sooner along with less memory that they are utilized in theshared pool to manage this amount maps. What configuration does one influence to quickly attain yourobjective? (Choose most of in which apply.)
A. Set this ASM baby stroller characteristic for the ASM computer number for you to 11.1.0.B. Set the RDBMS compatibility feature for your ASM drive number to help 11.1.0.C. Set this COMPATIBLE initialization parameter regarding the particular ASM illustration to help 11.1.0.D. Set the COMPATIBLE initialization parameter for that list instance for you to 11.1.0.
Answer: A, D
QUESTION NO: 12You want to take this backup with the USERS tablespace. It offers one particular files document of nine hundred MB.. Youhave tape devices involving 3 hundred MB each. The SBT funnel is configured to the RMAN. To accomplishthe backup, an individual written the following RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which a pair of assertions are legitimate regarding the delivery of the previously mentioned command? (Choose two.)
A. The stop-gap item size might be constrained to 300 MB.B. The operation is accomplished when using the default channel available.
Page 4 involving 62C. The RMAN parallelizes the backup but the parallelism is not really collection for a channel.D. Three stations with the tape drive needs to be configured by location your parallelism for you to three.
Answer: A, B
QUESTION NO: 13View the actual Exhibit.
Examine these order that may be done pertaining to the TRANSPORT dining room table from the SH schema:SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe','(country_id,cust_state_province)') FROM dual;Which report details the significance of that command?
A. It collects statistics to the unfinished region inside data dictionary.B. It results in your exclusive disguised . column in this CUSTOMERS_OBE table.C. It accumulates statistics having AUTO_SAMPLE_SIZE regarding ESTIMATE_PERCENT.D. It results in some sort of histogram for you to hold skewed information about the information while in the columns.
Answer: B
QUESTION NO: 14View that Exhibit to examine the actual parameter values.
Page your five involving 62
Original Resource :
Visit 1Z0-050 Link : 1Z0-050 Download PDF Link : 1Z0-050
iAutoblog the premier autoblogger software
No comments:
Post a Comment