单项选择题

View the Exhibit to examine the details for an incident.

Which statement is true regarding the status of the incident()

A.The DBA is working on the incident and prefers that the incident be kept in the ADR.
B.The incident is now in the Done state and the ADR can select the incident to be purged.
C.The incident has been newly created and is in the process of collecting diagnostic information.
D.The data collection for the incident is complete and the incident can be packaged and sent to OracleSupport.


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which two statements are true regarding the Oracle Data Pump export and import operations()

A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported.

2.单项选择题

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

4.多项选择题In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table()

A.if a table is not in a cluster
B.if a table has an active trigger
C.if a table has an encrypted
D.if a table has a column of data type LONG defined on it
E.if a table has a referential integrity constraint defined on it

5.多项选择题Which two statements are true regarding Oracle Data Pump()

A.EXPDP and IMPDP are the client components of Oracle Data Pump.
B.DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C.Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D.Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
E.EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

6.多项选择题Which two statements are true regarding the usage of the SQL*Loader utility()

A.You can load data into multiple tables during the same load session.
B.You can load data from multiple files to a table during the same load session.
C.You cannot perform selective data loading based on the values available in the records.
D.You can use an export file generated by the EXPDP utility as an input data file to load the data.
E.You can load data only if the input file is available on the disk and tape but not in a named pipes.

7.单项选择题Which statement is true about loading data using the conventional path of SQL*Loader()

A.Redo is not generated while performing conventional path loads.
B.Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked.
C.No exclusive locks are acquired when the conventional path loads are performed.
D.Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
E.INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.

8.多项选择题Which two operations can be performed on an external table()

A.Create a view on the table.
B.Create an index on the table.
C.Create a synonym on the table.
D.Add a virtual column to the table.
E.Update the table using the UPDATE statement.
F.Delete rows in the table using the DELETE command.

最新试题

In which situation is the UNDO_RETENTION parameter be ignored, even if it is set to a value()

题型:单项选择题

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output()

题型:单项选择题

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()

题型:单项选择题

Which  statements regarding the server parameter file (SPFILE) are true()

题型:多项选择题

Examine the command that is used to create a table:SQL> CREATE TABLE orders(oid NUMBER(6) PRIMARY KEY, odate DATE, ccode NUMBER (6), oamtNUMBER(10,2)) TABLESPACE users;Which two statements are true about the effect of the above command()

题型:多项选择题

View the Exhibit. You are creating an additional database by using the Database Configuration Assistant(DBCA). You opted to create a General Purpose database and during the database creation realize that theBlock Size field is not enabled. What could be the reason for this()

题型:单项选择题

You want to configure and schedule offline database backups to run automatically. Which tool or utility wouldyou use to achieve this()

题型:单项选择题

Which  statements are true regarding listeners()

题型:多项选择题

Which statements are true about logical structures of the Oracle database()

题型:多项选择题

The user HR receives the following error while inserting data into the TTK table:ERROR at line 1:ORA-01653: unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation, you find that SMDis a small file tablespace.Which three action would allow the user to insert data()

题型:多项选择题