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?()
第1题:
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?()
第2题:
You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()
第3题:
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?()
第4题:
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 ().
第5题:
Transactions are rolled back using redo log files.
Transactions are rolled forward using redo log files.
Transactions are rolled back using redo log files and archived log files.
Transactions are rolled forward using redo log files and rolled back using redo log files.
第6题:
The location used for control files.
The location used for redo log files.
The location set by using $ORACLE_BASE
The location set by using $ORACLE_HOME
The location set by using CORE_DUMP_DEST
The location set by using BACKGROUND_DUMP_DEST
第7题:
the location used for control files
the location used for redo log files
the location set by using $ORACLE_BASE
the location set by using $ORACLE_HOME
the location set by using CORE_DUMP_DEST
the location set by using BACKGROUND_DUMP_DEST
第8题:
When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.
第9题:
DB_CACHE_SIZE
SHARED_POOL_SIZE
LARGE_POOL_SIZE
JAVA_POOL_SIZE
SGA_MAX_SIZE
SORT_AREA_SIZE
第10题:
Local Naming
Easy Connect
External Naming
Directory Naming
第11题:
mydb is a service name.
test.us.oracle.com is a database name.
1521 is the listener port number.
mydb is a host name.
test.us.oracle.com is a net service name.
hr is a username.
test.us.oracle.com is an instance name.
第12题:
Configure multiple physical data sources and reuse the same JNDI name for each.
Use the compatibility option of Active GridLink to enable compatibility with non-Oracle databases.
Configure a single physical data source for each node in a database cluster and wrap it using Multi Data Source.
Configure a Data Source Group that contains a physical connection pool to each node in the database cluster.
第13题:
Which of the following options enables a user to get authenticated though a single password instead of using multiple passwords?()
第14题:
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? ()
第15题:
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?()
第16题:
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)?()
第17题:
by using the DBMS_REPAIR package
by using the DBVERIFY utility
by using Block Media Recovery
by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command
第18题:
setting the STATISTICS_LEVEL parameter to TYPICAL
adding filters to the Automatic Database Diagnostic Monitor (ADDM)
enabling Automated Maintenance Task using Oracle Enterprise Manager
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
第19题:
Load data from a disk, tape, or named pipes.
Load data into an Oracle database using DML statements.
Extract, reorganize, and insert data within an Oracle database.
Load data from external files into tables in an Oracle database.
Load data into an Oracle database using operating system commands.
Load data directly from a non-Oracle database to an Oracle database.
第20题:
Download patches from My Oracle Support and manage them using Smart Update.
Use Enterprise Manager to download patches from My Oracle Support and apply patches to WebLogic.
Download patches from My Oracle Support and manually modify the classpath of the application server (though it is not recommended).
Download patches from My Oracle Support and apply them using the WebLogic Admin Console.
Use the Admin Console to connect to My Oracle Support and download patches and then target them to the domain.
第21题:
setting the STATISTICS_LEVEL parameter to TYPICAL
adding filters to the Automatic Database Diagnostic Monitor (ADDM)
enabling Automated Maintenance Task using Oracle Enterprise Manager
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
第22题:
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.
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.
第23题:
when performing export and import using Oracle Data Pump
when performing backup and recovery operations using Oracle Recovery Manager
when performing batch processing and bulk loading operation in a data warehouse environment
in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time
第24题:
HTTP
IIOP
TCP/IP
Named Pipes
TCP/IP with SSL