Your business has departmental reports that are generated every day. Each department must use the same set of queries, but access a different subset of data in the tables, depending on which department generates the report. The format of the reports is being developed; currently, the format changes daily. How would you configure the database to ensure that each department generates its report (based on its target data) using the most recent report format every day?
A. By having each user run the report generation procedure at the scheduled time, supplying the necessary input variables.
B. By creating a program using DBMS_JOB that accepts one or more variables, and creating a job that calls this program using DBMS_JOB.
C. By having each user schedule a job using DBMS_JOB that accepts one or more input variables and calls a procedure that generates the report.
D. By having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report.
E. By creating a program using DBMS_SCHEDULER that accepts one or more variables, and creating a job that calls this program using DBMS_SCHEDULER.
You execute the following command to create two consumer groups, FIN_GROUP1 and PAY_GROUP1 for a plan, PROD_PLAN:
SIMPLE_PLAN => ‘prod_plan’,
CONSUMER_GROUP1 => ‘fin_group1’,
GROUP1_CPU => 80,
CONSUMER_GROUP2 => ‘pay_group1’,
Which three statements are true? (Choose three)
A. SYS_GROUP gets 100% CPU resources at level 1.
B. FIN_GROUP1 gets 80% CPU resources at level 1.
C. FIN_GROUP1 gets 80% CPU resources at level 2.
D. PAY_GROUP1 gets 20% CPU resources at level 1.
E. PAY_GROUP1 gets 20% CPU resources at level 2.
F. OTHER_GROUP gets 100% CPU resources at level 1.
G. OTHER_GROUP gets 100% CPU resources at level 2.
You have configured Automatic Shared Memory Management. Which four memory structures would be automatically tuned? (Choose four)
A. log buffer
B. Java pool
C. Large pool
D. Fixed SGA
E. Shared pool
F. Streams pool
G. Keep buffer cache
H. Database buffer cache
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed?
A. The Oracle database will not perform block checking for any of the data blocks.
B. The Oracle database will perform block checking for the default permanent tablespace only.
C. The Oracle database will perform block checking for the data blocks in all user tablespaces.
D. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
E. The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
Which statement is true regarding the creation of nested plans using Resource Manager?
A. Only one nested subplan is allowed.
B. The plans can be nested up to four levels.
C. Resource Manager does not support nested plans.
D. Nested plans control only the degree of parallelism but not the CPUuuuu.
E. Each nested plan gets a proportion of the CPU resources assigned to its parent group.
You want your listener to be password protected to prevent it from being shut down. You want to accomplish this task while the listener is functional. Which method could you use to achieve this objective?
A. Use the CHANGE_PASSWORD command of the Listener control utility.
B. Use the SET PASSWORD and SAVE_CONFIG commands of the Listener control utility.
C. Use the CHANGE_PASSWORD and SAVE_CONFIG commands of the Listener control utility.
D. Manually modify the listener.ora file to include the password for the listener and restart the listener.
You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use?
B. The DBNEWID utility
C. The DBVERIFY utility
D. The ANALYZE command
E. The RMAN REPORT command
F. The RMAN CROSSCHECK command.
G. The RMAN BLOCKRECOVER command.
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table:
ERROR at line 1:
ORA-01654: unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES
While investigating, you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available. Which two actions could you perform to overcome this error without affecting the queries that are currently being executed? (Choose two)
A. Drop and re-create the inbox.
B. Coalesce the ORDERS_IND index.
C. Coalesce the INDEXES tablespace.
D. Drop and re-create the ORDERS table.
E. Rebuild the index online and move it to another tablespace.
Consider the following scenario:
You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command:
ALTER DISKGROUP tdgroupA
ADD ALIAS ‘+tdgroupA/data/datafile.dbf’
Which task would be accomplished by the command?
A. The command drops the file +tdgroupA.231.45678.
B. The command physically relocated the file to +tdgroupA/data and renames the file to datafile.dbf.
C. The command creates a copy of the +tdgroupA.231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
D. The command creates an alias, datafile.dbf, and places it in +tdgroupA/data and does not remove the tdgroupA 231.45678 file.
E. The command creates a file, datafile.dbf, in +tdgroupA/data and removed the references for +tdgroupA.231.45678 from the data dictionary views.
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? (Choose two)
A. Restore the lost data file from the backup, and then flash back the database.
B. Restore the data file pertaining to index tablespace, and then recover the tablespace.
C. Restore all the data files, and then perform an incomplete recovery to get the tablespace back.
D. Restore all the data files, and then perform an incomplete recovery using the backup control file.
E. Drop and re-create the index tablespace, and then re-create all of the indexes in that tablespace.
Get Passleader New Update Oracle 1Z0-043 Test Questions With Low Cost