Oracle认证 - 自考题库

出自:Oracle认证

Which statements are true regarding the creation of an incident package file by using the EMWorkbench Support（）
A:You can add SQL test cases to the incident package.
B:You can add or remove the trace files to the package.
C:You cannot create an incremental incident package when the physical files are purged from the ADR.
D:You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog. Given below are some of the commands required to achieve this: 1.SQL> GRANT recovery_catalog_owner TO vpc1; 2.RMAN> CONNECT CATALOG vpc1/password@catdb; 3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1; 4.RMAN> CONNECT CATALOG catowner/password@catdb; 5.RMAN> CREATE VIRTUAL CATALOG; What is the correct sequence in which the commands have to be executed?（）
A:1, 4, 5, 2, 3
B:1, 4, 3, 2, 5
C:4, 5, 2, 3, 1
D:2, 3, 4, 5, 1
E:1, 4, 2, 3, 5

In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non/x7fASM instance to an ASM instance？（）
A:Oracle Migration Assistant
B:Recovery Manager （RMAN）
C:Oracle Data Pump Export and Import
D:conventional Oracle Export and Import
E:operating system utilities to copy the files to the ASM instance

Which two operations can be performed on an external table（）
A:Create a view on the table.
B:Create an index on the table.
C:Create a synonym on the table.
D:Add a virtual column to the table.
E:Update the table using the UPDATE statement.
F:Delete rows in the table using the DELETE command.

以下关于ORACLE物理和逻辑存储结构的说法正确的是（）
A:表空间构成数据库，一个表空间可以同时为多个数据库所拥有
B:数据文件是构成表空间的物理基础，一个数据文件可以分属于不同的表空间
C:数据块是最小的存储单元，一个数据块对应一个操作系统块
D:区是由连续的数据块构成的，它是构成段的基础
E:区是不能跨数据文件的，由区构成成的段也不能跨数据文件

You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results? （）
A:CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B:CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C:GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***

Which SQL statement accepts user input for the columns to be displayed, the table name, and the WHERE condition?（）
A:SELECT &1, "&2" FROM &3 WHERE last_name = '&4';
B:SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';
C:SELECT &1, &2 FROM &3 WHERE last_name = '&4';
D:SELECT &1, '&2' FROM EMP WHERE last_name = '&4';

In a shared server configuration， which two describe the actions that the listener can take to service a client request？（）
A:The listener hands the connection request directly to a dispatcher.
B:A dedicated server inherits the connection request from the listener.
C:The client connects to a dedicated server directly using a protocol address provided by the listener.
D:The application initiating the session spawns a dedicated server process for the connection request.
E:The listener issues a redirect message to the client, containing the protocol address of a dispatcher. The client then terminates the network session to the listener and establishes a network session to the dispatcher, using the network address provided in the redirect message.

Which two statements are true regarding the functionality of the remap command in ASMCMD?（）
A:It repairs blocks that have read disk I/O errors.
B:It checks whether the alias metadata directory and the file directory are linked correctly.
C:It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D:It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

A Mysql instance is running on a dedicated server. Developers access the server from the same network subnet. Users access the database through an application that is running on a separate server in a DMZ. Which two will optimize the security of this setup?（）
A:Disabling connections from named pipes or socket files (depending on the operating system of the server)
B:Enabling and using SSL for connections to the Mysql database
C:Installing Mysql on the application server, and running the database and application on the same server
D:Starting the server with – bind- address=0.0.0.0 specified
E:Running the server with – skip-networking specified
F:Limiting logins to originate from the application server or the server's subnet'

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.

Which NLS parameter directly governs linguistic searches?（）
A:NLS_SEARCH_L
B:NLS_SORT
C:NLS_SEARCH
D:NLS_SORT_L
E:None of the above

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）
A:by using the SQL access advisor
B:by using the Automatic Workload Repository report
C:by running the Automatic Database Diagnostic Monitor （ADDM）
D:by using the Automatic Workload Repository Compare Period report
E:by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

Consider this syntax： MERGE INTO t1 USING t2 ON （join predicate）….. What does the MERGE syntax do？（）
A:It performs a merge join of the row from T2 only if it doesn’t exist in the T1 table.
B:It creates a natural join of tables T1 and T2 for all columns that have the same name.
C:It creates a Cartesian product of table T1 and table T2 for all columns that have the same name.
D:For each row from T2, it updates the row if it exists within table T1, otherwise it inserts the row into T1.

