1Z0-052章节练习(2019.03.25)

Examine the commands executed in the following sequence： 
1：SQL> CREATE ROLE mgrrole； 
2：SQL> GRANT create user，select any table，connect，resource TO mgrrole； 
3：SQL> GRANT select，update ON sh.sales TO mgrrole； 
4：SQL> CREATE ROLE ceo IDENTIFIED BY boss； 
5：SQL> GRANT mgrrole，drop any table，create any directory TO ceo； 
6：SQL> GRANT ceo TO mgrrole； 
Which statement is true about the above commands（）

These are points that describe the contents of different memory components: 
1: Descriptive information or metadata about schema objects that are queried by using SQL statements 
2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements 
3: Results of SQL queries and PL/SQL functions 
4: Executable forms of SQL cursors, PL/SQL programs, and Java classes 
5: The information necessary to reconstruct changes made to the database by a transaction 
Which of these will be stored in theShared Poolif the necessary configurations are done（）

In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. 
What isthe impact of this setting（）

You notice that the performance of the database has degraded because of frequent checkpoints. 
Which twoactions resolve the issue（）

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario()

In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information. 
What action would you take to achieve this task（）

The database instance is currently using SPFILE. View the Exhibit and examine the error that youreceived while running the DB Structure Integrity check. 
 
Given below are the steps to recover from the error in random order: 
1: Shut down the instance, if not already done. 
2: Copy one of the remaining control files to a new location. 
3: Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files. 
4: Start up the database instance to the NOMOUNT stage. 
5: Recover the database to the point of failure of the control file. 
6: Open the database. 
Identify the correct sequence of steps()