1Z0-052章节练习(2019.04.19)

In a new installation of Oracle Database 11g， you perform these activities： 
1：Organize software and data on different subdirectories to avoid poor performance. 
2：Use consistent naming conventions for database files. 
3：Separate administrative information pertaining to the database in different directories. 
Which option corresponds to the type of activities you performed（）

Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future. 
What action would you take to achieve this task（）

You executed the command to create a password file in the database server： $ orapwd file=orapworcl entries=5ignorecase=N 
Which statement describes the purpose of the above password file（）

Your database instance is started using the server parameter file （SPFILE）. You executed acommand to change the value of the LOG_BUFFER initialization parameter： ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； 
What would be the outcome of this command（）

You want to import schema objects of the HR user using Oracle Data Pump from the development database，DEVDB， to the production database， PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server：$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr
flashback_time = "TO_TIMESTAMP（’25-08-2007 14：35：00’， ’DD-MM-YYYY HH24：MI：SS’）"The command fails displaying the following error：ORA-39001： invalid argument valueORA-39000： bad dump file specification
ORA-31640： unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037： unable toobtain file status
What would you do to overcome the error（）

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（）

Automatic Shared Memory Management （ASMM） has been enabled for your database instance. 
Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M； 
Which statement is true in this scenario（）

Which statements are true regarding the USERS tablespace（）

View the Exhibit and examine the output. 

Which two statements are true regarding the LISTENER2 listener（）