On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）

相似题目

• Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode. E . The database operates in NOARCHIEVELOG mode.

  查看最佳答案

• 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 performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）

  A .  A user table was lost at the specified time. B .  A redo log file was lost at the specified time. C .  The backup control file is on a faster disk than the current one. D .  The current control file has a different path compared with the intended time of recovery. E .  The current control file does not match the physical structure of the database at the intended time of recovery.

  查看最佳答案

• You performed an incomplete recovery on your Oracle Database 10g database using the following command：  SQL> RECOVER DATABASE  2 UNTIL TIME ’2004­08­05：12：10：03’  3 USING BACKUP CONTROLFILE;  In which situation would the above recovery be required？（）

  A . A user table was lost at the specified time. B . A redo log file was lost at the specified time. C . The backup control file is on a faster disk than the current one. D . The current control file has a different path compared with the intended time of recovery. E . The current control file does not match the physical structure of the database at the intended time of recovery.

  查看最佳答案

• You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

  A . Compare Period ADDM report B . AWR Compare Period report C . Active Session History (ASH) report D . Taking a new snapshot and comparing it with a preserved snapshot

  查看最佳答案

• You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting？（）

  A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

  查看最佳答案

• You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）

  A . SYSTEM  B . OUTLN  C . INTERNAL  D . SYS

  查看最佳答案

• You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）

  A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

  查看最佳答案

• Your radar displays your ship off center．As you proceed on your course， your ship’s marker moves on the PPI scope while echoes from land masses remain stationary.What is this display called（）.

  A . Off center B . True motion C . Stabilized D . Head u

  查看最佳答案

• For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）  

  A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

  查看最佳答案

• You work as a database administrator for Supportcenter.cn. In your Oracle database 10g installation you have set ORACLE_BASE to /u01/app/oracle. Which objective will be achieved by this setting？（）

  A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

  查看最佳答案

• You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?（）

  A . LOGICAL_READS_PER_SESSION  B . CONNECT_TIME  C . COMPOSITE_LIMIT  D . CPU_PER_SESSION  E . PRIVATE_SGA

  查看最佳答案

• Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode.  E . The database operates in NOARCHIEVELOG mode.

  查看最佳答案

• 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.&e

  查看最佳答案

• You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）

  A .  The DBWn process writes to the datafile. B .  Changes in the background process are recorded. C .  The log file is updated with the current SCN number. D .  The System Change Number （SCN） is recorded in the control file. E .  The changes to the listener configuration in the listener.ora file are recorded.

  查看最佳答案

• Your assigned emergency stations aboard your vessel can be found on the ships （）.

  A . muster list B . certificate of inspection C . clearance papers D . permit to proceed

  查看最佳答案

• Which Cisco SDM feature allows you to specify whether you want SDM files installed on your PC or on your router？（）  

  A .  Install Shield Wizard B .  Cisco SDM Express Wizard C .  Cisco SDM Image Manager D .  Create Connection Wizard

  查看最佳答案

• A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）

  A . The value for MINEXTENTS setting  B . The value for PCTINCREASE setting  C . The value for MAXEXTENTS setting  D . By default, Oracle allocates six extents to all database object

  查看最佳答案

• In WebLogic 10.3.6 and WebLogic 12c on ExaLogic, performance of JMS is further improved through （）.

  A . Web Session Affinity B . Concurrent Request Manager C . Coherence D . Elastic Message Overflow

  查看最佳答案

• The Oracle Net architecture is based on which of the following？（）

  A . OCI B . OSI C . TCP/IP D . SNMP

  查看最佳答案

• You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?（）

  A . A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rows B . All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application. C . A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows. D . A TOP-N query is created to limit the rows to 20 percent of the total row

  查看最佳答案

• Write down your opinions on demonstration

  查看最佳答案

• You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB).The characteristics of the non-CDB are as follows:-Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National characterset: AL16UTF16 -O/S: Oracle Linux 6 64-bitThe characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Characterset: AL32UTF8 -O/S: Oracle Linux 6 64-bitWhich technique should you use to minimize down time while plugging this non-CDB into the CDB？（）

  A. Transportable database B. Transportable tablespace C. Data Pump full export / import D. The DBMS_PDB package E. RMAN

  查看最佳答案

• The following parameter are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSEOPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1. Set the evolve task parameters.2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASKfunction.4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.Identify the correct sequence of steps:（）

  A.2，4，5 B.2，1，4，3，5 C.1，2，3，4，5 D.1，2，4，5

  查看最佳答案