单选题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()Aremove the dumpfile option in the commandBremove the flashback_time option in the commandCremove 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)Dadd the user, SYSTEM, to the schemas option in the commandEremove the schemas option and add the network_link = devdb.us.oracle.com option in the command Fadd network_link = devdb.us.oracle.com option in the command

单选题
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


参考解析

解析: 暂无解析

相关考题:

While troubleshooting some connectivity issues,you issue the “show ip ospf database”in order to ex amine the link state database. Which three of the statements below are true regarding the OSPF link state database()A.Each router has an identical link state database.B.External routes are imported into a separate link state database.C.Syn chronization of link state databases is maintained via floodingo f LSAs.D.Information in the link state database is used to build a routing table by calculating a shortest-path tree.E.By default,link state databases are refreshede very 10 minutes in the absence of topology changes.

While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A、A primary key must have been created.B、A mapping table must have been created.C、An overflow tablespace must have been specified.D、The PCTTHRESHOLD option must have been specified.

When verifying the OSPF link state database, which type of LSAs should you expect to see within the different OS PF area types?()A、All OSPF routers in stubby areas can have type 3 LSAs in their database.B、All OSPF routers in stubby areas can have type 7 LSAs in their database.C、All OSPF routers in totally stubby areas can have type 3 LSAs in their database.D、All OSPF routers in totally stubby areas can have type 7 LSAs in their database.E、All OSPF routers in NSSA areas can have type 3 LSAs in their database.F、All OSPF routers in NSSA areas can have type 7 LSAs in their database.

You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?()  A、 run { open script backup_database; run script backup_database }B、 run { engage script backup_database; }C、 run { run script backup_database; }D、 Run { execute script backup_database; }E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

If you create your database using Oracle Managed Files (OMF), what is true?()A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. B、You must define directories for two online redo log groups and three copies of the control file. C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective?()A、AFTER CREATEB、AFTER SUSPENDC、BEFORE CREATED、AFTER TRUNCATEE、BEFORE SUSPENDF、AFTER INSERT OR DELETE OR DELETEG、BEFORE INSERT OR DELETE OR DELETE

While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A、 A primary key must have been created.B、 A mapping table must have been created.C、 An overflow tablespace must have been specified.D、 The PCTTHRESHOLD option must have been specified.

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()A、The instance aborts.B、The database cannot be recovered.C、The database can be recovered by restoring the control files from the backup.D、The database remains opened and you have to shut it down with the ABORT option.E、The database can be restored till the point of the last closed whole database backup.

Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()A、 A window must have been created with the WEEKEND_PLAN resource plan.B、 A program must have been created with the WEEKEND_PLAN resource plan.C、 A job class must have been created with the WEEKEND_PLAN resource plan.D、 A windows group must have been created with the WEEKEND_PLAN resource plan.

You work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.

You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single site named KingSite1.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging  solution.Company.com has recently configured the mailbox server as members of a database availability group (DAG) with a public folder database. During the course of the business week you receive instruction from Company.com to create a new Active Directory site and install Exchange server in the site whilst ensuring the public folders are stored on servers in both sites. What should you do?()A、You should consider having clustered continuous replication (CCR) configured on two servers in the new site.You should then have the replication settings for all public folder databases modified.B、You should consider having the standby continuous replication (SCR) configured on a server in the new site.You should then have the Enable-StorageGroupCopy cmdlet run from a server in the new site.C、You should consider having a public folder database created on a server in the new site.You should then have the replication settings for all public folders modified.D、You should consider having a public folder database created on a server in the new site.You should then have the set-DatabaseAvailabilityGroup cmdlet run from a server in the new site.

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal?()  A、You should recreate the indexes. B、You should compress the log file backups C、You should make the Dworks database use the Full recovery mode D、You should make the Dworks database use the Simple recovery mode.

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. A SQL Server 2005 computer is managed by you, and a database named Customers is included by the SQL Server 2005 computer. A table named CustInfo is included by the database. An identity column named CustID and an nvarchar column named CustName are included by the table. According to the company requirement, rows which duplicate CustName values are included should be moved from the CustInfo table every year. However, the company requests to have rows removed from the CustInfo table after the rows have been manually examined and verified as being duplicates. Since you are the technical support, you are required to think out a method to have potential duplicate rows identified for manual examination. The minimum amount of administrative effort should be utilized.  Which action should be performed to finish the task?()A、A trigger should be created for the CustInfo table so as to roll back INSERT queries that duplicate data is included.B、A new unique index should be created on the CustName column. And then, IGNORE_DUP_KEY = ON should be specified when creating index.C、On the CustName column, a foreign key constraint should be created, and a distinct list of CustName values is referenced by the foreign key constraint.D、A SELECT INTO query should be utilized, and GROUP BY and HAVING clauses should be included by the query to create a new table that contains duplicate rows from the CustInfo table.

单选题You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the database performance degrades. You optimize the database I/O to gain the performance and you decide to remove the baseline metrics. Which method would you use to remove the DISK_IO_BL baseline metrics?()AThe baseline, once created, cannot be removed.BDisable the baseline metrics in the Database Control Manage Metrics page.CThe baseline will be automatically removed once the database performance has been optimized.DDrop the baseline metrics by usingDBMS_WORKLOAD_REPOSITORY.DROP_BASELINE procedure.

