出自:Oracle认证

What are three facts about backups with mysqldump?（）
A:Can back up a remote database server
B:Allow a consistent backup to be taken
C:Are always faster to restore than binary backups
D:Are able to back up specific items within a database
E:Create automatically compressed backups
F:Will lock all storage engines for duration of backup
You work as a database administrator at Certkiller .com. In your production database， you observe that users’ transactions are consuming a lot of resource and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？ （）
A: CPU usage
B: degree of parallelism
C: number of open cursors
D: number of sorts performed
E: idle time for blocking sessions
F: number of disk I/O operations performed
G: number of memory I/O operations performed
进程监视进程（PMON）的作用是什么？
Which are /SQL*Plus commands? （）
A:INSERT
B:UPDATE
C:SELECT
D:DESCRIBE
E:DELETE
F:RENAME
Which three statements about subqueries are true?（）
A:A single row subquery can retrieve only one column and one row.
B:A single row subquery can retrieve only one row but many columns.
C:A multiple row subquery can retrieve multiple rows and multiple columns.
D:A multiple row subquery can be compared by using the ">" operator.
E:A single row subquery can use the IN operator.
F:A multiple row subquery can use the "=" operator.
The client connected to the database turns off his or her machine without exiting from a connection to the database. Which type of failure is this？（）
A:media
B:instance
C:statement
D:user process
Your application requires that you programmatically manipulate a nonquery record group. Which three built-ins can you use?（）
A:CREATE_GROUP 
B:ADD_GROUP_NOW 
C:POPULATE_GROUP 
D:ADD_GROUP_COLUMN 
E:CREATE_GROUP_FROM_QUERY
Examine the section of the Health Check report given below：   DBMS_HM.GET_RUN_REPORT（’HM_RUN_1061’）  Run Name ： HM_RUN_1061 Run Id ： 1061 Check Name ： Data Block Integrity Check Mode ： REACTIVE Status ： COMPLETED Start Time ： 2007-05-12 22：11：02.032292 -07：00 End  Time ：  2007-05-12 22：11：20.835135 -07：00 Error Encountered ： 0 Source Incident Id ： 7418 Number of Incidents Created ：0   Which two statements are true regarding the Health Check report？（）
A: Health Check was performed manually.
B: Health Check was performed to check the disk image block corruptions.
C: Health Check was performed to check interblock and intersegment corruption.
D: Health Check was performed to verify the integrity of database files and report failures.
E: Health Check was performed by the Health Monitor automatically in response to a critical error.
Examine the structure of the EMPLOYEES table: What is the correct syntax for an inline view?（）
A:
B:
C:
D:
Evaluate the SQL statement: SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual; What will be displayed?（）
A:0
B:1
C:0.00
D:An error statement
Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)
A:It contains only SQL profiles generated by SQL Tuning Advisor.
B:It stores plans generated by the optimizer using a stored outline.
C:It is part of the data dictionary and stored in the SYSAUX tablespace.
D:It is part of the data dictionary and stored in the SYSTEM tablespace.
E:It contains the statement log, the plan history, plan baselines, and SQL profiles.
You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB.  Which configuration could have enabled the block selection of 16 KB（）
A:choosing the extent allocation type to uniform
B:choosing the Segment Space Management option to manual
C:setting autoextension on for the data file mentioned for the tablespace
D:setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
Which of the following best describes a full backup? （）
A:All datafiles of a database 
B:All datafiles, archive logs, and control files 
C:All datafiles and control files 
D:All the used blocks in a datafile
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）
A:ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
B:MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
C:ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
D:MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
E:CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
F:You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
The database is configured for automatic archive logging. Along with the other required parameters， this entry is in the initialization file：log_archive_dest2="SERVICE=standby_db1 MANDATORY REOPEN=600" From where does the database resolve standby_db1？（）
A:control file
B:tnsnames.ora
C:data dictionary
D:initialization parameter file
下列选项中，能够解除HR用户的锁定的语句是（）。
A:alter user hr unlock
B:alter user hr account unlock
C:alter table alter hr unlock
D:alter table alter unlock hr
Which statements are true regarding table compression？（）
A: It saves disk space and reduces memory usage.
B: It saves disk space but has no effect on memory usage.
C: It incurs extra CPU overhead during DML as well as direct loading operations.
D: It incurs extra CPU overhead during DML but not direct loading operations.
E: It requires uncompress operation during I/O.
Oralce数据库中，以下（）函数可以针对任意数据类型进行操作。
A:TO_CHAR
B:LOWER
C:MAX
D:CEIL
打开游标的语句是（）。
A:OPEN
B:OPEN CURSOR
C:DECLARE CURSOR
D:FETCH
View the exhibit and examine the output. Which statement can be an inference from the output?（）
A:The FRA disk group has an asynchronous I/O bottleneck
B:The least number of I/Os are performed on the last data file in the list
C:The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the list
D:The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group
You want to use te Coherence Java APIs to directly cached POJOs. Consider this snippet of code： NamedCache cache - CacheFactory.getCache（"mycache"）；  cache.put（new Integer（I）f "hello"）； cache.put（T，"hi"）；  cache.put（new Long（II），"hey"）；  This code inserts three objects into the cache.  Why ？（）
A: hashCode（） and equals（） method for each object type is different so a different key is used
B: each object value string is different so a different value is inserted on each put
C: equals（） and compare（） method is different for each put
D: POF need to be implemented for this to work properly
The DB_BLOCK_CHECKING initialization parameter is set to FALSE. What level of block checking would be performed？（）
A: The Oracle database will not perform block checking for any of the data blocks.
B: The Oracle database will perform block checking for the default permanent tablespace only. 
C: The Oracle database will perform block checking for the data blocks in all user tablespaces.
D: The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only.
E: The Oracle database will perform block checking for the data blocks in the SYSTEM and SYSAUX tablespaces.
View the Exhibit and identify the component marked with a question mark.（）
A:Checkpoint （CKPT）
B:Process Monitor （PMON）
C:Archiver Processes （ARCn）
D:Recoverer Process （RECO）
E:Memory Manager process （MMAN）
Which two statements are true regarding B-tree indexs（）
A:The leaf blocks in the index are doubly linked.
B:The leaf node stores a bitmap for each key value.
C:The rows with NULL value in key columns also have entries in the index.
D:The deletion of a row from the table causes a logical deletion in index leaf block and the space becomesavailable for the new leaf entry
Given： What is the result？（）
A:test
B:Exception
C:Compilation fails.
D:NullPointerException
You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 2000 bytes. The column can currently hold 1000 bytes per value. The table contains 20000 rows.Which statement is valid?（）
A:ALTER TABLE commercials MODIFY (description CHAR2(2000));
B:ALTER TABLE commercials CHANGE (description CHAR2(2000));
C:ALTER TABLE commercials CHANGE (description VARCHAR2 (2000));
D:ALTER TABLE commercials MODIFY (description VARCHAR2 (2000));
E:You cannot increase the size of a column if the table has rows.
Consider the Mysql Enterprise Audit plugin. The following event detail is found in the audit log: Which two points can be concluded from the given event?（）
A:A connection as the user kate was successful
B:A connection failed due to authentication being unsuccessful
C:A connection was attempted via socket rather than TCP
D:A connection was blocked by a firewall or a similar security mechanism
E:A connection failed because the proxy user privileges did not match the login user
Given：   11. static class A {   12. void process（） throws Exception { throw new Exception（）； }   13. }   14. static class B extends A {   15. void process（） { System.out.println（"B "）； }   16. }   17. public static void main（String[] args） {   18. A a = new B（）；   19. a.process（）；   20. }   What is the result？ （）
A: Compilation fails because of an error in line 19.
B: An exception is thrown at runtime.
C: B
D: Compilation fails because of an error in line 18.
E: Compilation fails because of an error in line 15. 
F: The code runs with no output.
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000? （）
A:ORDER BY SALARY > 5000
B:GROUP BY SALARY > 5000
C:HAVING SALARY > 5000
D:WHERE SALARY > 5000
You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）
A:the time when the last flashback operation in your database was performed
B:the time when the first flashback operation in your database was performed
C:a list of flashback operations performed in your database using SCN and time
D:the approximate time and the lowest system change number （SCN） to which you can flash back your database
首页 <上一页 19 20 21 22 23 下一页> 尾页