6.Your business has departmental reports that are generated every day. Each department must use the same set of queries, but accesses 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?
5 ~2 N5 d2 p* S4 o& u- `) X/ h# \ A: by having each user run the report generation procedure at the scheduled time, supplying the necessary input variables
7 h6 z0 S8 V3 p9 o, B 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. T& _6 ~* n' q3 y E2 w* Q9 P
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
/ B6 w5 ^, A/ {# o D: by having each user create a job using DBMS_SCHEDULER that includes all the information and commands necessary to generate the report
2 X8 \: {- k' O+ N6 u2 | 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
' P4 [/ a* @4 t Correct Answers: E/ g4 }/ e9 O- }/ n
7.Manually, you set the consumer group of all of the newly created users to MYDB_GRP . You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?
" W4 [( S, p% J3 Z# |# G3 s A: The user must have been granted the DBA role.
; e8 c7 e& c- S$ l1 I. r B: The user must have been granted the switch privilege as a part of a role.; L1 a1 b [' ^. B+ K
C: The user must have been granted the Resource Manager administrator privilege.
; }% Y' {( j7 c- e D: The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
& _3 S. S: S( W' @/ k Correct Answers: D6 k8 i- R. h, U g6 K
8.The backup retention policy is configured as RECOVERY WINDOW 2 . You executed the following command in Recovery Manager (RMAN) against your database: RMAN> REPORT OBSOLETE; What would you see in the output?
4 U# H' E& G7 n. G A: a list of all the expired backups and copies
# T! L) E" J" g8 P* v3 h2 n B: a list of all those files that have been deleted in the last two days8 y% S8 B3 O N* e( N: } p! j
C: a list of all those files that have been recovered within the last two days; e) _ T% S( M1 f4 R2 g/ ~
D: a list of backups and copies that are outside the range covered by the current retention policy% H. R; g4 L O7 E( N, h8 R
Correct Answers: D
+ } k7 V% L- _# H8 t# ~ 9.Which two statements regarding compressed backups in Recovery Manager (RMAN) are true? (Choose two.)6 Y& p3 H( h7 _
A:Backup compression is disabled by default.8 ^7 J5 D- j7 w, u
B:Backup compression applies to only backup sets.
: S* N" m1 `, Z! S- z7 b4 E C:Backup compression applies to only image copies.' D. o: U1 ^4 {6 I/ _# _; u# S
D:Backup compression cannot be enabled using the CONFIGURE command.7 @( \; H) v/ c4 Y
E:Backup compression can be used with both backup sets and image copies.
% M. N0 M* O. w. }! g' C( Q7 f F:Backup compression works only if the COMPATIBILITY parameter is set to 9.0.0.0 or higher.
+ T8 J- Z: x2 G, |1 x: L, j Correct Answers: A, B
- g4 {4 i5 l' H; @7 ^) A 10.View the Exhibit. You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up? (Choose three.)( E* k/ ]5 S. z ?3 q8 N: R
. J8 x% r) \' [+ e A:password file4 d) B; T2 m, j* e* h) j
B:online redo log files
* D: k. G0 T1 z8 R C:the current control file1 ?+ X* a( D! N5 j+ r7 h; l% R
D:archived redo log files- Q+ z8 Q+ I7 |0 f
E:the current server parameter file
3 B. j! Z$ w) a8 N7 L F:all the data files belonging to the USERS tablespace
: Y1 h5 D' o. }- X [3 W L G:data files belonging to the USERS tablespace and all the default tablespaces! e' N1 [/ b% c! `: a
Correct Answers: C, E, F |