Oracle Database 11g: New Features with regard to Administrators 1Z0-050 Test
QUESTION NO: 1Identify the 2 immediate solutions through where by SQL blueprints can often be filled to 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 a couple assertions about workload record and also replay operations will be true? (Choose two.)
A. The clients need to be designed manually for the check products to perform more realistic testing.B. Restart that list in RESTRICTED manner ahead of beginning workload replay to be able to enable a clean condition intended for workload replay.C. Restart that list within RESTRICTED style prior to outset workload catch that will make it possible for a new fresh assert to get saving the workload.D. The application state associated with the particular capture method need to be indistinguishable towards job application express on the replay system once the workload replay begins.
Answer: C, D
QUESTION NO: 3View the actual Exhibit exhibit1 to examine this series of SQL commands.
View that Exhibit exhibit2 to look at the actual ideas included in this SQL approach baseline.
Page just one associated with 62The standard around the very first strip belonging to the Exhibit is actually created any time OPTIMIZER_MODE seemed to be fixed toFIRST_ROWS.Which statement is actually legitimate when the SQL question inside exhibit1 is executed yet again once the value ofOPTIMIZER_MODE is determined that will FIRST_ROWS?
A. The optimizer utilizes the latest plan because it's unlikely that any on the ideas inside exhibit2 are preset plans.B. The optimizer utilizes your strategy inside minute row with the exhibit2 given it is definitely an approved plan.C. The optimizer employs the particular plan inside the first strip belonging to the exhibit2 since it will be latest resulted in plan.D. The optimizer utilizes your plan inside earliest row of the exhibit2 due to the fact OPTIMIZER_MODE was collection in order to FIRST_ROW for the duration of it is creation.
Answer: B
QUESTION NO: 4Which record describes the influence involving family table redefinition around the activates that come with your table?
A. All leads to around the desk stay valid.B. All sets off for the kitchen table are invalidated and are routinely revalidated using another DML delivery about the table.C. All sparks to the desk are invalidated and need to be personally recompiled prior to the next DML delivery around the table.D. Only triggers in which are tormented by this alterations for the structure on the kitchen table will be invalidated in addition to instantly revalidated with all the future DML performance about the table.
Answer: B
QUESTION NO: 5USER_DATA will be a nonencrypted tablespace which has a number of furniture along with data. You wish toconvert most of current records within the USER_DATA tablespace along with the new data on the encryptedformat. Which approaches does one utilize to attain this? (Choose all that apply.)
A. Use Data Pump for you to move the particular present records to your brand-new encrypted tablespace.B. Use ALTER TABLE..MOVE to airport transfer the present information to be able to a different encrypted tablespace.C. Use CREATE TABLE AS SELECT for you to transfer the prevailing facts to your brand new encrypted tablespace.
Page 2 with 62D. Enable line movement to get each and every kitchen table to become encrypted and after that apply ALTER TABLESPACE that will encrypt the particular tablespace.E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE declaration making sure that every one of the facts while in the tablespace will be instantly encrypted.
Answer: A, B, C
QUESTION NO: 6Evaluate the next block involving 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 result with the over code?
A. It yields an error for the reason that a totally certified particular name should be specified.B. It makes an error for the reason that the stove of ports of this particular hosts will not be specified.C. It makes an obtain manage variety (ACL) using the end user ACCT_MGR whom makes your CONNECT and RESOLVE privileges.D. It results in an access control variety (ACL) having anyone ACCT_MGR who gets the actual CONNECT benefit but not the actual RESOLVE privilege.
Answer: C
QUESTION NO: 7Which ways are obligatory to help help Direct NFS?1. Mount many essential record methods while using the kernel NFS driver.2. Create an oranfstab report that contain the qualities for every NFS server to get used employing Direct NFS.3. Replace this ODM collection libodm11.so_stub along with libodm11.so.
A. a couple of and 3B. 1 and 3C. just one and 2D. 1, couple of and 3
Answer: B
QUESTION NO: 8Which transactions usually are genuine concerning the notion of complications plus mishaps in the faultdiagnosability infrastructure for Oracle Database 11g? (Choose almost all of which apply.)
A. The issue essential can be like the episode number.B. Every trouble incorporates a difficulty key, which can be a word string that will details the particular problem.C. The database would make an gain access to on the alert log document when issues plus incidents occur.D. The collection blows an incident inform to the Oracle Enterprise Manager Database Home page.E. Only this incident metadata and dumps are usually kept inside Automatic Diagnostic Repository (ADR).
Page three or more regarding 62Answer: B, C, D
QUESTION NO: 9You are usually handling a good Oracle Database 11g database. You wish to please take a burn about tape drivesof the particular USERS tablespace in which carries a single records document of nine hundred MB. You have got tape drives connected with 300 MBeach. To accomplish that backup, anyone issued the actual following RMAN command:RMAN>BACKUPSECTION SIZE 300MTABLESPACE users;What configuration needs to be enacted to perform faster and optimized backups utilizing theabove command?
A. The SBT channel must be configured, using the MAXPIECESIZE set for you to 300 MB.B. The SBT station needs to be configured, by using this parallelism setting for the SBT machine fixed for you to 3.C. The COMPATIBLE initialization parameter for the database case in point has to be set for you to a minimum of 10.0.D. The SBT channel must be configured, using the default parallelism establishing for that SBT unit fixed to be able to 1.
Answer: B
QUESTION NO: 10When executing your SQL workload, anyone choose to yield execution strategies only, without collectingexecution statistics. Which two claims express the ramifications regarding this? (Choose two.)
A. It creates less accurate results from the comparability analysis.B. It automatically phone calls the SQL Tuning Advisor pertaining to recommendations.C. It shortens some time associated with delivery and lowers the particular impact on technique resources.D. Only that changes in the execution plan, and not performance regression, tend to be detected.
Answer: A, C
QUESTION NO: 11You are handling an Oracle Database 11g list with the ASM storage. The database ishaving big file tablespaces. You need information to be able to open faster plus less storage area to get found in theshared beach to manage the particular scope maps. What configuration on earth do you impact to obtain yourobjective? (Choose most in which apply.)
A. Set the particular ASM match ups feature for your ASM file number to 11.1.0.B. Set that RDBMS baby stroller attribute to the ASM computer group to be able to 11.1.0.C. Set the COMPATIBLE initialization parameter for that ASM illustration to be able to 11.1.0.D. Set the particular COMPATIBLE initialization parameter for that list case in point to be able to 11.1.0.
Answer: A, D
QUESTION NO: 12You would like to require that burn of the USERS tablespace. It is known for a single data file associated with 900 MB.. Youhave tape driving of 300 MB each. The SBT siphon will be set up for that RMAN. To accomplishthe backup, you released the examples below RMAN command:RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;Which two phrases are true concerning the execution with the above command? (Choose two.)
A. The backup piece dimensions are going to be constrained to 300 MB.B. The operation is usually completed using the particular default channel available.
Page 4 associated with 62C. The RMAN parallelizes your stop-gap but the parallelism seriously isn't placed to get a channel.D. Three programmes for that tape push needs to be set up by location the actual parallelism to be able to three.
Answer: A, B
QUESTION NO: 13View that Exhibit.
Examine the following order in which is actually completed with the TRANSPORT family table while in the SH schema:SQL> SELECT DBMS_STATS.CREATE_EXTENDED_STATS('sh', 'customers_obe','(country_id,cust_state_province)') FROM dual;Which record describes the worthiness of the command?
A. It collects statistics into the unresolved location throughout your data dictionary.B. It produces a electronic concealed column inside CUSTOMERS_OBE table.C. It accumulates research having AUTO_SAMPLE_SIZE with regard to ESTIMATE_PERCENT.D. It generates a new histogram to hold skewed information regarding the info from the columns.
Answer: B
QUESTION NO: 14View the Exhibit to look at that parameter values.
Page 5 various involving 62
Original Resource :
Visit 1Z0-050 Link : 1Z0-050 Download PDF Link : 1Z0-050
iAutoblog the premier
autoblogger software