1Z0-052章节练习(2018.12.15)

多项选择题
View the Exhibit1， which shows the options that are selected to create the user SL_REP.Which two statements are true regarding this user（）
A.The user is authenticated by the operating system.
B.The objects created by the user are placed in the USERS tablespace.
C.The user does not require quota on the TEMP tablespace to perform sort operations.
D.The user is forced to change the password at the first login to the database instance.
E.The objects created by the user in future are unlocked to be accessed by all the users in the database by defa
多项选择题
You are managing an Oracle Database 11g database. The database is open， and you plan to performRecovery Manager （RMAN） backups. Which three statements are true about these backups（）
A.The backups would be consistent.
B.The backups would be inconsistent.
C.The backups would be possible only if the database is running in ARCHIVELOG mode.
D.The backups would be possible only if the database is running in NOARCHIVELOG mode.
E.The backups need to be restored and the database has to be recovered in case of a media failure
多项选择题
Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）
A.The ADDM requires at least four AWR snapshots for analysis.
B.The ADDM runs after each AWR snapshot is collected automatically by MMON.
C.The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.
D.The ADDM analysis provides only diagnostic information but does not provide recommendations.
E.The ADDM calls other advisors if required， but does not provide recommendations about the advisors.
单项选择题
You are using Enterprise Manager to schedule backups for your database. Which type of script would begenerated by the backup scheduler（）
A.XML script
B.PL/SQL script
C.Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.com
D.Recovery Manager （RMAN） script
单项选择题
Identify the memory component from which memory may be allocated for: （）1: Session memory for the shared server 2: Buffers for I/O slaves 3: Oracle Database Recovery Manager (RMAN) backup and restore operations
A.Large Pool
B.Redo Log Buffer
C.Database Buffer Cache
D.Program Global Area （PGA）
单项选择题
For which database operation would you need the database to be in the MOUNT state（）
A.renaming the control files
B.re-creating the control files
C.dropping a user in your database
D.dropping a tablespace in your database
E.configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes
多项选择题
Examine the following statement that is used to modify the primary key constraint on the SALES table：SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE；Which three statements aretrue regarding the above command（）
A.The constraint remains valid.
B.The index on the constraint is dropped.
C.It allows the loading of data into the table using SQL *Loader.
D.New data conforms to the constraint， but existing data is not checked.
E.It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
单项选择题
Observe the information in the columns：1. The SGA a. Text and parsed forms of all SQL statements2. The cursor state b. Run-time memory values for the SQL statement， such as rows retrieved3. User-session data c. Security and resource usage information4. 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
单项选择题
You have created a database link， devdb.us.oracle.com， between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database， DEVDB， to the production database， PRODDB. You execute the following command on the target database server： $impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr flashback_time = 2004-02-03 09：00 The command fails， displaying the following error： ORA-39001： invalid argument value ORA-39000： bad dump file specification ORA-31640： unable to open dump file “/home/oracle/schema/schemas.dat” for read ORA-27037： unable to obtain file status What would you do to overcome the error（）
A.remove the dumpfile option in the command
B.remove the flashback_time option in the command
C.remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command（Replace thedumpfile option with the network_link = devdb.us.oracle.com）
D.add the user， SYSTEM， to the schemas option in the command
E.remove the schemas option and add the network_link = devdb.us.oracle.com option in the command
F.add network_link = devdb.us.oracle.com option in the command
单项选择题
Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity， resulting in degradation ofperformance. What would be your next step to improve performance（）
A.Run the SQL Access Advisor.
B.Run the Memory Advisor for the sga
C.Run the Memory Advisor for the pga.
D.Run the Memory Advisor for the shared pool.
E.Run the Memory Advisor for the buffer cache