多项选择题
View the Exhibit1, which shows the options that are selected to create the user SL_REP. Which two statements are true regarding this user()
You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups. Which three statements are true about these backups()
单项选择题
You are using Enterprise Manager to schedule backups for your database. Which type of script would begenerated by the backup scheduler()
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
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()
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()
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()
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()
赞题库-搜题找答案
(已有500万+用户使用)
无需下载 立即使用
版权所有©考试资料网(ppkao.com)All Rights Reserved