052(十七）

81、

81.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 can contain only the subprograms defined in the package specification. 
D. It can be changed and recompiled without making the package specification invalid. 

Answer: AD

View Code

 

82、

82.In your database instance, the user sessions are connected to the database server from the remote 
machines. 
You want to achieve the following for these users: 
1. The user account must be locked after four unsuccessful login attempts. 
2. The user must be prompted to change the password at regular intervals.  
3. The user may not have more than three simultaneous sessions. 
4. The user session must automatically be logged off if more than 10 minutes elapsed time used. 
How would you accomplish the above? 
A. By assigning profiles for the users 
B. By implementing Fine-Grained Auditing (FGA) 
C. By granting a secure application role to the users 
D. By implementing the Database Resource Manager plan 

Answer: A

View Code

 

83、

 

83.Observe the information in the columns: 
1. The SGA a. Text and parsed forms of all SQL statements 
2. The cursor state b. Run-time memory values for the SQL statement, such as rows retrieved 
3. User-session data c. Security and resource usage information 
4. The stack space d. Local variables for the process 
Which option has the correct match between the memory areas and their contents? 
A. 1-c, 2-b, 3-d, 4-a 
B. 1-b, 2-c, 3-d, 4-a 
C. 1-a, 2-b, 3-c, 4-d 
D. 1-a, 2-b, 3-d, 4-c

Answer: C 

View Code

 

84、

84.You are using Enterprise Manager to schedule backups for your database. 
Which type of script would be generated by the backup scheduler? 
A. XML script 
B. PL/SQL script 
C. Operating system script 
D. Recovery Manager (RMAN) script

Answer: D

View Code

 

85、

85.Note the following functionalities of various background processes: 
1. Record the checkpoint information in data file headers. 
2. Perform recovery at instance startup. 
3. Cleanup unused temporary segments. 
4. Free the resources used by a user process when it fails. 
5. Dynamically register database services with listeners. 
6. Monitor sessions for idle session timeout. 
Which option has the correct functionalities listed for a background process? 
A. Archiver Process (ARCn): 1, 2, 5 
B. System Monitor Process (SMON): 1, 4, 5 
C. Process Monitor Process (PMON): 4, 5, 6 
D. Database Writer Process (DBWn): 1, 3, 4 

Answer: C

View Code

 

转载于:https://www.cnblogs.com/huanhuanang/p/5356592.html