单项选择题Which task would you perform before you run Oracle Universal Installer (OUI) in silent or suppressedmode for an installation()

A.Run the root.sh script.
B.Create the oraInst.loc file.
C.Create the tnsnames.ora file.
D.Run the oraintRoot.sh script.


您可能感兴趣的试卷

你可能感兴趣的试题

2.单项选择题

You are installing Oracle Database 11g on your server. During the installation Oracle UniversalInstaller (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify anoperating system group name. 
Which statement is true in this case()

A.The ORACLE_BASE parameter is not set.
B.The installation is being performed by the root user.
C.The operating system group that will be specified should have root user as its member.
D.The installation is being performed without the "Create Starter Database" option selected.
E.The operating system group that will be specified must have permission to write to the inventorydirectory.

4.多项选择题Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support()

A.You can add SQL test cases to the incident package.
B.You can add or remove the trace files to the package.
C.You cannot create an incremental incident package when the physical files are purged from the ADR.
D.You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

5.单项选择题

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.

6.多项选择题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.

7.单项选择题

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

9.多项选择题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

10.多项选择题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.

最新试题

After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN;Which two statements are true()

题型:多项选择题

Which  statements are true regarding the Oracle Data Pump export and import operations()

题型:多项选择题

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

题型:单项选择题

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 optioncorresponds to the type of activities you performed()

题型:单项选择题

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

题型:单项选择题

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, orany data definition language (DDL) command:SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;SCOTT has opened another session to work with the database instance. Which three operations would waitwhen issued in SCOTT’s second session()

题型:多项选择题

Why does performance degrade when many UPDATE, INSERT, or DELETE statements are issued on a tablethat has an associated Bitmap index()

题型:单项选择题

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

题型:单项选择题

Which  kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?()

题型:多项选择题

Which  statements are true regarding listeners()

题型:多项选择题