You are maintaining your database in Oracle10g. On Tuesday at 8：00 A.M.， while starting the database， you discover that all the control files are missing. The backup of the full database was performed on Sunday at 6：00 P.M. Which type of recovery will you perform？（）
A: incomplete recovery
B: complete recovery
C: recovery using the Flashback Database feature
D: recovery using the export/import utility

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

You executed the following command in Recovery Manager （RMAN）： RMAN> REPORT NEED BACKUP days 3； What is the output of this command？（）
A: a list of files that require a backup within three days
B: a list of files requiring more than 3 days of archive logs to apply
C: a list of files that RMAN recommends be backed up only once in every three days，based on low volatility
D: a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

以下（）进程，可以用于同步数据文件、日志文件和控制文件。
A:DBWR
B:LGWR
C:CKPT
D:PMON

You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）
A:Application Server Control
B:Oracle Management Service
C:Oracle Enterprise Manager Repository
D:Oracle Enterprise Manager Database Control

You executed the following command in the lsnrctl utility to stop the listener： lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your database？（）
A:It terminates all user sessions.
B:It prevents users from logging in to the database remotely.
C:It halts the server until all user transactions are completed.
D:The server hangs， so users will receive an error asking them to login again.
E:Connected users would get an error with the message "End of communication channel".

You run the following commands： RMAN> list expired backup； RMAN> delete expired backup； What will happen to the backup set pieces associated with the backups that appear in the list expired backup command？（）
A: They will be renamed.
B: Nothing will happen to them. The backup set pieces do not exist.
C: They will be deleted immediately since they are not in the flash recovery area.
D: You will need to manually remove the physical files listed in the output of the commands.
E: They will become hidden files and removed 10 days later.

Examine the SQL statements that creates ORDERS table:

For which columns would an index be automatically created when you execute the above SQL statement? （）
A:SER_NO
B:ORDER_ID
C:STATUS
D:PROD_ID
E:ORD_TOTAL
F:Composite index on ORDER_ID and ORDER_DATE

You executed the following command in Recovery Manager （RMAN） to perform a backup of the DETTBS tablespace： RMAN> BACKUP TABLESPACE DETTBS； Under which conditions would this command execute successfully？（）
A:The database is in NOMOUNT state.
B:The database is in ARCHIVELOG mode and the tablespace is online.
C:The database is in ARCHIVELOG mode and the tablespace is offline.
D:The database is in NOARCHIVELOG mode and the tablespace is online.
E:The database is in NOARCHIVELOG mode and the tablespace is offline.

Which three statements are true about persistent configuration？（）
A: A user cannot set privileges on the persistent lightweight jobs
B: Persistent lightweight jobs generate a large amount of metadata
C: It is possible to create fully self-contained persistent lightweight jobs
D: The use of a template is mandatory to create persistent lightweight jobs
E: Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? （）
A:ORACLE_BASE should be set explicitly.
B:An Oracle base should have only one Oracle home created in it.
C:Flash recovery area and data file location should be on separate disks.
D:Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

Which type of PL/SQL construct would you use to automatically correct the error resulting from a statement that was suspended due to a space/x7frelated problem？（）
A:function
B:package
C:procedure
D:database trigger
E:anonymous PL/SQL block

Which command would correctly start a TSPITR of the USERS tablespace？（）
A: recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary ，，c/oracle/auxiliary
B: recover tablespace users time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary； time ，， 10/06/2008：22：42：00 auxiliary destination ，，c/oracle/auxiliary
C: recover tablespace users to point-in.
D: recover tablespace users except time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary
E: recover tablespace users until time ，，10/06/2008：22：42：00 auxiliary destination ，，c：/oracle/auxiliary

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this？（）
A:The DBMS_JOB package
B:The BACKUP_JOB package
C:The DBMS_BACKUP_RESTORE package
D:The calendar tool in the Operating System （OS）
E:The backup scheduler in Enterprise Manager （EM）
F:The DBMS_BACKUP_SCHEDULER packager inline mode

Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
A:flash back the corrupted blocks
B:use the DBMS_REPAIR package
C:use the RMAN TSPITR command
D:use the RMAN BLOCKRECOVER command
E:use the RESTORE DATABASE and RECOVER DATABASE commands
F:investigate the time at which the corruption occurred and perform a point-in-time recovery

Which two statements are true about setting the per-thread buffers higher than required?（）
A:More memory per thread is beneficial in all scenarios
B:It causes increased overhead due to initial memory allocation
C:It can affect system stability during peak load times, due to swapping
D:It requires increasing the thread_cache_size variable

首页 <上一页 152 153 154 155 156 下一页> 尾页