View the Exhibit.
What would happen if Oracle Home is not empty（）
A.The installation will not be continued until the location is empty.
B.The installation will proceed without overwriting the existing files.
C.The installation can be continued， but the existing files will be overwritten.
D.The installation terminates automatically after showing an error message
您可能感兴趣的试卷
你可能感兴趣的试题
You are installing Oracle Database 11g on a machine. When you run the installer， the OracleUniversal Installer （OUI） shows the message that says one of the product-specific prerequisite checkshas failed： Checking available swap space requirements ... Expected result： 1512MB Actual Result： 1018MB
Check complete. The overall result of this check is： Failed <<<< Problem： The system does not have the required swap space.
What happens to the installation in this situation（）
A.It can be continued.
B.It resizes the swap space automatically when you proceed further.
C.It can be continued， but the instance cannot be started without increasing the swap space.
D.It shows a message saying one or more prerequisite checks have failed and the installation cannotproceed.
A.Run the root.sh script.
B.Create the oraInst.loc file.
C.Create the tnsnames.ora file.
D.Run the oraintRoot.sh script.
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（）
A.Oracle Managed Files
B.Oracle Grid Architecture
C.Optimal Flexible Architecture
D.Oracle database architecture
E.Automatic Storage Management
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.
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.
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.
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.
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
You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database.
Which option of IMPDP would you use to accomplish this task（）
A.FULL
B.SCHEMAS
C.TRANSFORM
D.REMAP_SCHEMA
E.REMAP_TABLESPACE
最新试题
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（）
Which statements are true about checkpointing（）
You are working on a database that must be functioning 24 hours a day， 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups（）
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area. Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace.Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future. What action would you take to achieve this task（）
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（）
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（）
The database instance has the following parameter setting：OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSEREMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）