-
编辑 删除
042-038
38. In your Oracle 10g database, you have scheduled a job to update the optimizer statistics at 05) 00 pm every Friday. The job has successfully completed. Which three pieces of information would you ...
-
编辑 删除
042-036
36. Which three statements are true regarding the fine-grained auditing (FGA)? (Choose three.)A) FGA is possible on SELECT statements only.B) The audit trail for FGA is stored in the FGA_LOG$ table.C)...
-
编辑 删除
042-034
34. Which two statements are true regarding a PL/SQL package body? (Choose two.)A) It cannot be created without a package specification.B) It cannot invoke subprograms defined in other packages.C) It ...
-
编辑 删除
042-30
30. Users of HR schema complain about slower-than-normal performance. On investigation the DBA found that maintenance was recently performed on some of the tables. The DBA traced the query that takes ...
-
编辑 删除
042-29
29.What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database?A) MTTR Advisor would be disabled.B) Redo Log Advisor would be disabled.C) Automatic tun...
-
编辑 删除
042.028
28. View the Exhibit to see the source and target databases.You have created a database link, devdb.us.oracle.com, between the databases PRODDB and DEVDB. You want to import schema objects of the HR u...
-
编辑 删除
042-025
25. Which two statements are true about the roles in the Oracle database? (Choose two)A. A role can be granted to itself.B. Roles are owned by the sys user.C. Roles can be granted to other roles.D. A ...
-
编辑 删除
042-024
24.Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter:ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BO...
-
编辑 删除
042-022
22.You executed the following command to start the database:SQL> STARTUPORACLE instance started.Total System Global Area 281018368 bytesFixed Size 789000 bytesVariable Size 229635576 bytesDatabase Buf...
-
编辑 删除
043-019
19. The application workload on your database is same bwtween 10 a.m. And 11 a.m. On weekdays. Suddenly you observe poor performance between 10 a.m. And 11 a.m. In the middle of the week. How would yo...
-
编辑 删除
042-018
18. In the middle of a transaction,a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in the scenario（方案）? (Choose two).A...
-
编辑 删除
042-17
17. The SCOTT user has an index on the ITEM_DESC column of the ITEM table. As part of the year-ending task, SCOTT updates the ITEM_DESC column for most of the rows in the ITEM table. How does this cha...
-
编辑 删除
043-197
197: You are using Resource Manager to manage system resources. Whilecreating a new database user, you observe that the user is a member ofDEFAULT_CONSUMER_GROUP by default. What would be the implicat...
-
编辑 删除
043-196
196: From the V$SESSION_LONGOPS view, you find that some of the databaseusers have longrunning queries and are consuming a lot of CPU time. Thiscauses problems for you when you try to log on as the sy...
-
编辑 删除
043-195
195: Your database is using shared server configuration. Which optionalmemory structure would you configure to store the User Global Area (UGA)information and improve the shared pool performance?A.lar...
-
编辑 删除
043-194
194: You have set some of the initialization parameters as:DB_BLOCK_SIZE = 8KBSGA_MAX_SIZE = 2GBSGA_TARGET = 0SHARED_POOL_SIZE = 120MBDB_CACHE_SIZE = 896MBSTREAM_POOL_SIZE = 0LARGE_POOL_SIZE = 110MBWh...
-
编辑 删除
043-193
193: In your running instance, some of the initialization parameters areset as shown below:SGA_MAX_SIZE = 14GBDB_CACHE_SIZE = 1GBSHARED_POOL_SIZE = 3GBSTATISTICS_LEVEL = BASICPGA_AGGREGATE_TARGET = 0Y...
-
编辑 删除
043-192
192: You want to migrate your existing non-ASM files to ASM files for thedatabase PROD. Which method or command would you use to accomplish thistask? (Choose all that apply.)A.the CONVERT command of R...
-
编辑 删除
043-191
191: You are using an Automatic Storage Management (ASM) instance tomanage the database files of your production database. After adding a newdisk group to the ASM instance, you execute the followingco...
-
编辑 删除
043-198
198: You have two listener processes, named L1 and L2. Both the listenerprocesses are currentlyfunctional. While viewing the listener.ora file on your database server,you find the following entry:PASS...
