单项选择题

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


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题

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.

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

4.单项选择题

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.

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

6.单项选择题

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

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

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

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

最新试题

Which  statements are true regarding listeners()

题型:多项选择题

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too oldWhat could be the reason for this error()

题型:单项选择题

The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable:ERROR at line 1:ORA-00060: deadlock detected while waiting for resource On investigation, you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario()

题型:多项选择题

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

题型:单项选择题

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

题型:单项选择题

Which  statements are correct about temporary tables()

题型:多项选择题

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  kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist?()

题型:多项选择题

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

题型:多项选择题

You have two database servers SEMP and SACCT. The database in the SEMP server maintains the employeeinformation and the database in the SACCT server maintains the accounts payable information. The employeessubmit the expense reports to the accounts payable department. A user of the accounts payable databasewants to extract the employee information from the database in the SEMP server for cross-verification. Whichschema object enables the user to access the information from the remote database()

题型:单项选择题