Oracle认证 - 自考题库

出自:Oracle认证

Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）
A:DROP emp_dept_uv;
B:DELETE emp_dept_uv;
C:REMOVE emp_dept_uv;
D:DROP VIEW emp_dept_uv;
E:DELETE VIEW emp_dept_uv;
F:REMOVE VIEW emp_dept_uv;

Which four statements correctly describe functions that are available in SQL?（）
A:INSTR returns the numeric position of a named character.
B:NVL2 returns the first non-null expression in the expression list.
C:TRUNCATE rounds the column, expression, or value to n decimal places.
D:DECODE translates an expression after comparing it to each search value.
E:TRIM trims the heading of trailing characters (or both) from a character string.
F:NVL compares two expressions and returns null if they are equal, or the first expression of they are not equal.
G:NULLIF compares twp expressions and returns null if they are equal, or the first expression if they are not equal.

You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL> ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while performing the rebuild operation？（）
A: Index-organized table
B: Mapping Table
C: Clustered Table
D: Journal Table

Which three tasks can be performed using regular expression support in Oracle Database 10g？（）
A: it can be used to concatenate two strings.
B: it can be used to find out the total length of the string.
C: it can be used for string manipulation and searching operations.
D: it can be used to format the output for a column or expression having string data.
E: it can be used to find and replace operations for a column or expression having string data.

Which of the following statement is incorrect regarding RMAN？（）
A:It detects corrupt blocks.
B:It performs only offline database backups.
C:It omits empty blocks during backups.
D:It performs tablespace point-in-time recovery （TSPITR）.

You create a table in your database that contains 50，000 rows approximately. The queries performed on the table are complex and performed on the table frequently. Which advisor helps you achieve the best performance of database for queries by recommending the appropriate indexes？（）
A:SQL Access Advisor
B: Memory Advisor
C:SQL Tuning Advisor
D: Segment Advisor

Your database is running in the ARCHIVELOG mode. You placed a tablespace， tbs_1， offline with the immediate option. Which statement is correct in this scenario？（）
A:The operation would fail if tbs_1 were a read-only tablespace.
B:The operation would fail if tbs_1 were a read/write tablespace.
C:The operation would fail if tbs_1 were the default tablespace for the database.
D:If the above operation were successful， media recovery would be required to bring the tablespace online.
E:If the above operation were successful， instance recovery would be required to bring the tablespace online.

You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code？（） RMAN>RUN { SET UNTIL SEQUENCE THREAD ； RESTORE DATABASE； RECOVER DATABASE； }
A: NOMOUNT
B: MOUNT
C: OPEN
D: RESTRICTED

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 lost datafiles 1 and 3 from your database，and the database has crashed. In what order should you perform the following steps to recover your database？（） 1. Take the datafiles that were lost offline. 2. startup mount the database 3. Issue the alter database open command. 4. Restore the datafiles that were lost 5. Recover the datafiles with the recover datafile command. 6. Bring the datafiles back online. 7. Recover the database with the recover database command.
A: 2，1，3，4，5，6
B: 2，4，5，3
C: 4，7，3
D: 2，4，7，3
E: 2，7，3

Given:

and the command line: java -Dprop.custom=gobstopper Commander Which two, placed on line 13, will produce the output gobstopper?（）
A:System.load("prop.custom");
B:System.getenv("prop.custom");
C:System.property("prop.custom");
D:System.getProperty("prop.custom");
E:System.getProperties().getProperty("prop.custom");

Identify four uses of the Oracle Scheduler.（）
A: enables Oracle database to schedule which processes execute on which processors in a multiple CPU environment
B: enables Oracle database to do patches according to a DBA-defined schedule
C: enables you to schedule the execution of jobs based on time
D: enables you to execute jobs in a clustered environment
E: enables you to periodically execute operating systemscript files located on the same server as the database
F: enables you to create a job that makes use of saved programs and schedules
G: enables you to automate the management of the jobs that are created using the DBMS_JOB package

In the data model you created this query: SELECT ID_no, description, price, quantity, manufacturer_ID FROM inventory Next you click and drag the manufacturer_ID column out of and above the default group. You needed to sort the child group by ID_number. How could you accomplish this task? （）
A:Add an order by clause to the query.
B:In the data model double click the ID_number column and alter the break order.
C:In the layout model double click the ID_number filed and later the print direction.
D:Default the layout, choose a master/detail report style and select ID_number as the break order.

