出自:Oracle认证

You noticed that the index tablespace in your database requires a recovery. However， instead of performing a media recovery， you decided to re/x7fcreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to re/x7fcreate the indexes？（）
A:ONLINE
B:REVERSE
C:PARALLEL
D:COMPRESS
E:NOLOGGING
F:COMPUTE STATISTICS
Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）
A:It is the time period after which the undo data becomes obsolete.
B:It is the time period after which the committed undo data would be transferred to a temporarytablespace.
C:It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.
D:It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following：  a） high availability of data  b） faster primary key access to the table data  c） compact storage for the table  Which type of tables would you use to achieve these objectives？（）
A:heap tables
B:object tables
C:partitioned tables
D:index­organized tables （IOTs）
You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）
A: assign users to consumer groups
B: set the resource plan for the instance
C: configure a simple resource plan and specify plan directives
D: configure a complex resource plan and specify plan directives
You work as a database administrator for Certkiller .com. 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 notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）
A:Enable Memory Access Mode, which reads performance data from SGA.
B:Use emergency monitoring to fetch data directly from SGA analysis.
C:Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
D:Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
E:Run ADDM in diagnostic mode.
Click the Exhibit button to examine the data of the EMPLOYEES table. Evaluate this SQL statement: SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary > 4000; What is its output?（）
A:A
B:B
C:C
D:D
E:E
Given： What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:[608， 610， 612， 629] [608， 610]
D:[608， 610， 612， 629] [608， 610， 629]
E:[606， 608， 610， 612， 629] [608， 610]
A subquery can be used to（）.
A:Create groups of data
B:Sort data in a specific order
C:Convert data to a different format
D:Retrieve data based on an unknown condition
Which Oracle Database component is audited by default if the unified Auditing option is enabled?（）
A:Oracle Data Pump
B:Oracle Recovery Manager (RMAN)
C:Oracle Label Security
D:Oracle Database Vault
E:Oracle Real Application Security
Which statement is true about loading data using the conventional path of SQL*Loader（）
A:Redo is not generated while performing conventional path loads.
B:Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
C:No exclusive locks are acquired when the conventional path loads are performed.
D:Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
E:INSERT triggers are disabled before the conventional path load and reenabled at the end of the load
Which operator can be used with a multiple-row subquery? （）
A:=
B:LIKE
C:BETWEEN
D:NOT IN
E:IS
F:<>
What is true about this statement used during import？（） imp hr/hr tables= （employee， departments） file=hr.dmp ignore=y
A:It ignores duplicates.
B:It prevents character set translation on import.
C:It allows rows to be inserted into a table that already exists.
D:It ignores storage parameters in the DML executed during import.
You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）
A:Use the DROP DATAFILE command.
B:Use the DROP TABLESPACE command.
C:Ensure that all database files are Oracle Managed Files before using the DROP TABLESPACE command.
D:Ensure that the DB_FILE_CREATE_DEST initialization parameter is set before using the DROP TABLESPACE command.
Which are DML statements? （）
A:COMMIT
B:MERGE
C:UPDATE
D:DELETE
E:CREATE
F:DROP
The database is being restored from a closed backup. The data files， control files， password file， and parameter file are available， but the online redo logs are not. Because the online redo logs are not available， you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation？（）
A:until SCN
B:until time
C:until cancel
D:using backup control file
Evaluate the SQL statement:SELECT ROUND(45.953, -1), TRUNC(45.936, 2)FROM dual;Which values are displayed?（）
A:46 and 45
B:46 and 45.93
C:50 and 45.93
D:50 and 45.9
E:45 and 45.93
F:45.95 and 45.93
Which data dictionary table should you query to view the object privileges granted to the user on specific columns? （）
A:USER_TAB_PRIVS_MADE
B:USER_TAB_PRIVS
C:USER_COL_PRIVS_MADE
D:USER_COL_PRIVS
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? （）(Choose two)
A:You must configure block change tracking file
B:You must have first level 1 backups for RMAN to restore blocks
C:You must ensure that the SALES database is mounted or open
D:You must have full or level 0 backups for RMAN to restore blocks
E:You must take the tools01.dbf data file offline before you start a block media recovery
You executed the following code：   BEGIN   DBMS_SCHEDULER.SET_ATTRIBUTE  （  NAME => ’JOB_A’，   ATTRIBUTE => ’JOB_PRIORITY’，   VALUE => 7）；   END；  /   After analyzing the above code， what conclusion will you draw？（）  
A: The code will be executed successfully.
B: The code will not be executed successfully because the value of the VALUE parameter must be 1， 2， or 3.
C: The code will not be executed successfully because the value of the VALUE parameter must range between 1 and 5.
D: The code will not be executed successfully because no SET_ATTRIBUTE procedure exists in the DBMS_SCHDULER package.
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework? （）
A:SQL statements that are part of the AWR baseline only 
B:SQL statements based on the AWR top SQL identification
C:SQL statements that are part of the available SQL Tuning Set (STS) only 
D:SQL statements that are available in the cursor cache and executed by a user other than SYS 
Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）
A:The SKD user cannot log in to the database instance.
B:The objects owned by the SKD user are not accessible to any user.
C:The other users can access the objects owned by the SKD user， on which they have access.
D:The password for the SKD user expires and the user is forced to change the password at the next log in.
Node Manager is a WebLogic Server （） that enables you to start， shut down， and restart Administration Server and Managed Server from a remote location.
A: Instance
B: Utility
C: Destination
D: Ouster
As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL> select group_number， name， state from v$ASM_DISKGROUP；  GROUP_NUMBER NAME STATE  0 DGROUP1 DISMOUNTED  2 DGROUP2 MOUNTED  3 DGROUP3 MOUNTED  
A: The DGROUP1 disk group was unmounted by another DBA.
B: A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
C: One of the redundant disks （DGROUP1） has been lost in a disk group.
D: This query has no meaning in an ASM instance.
E: A disk associated with a disk group was discovered after the ASM instance initially opened.
A user executes a query on the EMPtable， which contains thousands of rows， to get details about employees in one of the departments. The user receives the following error：  SQL> SELECT ename FROM emp WHERE deptno=10 ORDER BY sal；  SELECT ename FROM emp WHERE deptno=10 ORDER BY sal  ERROR at line 1：  ORA-01157： cannot identify/lock data file  201 - see DBWR trace file ORA-01110： data file 201：’/u01/app/oracle/oradata/orcl/temp01.dbf’  What is a possible reason？（）
A: The tempfile belonging to the default temporary tablespace is missing.
B: The database is opened in restricted mode， so queries are not allowed
C: The default temporary tablespace required to execute the query is offline.
D: The default temporary tablespace required to execute the query is dropped.
E: The default temporary tablespace required to execute the query is read-only.
Identify three benefits of Unified Auditing.（）
A:Decreased use of storage to store audit trail rows in the database.
B:It improves overall auditing performance.
C:It guarantees zero-loss auditing.
D:The audit trail cannot be easily modified because it is read-only.
E:It automatically audits Recovery Manager (RMAN) events.
当需要描述一个表table1对象结构时，可以使用（）。
A:DES table1
B:DESC table1
C:DESCR table1
D:DESCRIB table1
下列的哪个子句在SELECT语句中用于排序结果集？（）
A:Having子句
B:Where子句
C:From子句
D:Order by子句
The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members？（）
A: V$LOG
B: V$LOGFILE
C: DBA_LOG_GROUPS
D: V$LOG_HISTORY
Which two statements are true regarding the SGA_TARGET initialization parameter（）
A:It can be increased up to the value of the SGA_MAX_SIZE parameter.
B:Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.
C:Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.
D:Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.
首页 <上一页 39 40 41 42 43 下一页> 尾页