网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Using Oracle Scheduler you have scheduled two jobs, JOB_Aand 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 window group must have been created with the WEEKEND_PLAN resource plan.

参考答案

更多 “Using Oracle Scheduler you have scheduled two jobs, JOB_Aand 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 window group must have been created with the WEEKEND_PLAN resource plan.” 相关考题
考题 In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?()A. authentication by password fileB. authentication by using certificates over SSLC. authentication by using the Oracle Internet DirectoryD. authentication by using the local OS of the database server

考题 ABC Corp. has configured 11i Oracle Applications for the English language. It is now planningto commence operations in France and so wants the same instance to be available in French aswell. It can accomplish this task by using ().A.Oracle ConfiguratorB.Oracle General LedgerC.Application Object LibraryD.Oracle Human Resources

考题 You enabled the flashback logging feature, but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area?()A、the location used for control filesB、the location used for redo log filesC、the location set by using $ORACLE_BASED、the location set by using $ORACLE_HOMEE、the location set by using CORE_DUMP_DESTF、the location set by using BACKGROUND_DUMP_DEST

考题 Which of the following options would you choose to implement controlled access using remote authentication for your networks?()A、OiDB、RADIUSC、Wallet ManagerD、Oracle Names Server

考题 You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces?()A、SQL*PlusB、iSQL*PlusC、Management ServerD、Management RepositoryE、Oracle Enterprise Manager 10g Database Control

考题 Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords?()A、Wallet ManagerB、RadiusC、Oracle Internet DirectoryD、None of the above

考题 You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

考题 You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true? ()A、It is a SQL script.B、It is a PL/SQL file.C、It is an operating system (OS) file.D、It is a Recovery Manager (RMAN) script

考题 In your database,the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:$ SQLPLUS scott/tiger@DB01 AS SYSDBA   where DB01 is the net service name.   Which authentication method would be used first?()  A、 authentication by password fileB、 authentication by using certificates over SSLC、 authentication by using the Oracle Internet DirectoryD、 authentication by using the local OS of the database server

考题 You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A、DatafilesB、 Current control fileC、 Server parameter file (spfile)D、 Password file

考题 ABC Corp. has configured 11i Oracle Applications for the English language. It is now planningto commence operations in France and so wants the same instance to be available in French aswell. It can accomplish this task by using ().A、Oracle ConfiguratorB、Oracle General LedgerC、Application Object LibraryD、Oracle Human Resources

考题 You issue the following statement:   SQL SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE;  You receive the following error:         01578: ORACLE data block corrupted (file# 6, block # 54)        ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()A、 by using the DBMS_REPAIR packageB、 by using the DBVERIFY utilityC、 by using Block Media RecoveryD、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true?()A Transactions are rolled back using redo log files.B Transactions are rolled forward using redo log files.C Transactions are rolled back using redo log files and archived log files.D Transactions are rolled forward using redo log files and rolled back using redo log files.

考题 单选题You issue the following statement:   SQL SELECT FIRSTNAME, LASTNAME FROM HR.EMPLOYEE;  You receive the following error:         01578: ORACLE data block corrupted (file# 6, block # 54)        ORA-01110 : data file 6: ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover (MTTR)?()A  by using the DBMS_REPAIR packageB  by using the DBVERIFY utilityC  by using Block Media RecoveryD  by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

考题 单选题You enabled the flashback logging feature, but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area?()A  The location used for control files.B  The location used for redo log files.C  The location set by using $ORACLE_BASED  The location set by using $ORACLE_HOMEE  The location set by using CORE_DUMP_DESTF  The location set by using BACKGROUND_DUMP_DEST

考题 单选题Which setting enables the baselines by default in Oracle Database 11g?()A setting the STATISTICS_LEVEL parameter to TYPICALB adding filters to the Automatic Database Diagnostic Monitor (ADDM)C enabling Automated Maintenance Task using Oracle Enterprise ManagerD setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

考题 单选题You enabled the flashback logging feature, but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area?()A the location used for control filesB the location used for redo log filesC the location set by using $ORACLE_BASED the location set by using $ORACLE_HOMEE the location set by using CORE_DUMP_DESTF the location set by using BACKGROUND_DUMP_DEST

考题 多选题SQ L*Loader is a utility that can perform which two tasks?()ALoad data from a disk, tape, or named pipes.BLoad data into an Oracle database using DML statements.CExtract, reorganize, and insert data within an Oracle database.DLoad data from external files into tables in an Oracle database.ELoad data into an Oracle database using operating system commands.FLoad data directly from a non-Oracle database to an Oracle database.

考题 单选题Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output: $ crsctl config has CRS-4622: Oracle High Availability Services auto start is enabled. What does this imply?()A When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.B When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.C When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.D When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

考题 多选题Identify the three processes that customers can choose for patching WebLogic Server.()ADownload patches from My Oracle Support and manage them using Smart Update.BUse Enterprise Manager to download patches from My Oracle Support and apply patches to WebLogic.CDownload patches from My Oracle Support and manually modify the classpath of the application server (though it is not recommended).DDownload patches from My Oracle Support and apply them using the WebLogic Admin Console.EUse the Admin Console to connect to My Oracle Support and download patches and then target them to the domain.

考题 多选题Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately?()ADB_CACHE_SIZEBSHARED_POOL_SIZECLARGE_POOL_SIZEDJAVA_POOL_SIZEESGA_MAX_SIZEFSORT_AREA_SIZE

考题 单选题Which setting enables the baselines by default in Oracle Database 11g?()A  setting the STATISTICS_LEVEL parameter to TYPICALB  adding filters to the Automatic Database Diagnostic Monitor (ADDM)C  enabling Automated Maintenance Task using Oracle Enterprise ManagerD  setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

考题 单选题You are connecting to an Oracle database server from a client by using the following connect string:  SQL CONNECT hr/hr@pdserver.us.oracle.com:1521/proddb  Which naming method is being used in this case?()A Local NamingB Easy ConnectC External NamingD Directory Naming

考题 单选题On Monday, you dropped the DEPT table from your schema and then you re/x7fcreated the DEPT table in your schema. On Wednesday, you have a requirement to restore the DEPT table from the recycle bin. Which statement is correct?()A You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.B You can restore the DEPT table by using the Oracle Flashback Drop feature and a system­generated name will be assigned to the restored table.C You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.D You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.

考题 多选题You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb  Which three statements are correct regarding the connection string?()Amydb is a service name.Btest.us.oracle.com is a database name.C1521 is the listener port number.Dmydb is a host name.Etest.us.oracle.com is a net service name.Fhr is a username.Gtest.us.oracle.com is an instance name.

考题 单选题In which situation would you use the Oracle Shared Server configuration?()A when performing export and import using Oracle Data PumpB when performing backup and recovery operations using Oracle Recovery ManagerC when performing batch processing and bulk loading operation in a data warehouse environment D in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time

考题 单选题How can you configure High Availability for interacting with a non-Oracle database using WebLogic?()A Configure multiple physical data sources and reuse the same JNDI name for each.B Use the compatibility option of Active GridLink to enable compatibility with non-Oracle  databases.C Configure a single physical data source for each node in a database cluster and wrap it using  Multi Data Source.D Configure a Data Source Group that contains a physical connection pool to each node in the  database cluster.

考题 多选题A web browser can connect directly to an Oracle server using which two?()AHTTPBIIOPCTCP/IPDNamed PipesETCP/IP with SSL