A UNIX user named Bob wants to replace his chess program with a new one， but he is not sure where theold one is installed. Bob is currently able to run a Java chess program starting from his home directory /home/bob using the command： java -classpath /test：/home/bob/downloads/*.jar games.Chess Bob’s CLASSPATH is set （at login time） to： /usr/lib：/home/bob/classes：/opt/java/lib：/opt/java/lib/*.jar What is a possible location for the Chess.class file？（）
A:/test/Chess.class
B:/home/bob/Chess.class
C:/test/games/Chess.class
D:/usr/lib/games/Chess.class
E:/home/bob/games/Chess.class

What does the FIND_MENU_ITEM built-in function return?（）
A:The internal ID of a menu.
B:The internal ID of a menu item.
C:The internal ID of a menu module.
D:The internal ID of form module to which the menu is attached.

Click the Exhibit button.

What is the result？（）
A:4321
B:0000
C:An exception is thrown at runtime.
D:Compilation fails because of an error in line 18.

Which of the following are valid settings for the NLS_COMP parameter？（）
A: ASCII
B: ANSI
C: BINARY
D: MONOLINGUAL
E: MULTILINGUAL

You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take？（）
A: Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE
B: Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE
C: Use compression when performing tape backups
D: Configure multiple SBT channels

To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?（）
A:From the Advisor Central home page, select the tuning task from the Advisor Tasks section.
B:From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results.
C:From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results.
D:Either B or C

You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups， and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file？（）
A:Restore all the data files and open the database
B:Create the data file and performtablespacerecovery
C:No need to restore any file， just recover the database
D:Restore only the system data file and recover the database
E:Restore only lost date file and performtablespacerecovery

Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) SAL NUMBER MGR_ID NUMBER DEPARTMENT_ID NUMBER You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a row with the specified values into the EMPLOYEES table. The INSERT statement should pass values to the table columns as specified below: EMPLOYEE_ID: Next value from the sequence EMP_ID_SEQEMP_NAME and JOB_ID: As specified by the user during run time, through substitution variables SAL: 2000 MGR_ID: No value DEPARTMENT_ID: Supplied by the user during run time through substitution variable. The INSERT statement should fail if the user supplies a value other than 20 or 50. Which INSERT statement meets the above requirements?（）
A:INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, &ename','&jobid', 2000, NULL, &did);
B:INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, '&ename', '&jobid', 2000, NULL, &did IN (20,50));
C:INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50)) VALUES (emp_id_seq.NEXTVAL, &ename','&jobid', 2000, NULL, &did);
D:INSERT INTO (SELECT * FROM employees WHERE department_id IN (20,50) WITH CHECK OPTION) VALUES (emp_id_seq.NEXTVAL, &ename','&jobid', 2000, NULL, &did);
E:INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, &ename','&jobid', 2000, NULL, &did);

Which two statements are true about simple views？（）
A:Views can be created as read only.
B:Views are data segments like tables.
C:Views can be created on the basis of more than one table.
D:Data manipulation language （DML） operations cannot be performed on views.

You are maintaining your database in Oracle10g. While performing an incremental backup of the database， you want to back uponly those blocks that have changed since the last backup. Which file will you create to increase the performance of the backup operation while performing the incremental backup of the database？（）
A: redo log files
B: password file
C: control file
D: change tracking file

Which three components does the Scheduler use for managing tasks within the Oracle environment？（）
A: a job
B: a program
C: a schedule
D: a PL/SQL procedure

In which two cases would you use an outer join? （）
A:The tables being joined have NOT NULL columns.
B:The tables being joined have only matched data.
C:The columns being joined have NULL values.
D:The tables being joined have only unmatched data.
E:The tables being joined have both matched and unmatched data.
F:Only when the tables have a primary key-foreign key relationship.

Examine the query and its output executed In an RDBMS Instance:Which three statements are true about the users (other than sys) in the output?（）
A:The C # # B_ADMIN user can perform all backup and recovery operations using RMAN only.
B:The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.
C:The C # # A_ADMIN user can perform wallet operations.
D:The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).
E:The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

Given a class whose instances, when found in a collection of objects, are sorted by using the compareTo（　）method, which two statements are true?（）
A:The class implements java.lang.Comparable.
B:The class implements java.util.Comparator.
C:The interface used to implement sorting allows this class to define only one sort sequence.
D:The interface used to implement sorting allows this class to define many different sort sequences.

NUMBER数据类型存储的最大精度是（）。
A:12
B:38
C:127
D:64

The SET CONTROLFILE AUTOBACKUP FORMAT command， which you can specify either within a RUN block or at the RMAN prompt， overrides the configured autobackup in the session only. What is the order of precedence？（） 1. SET within RUN 2. SET at RMAN prompt 3. CONFIGURE
A:1,2,3
B:2,3,1
C:3,2,1
D:There is no precedence between RUN and the RMAN prompt. Each will override CONFIGURE in the session.

Click the Exhibit（s） button to view the DEPARTMENTS plan.

After analyzing the Exhibit， what conclusion will you draw？（）
A: The CPU cannot be assigned to the members of the SYS_GROUP group.
B: The members of the OTHER_GROUPS group will always be assigned 100 percent CPU.
C: The members of the OTHER_GROUPS group will never be assigned 100 percent CPU.
D: The members of the OTHER_GROUPS group will be assigned 100 percent CPU if the CPU is not assigned to the members of the SYS_GROUP group and the PAYROLL， SALES， and MARKETING groups.

首页 <上一页 83 84 85 86 87 下一页> 尾页