单选题While creating a database using Database Configuration Assistant tool, you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used?()Athe CREATE TABLE .. commandBsorting of the SYSTEM tablespace’s dataCsorting of data required by recursive SQL statementsDthe CREATE TABLE .. ORGANIZATION EXTERNAL .. commandEsorting of data if the users have not been allocated temporary tablespace explicitlyFsorting of data if the users have been allocated temporary tablespace explicitly

多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed   that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.  Identify the two events that can occur in the event of a log switch?()AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaDThe database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

单选题You work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()AYou must have started the database instance in restricted mode.BYou must have started the database instance inNORMALmode.CYou must have started the database instance with server parameter file.DYou must have started the database instance but must not have mounted.EYou must have started the database instance but must not have opened.

单选题You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?()A One block change tracking file is created for each data file. By default, the file is created in DB_CREATE_FILE_DEST.B One block change tracking file is created for each data file. By default, the file is created in BACKGROUND_DUMP_DEST.C One block change tracking file is created for the database. By default, the file is created in DB_CREATE_FILE_DEST.D One block change tracking file is created for the database. By default, the file is created in BACKGROUND_DUMP_DEST.

单选题While designing your database, you have created the EMPLOYEES table as an index/x7forganized table (IOT). You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()AA primary key must have been created.BA mapping table must have been created.CAn overflow tablespace must have been specified.DThe PCTTHRESHOLD option must have been specified.

单选题While designing your database, you have created the EMPLOYEEStable as an index-organized (IOT). You want to create a bitmap index on the JOD_IDcolumn to make queries faster. Which task must have been completed so that you are able to create the bitmap index?()A A primary key must have been created.B A mapping table must have been created.C An overflow tablespace must have been specified.D The PCTTHRESHOLD option must have been specified.

单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database,DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command on the PRODDB database server:$ impdp system/manager directory = DB_DATAdumpfile = schemas.datschemas = hr flashback_time = "TO_TIMESTAMP(’25-08-2007 14:35:00’, ’DD-MM-YYYY HH24:MI:SS’)"The command fails displaying the following error:ORA-39001: invalid argument valueORA-39000: bad dump file specification ORA-31640: unable to open dump file "/home/oracle/schema/schemas.dat" for read ORA-27037: unable toobtain file status What would you do to overcome the error()AAdd the user, SYSTEM, to the schemas option.BAdd the network_link = devdb.us.oracle.com option.CChange the dumpfile option to schema.dat@devdb.us.oracle.com.DReplace the schemas option with the network_link = devdb.us.oracle.comEReplace the dumpfile option with the network_link = devdb.us.oracle.com

单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal?()AYou should recreate the indexes. BYou should compress the log file backups CYou should make the Dworks database use the Full recovery mode DYou should make the Dworks database use the Simple recovery mode.

单选题You are a Database Administrator with TXGlobal. You use a password file to establish remote connections to the HR database on the server located at the home office. Currently, two active remote sessions exist to this database. These sessions were established using the SYSDBA privilege from the remote machines. You accidentally deleted the password file. What will be the consequence of this action?()A Both the sessions will be killed, and no new sessions will be created using the SYSDBA or SYSOPER privilege.B Both the sessions will remain active, but no new sessions will be created using the SYSDBA or SYSOPER privilege.CBoth the sessions will be killed, but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.D The database will crash, and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.

单选题In your test database, you have created the ORDERS table as an index-organized table (IOT). To facilitate faster querying, you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.  While investigating the reason, you find that the mapping table segment is fragmented, leading to poor performance.   Which option would you use to defragment the mapping table without affecting the original table data?()Aexport and import the mapping tableBdrop and re-create the mapping tableCtruncate the mapping table and reinsert the valuesDuse the ALTER TABLE···REBUILD command to defragment the mapping table

多选题While troubleshooting some connectivity issues, you issue the "show ip ospf database" in order toexamine the link state database. Which three of the statements below are true regarding theOSPF link state database?()AEach router has an identical link state databaseBExternal routes are imported into a separate link state databaseCSynchronization of link state databases is maintained via flooding of LSAsDInformation in the link state database is used to build a routing table by calculating a shortest-path treeEBy default, link state databases are refreshed every 10 minutes in the absence of topologychanges

单选题You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script?()A run { open script backup_database; run script backup_database }B run { engage script backup_database; }C run { run script backup_database; }D Run { execute script backup_database; }E The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.

单选题You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions, monitoring the database server, and design deployment. In the company, you major job is the deployment, maintenance and support of Microsoft SQL Server 2005. You work as the administrator of a SQL Server 2005 computer, and the computer is called SQL1. There are two databases on the SQL1, and the two databases are respectively named Production and DW. A new database named Staging is created. When the data are moving from the Production database into the DW database, the Staging database is utilized temporarily to store and manipulate data. Since you are the database administrator, you are required to make sure the points listed below. First, the tables should not be removed from the Staging database. Second, any attempts to have tables migrated should be logged. Third, your solution should not impact on other databases.  Which action should be performed to achieve the goal?()ATo achieve the goal, a DML trigger on each table should be created to prevent deletion of data.BTo achieve the goal, a DDL trigger should be created, and that the ON DATABASE parameter is utilized by DDL trigger for the Staging database.CTo achieve the goal, an event notification should be created to fire when the TRUNCATE TABLE Transact-SQL statement is submitted to the Staging database.DTo achieve the goal, a DDL trigger should be created, and the ON ALL SERVER parameter is utilized by the DDL trigger.