Oracle认证考试章节练习(2019.12.31)

多项选择题
What are four benefits of recommended basic architecture?（）
A.Good load balancing between Presentation Tier and Object Tier
B.Easy administration
C.Flexible Load balancing
D.Optimal performance
E.Simple security
多项选择题
Given：A programmer is developing a class Key， that will be used as a key in a standard java.util.HashMap. Which two methods should be overridden to assure that Key works correctly as a key？（）
A.public int hashCode（）
B.public boolean equals（Key k）
C.public int compareTo（Object o）
D.public boolean equals（Object o）
E.public boolean compareTo（Key k）
单项选择题
Given：11.String test = "Test A. Test B. Test C."；12.// insert code here13.String[] result = test.split（regex）；Which regular expression， inserted at line 12，correctly splits test into "Test A"，"Test B"，and "Test C"？（）
A.String regex = ""；
B.String regex = " "；
C.String regex = ".*"；
D.String regex = "\\s"；
E.String regex = "\\.\\s*"；
单项选择题
Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
A. modify the HASH_AREA_SIZE initialization parameter
B. modify the PGA_AGGREGATE_TARGET initialization parameter
C. modify the WORK_AREASIZE_POLICY initialization parameter
D. increase the value of the SGA_TARGET initialization parameter
E. increase the value of the SGA_MAX_SIZE initialization parameter
F. increase the value of the SORT_AREA_SIZE initialization parameter
单项选择题
Review the definition of the phone_list view.CHEATE OR REPLACE ALGORITHM=MERGE DEFINER= 'root'@localhost' SQL SECURITY DEFINER VIEW 'phone_list' AS SELECTe . id as id 'e . first_name AS 'first_name' 'e . last_name AS 'last_name' 'coalesce ( ph1.phone_no, ' – ') AS 'office_no' 'coalesce (ph2 .phone_no, ' – ') AS 'cell_no' FROM employees e LEFT JOIN employee_phone ph1 ON ph1.emp_id = e.id AND ph1.type = 'office' LEFT JOIN employee_phone ph2 ON ph2 .emp_id = e.id AND ph2 .type = 'mobile'The tables employees and employee_phone are InnoDB tables;all columns are used in this view. The contents of the phone_list view are as follows: Mysql> select * from phone_list; 1 row in set (0.00 sec)Which method can you use to change the cell_no value to '555-8888' for John Doe?（）
A.INSERT INTO employee_phone (emp_id, phone_no, type) VALUES (1, '555-8888','mobile')
B.UPDATE phone_list SET cell_name '555-8888' WHERE first_name= 'John' and last_name= 'Doe'
C.DELETE FROM phone_list WHERE first_name= 'John' and last_name= 'Doe'; INSERT INTO phone_list (first_name, last_name, office_no, cell_no) VALUES ('John' , 'Doe' , 'x1234' , '555-8888)
D.UPDATE employee_phone SET phone_no= '555-8888' where emp_id=1
单项选择题
An application is using WebLogic JMS Store and Forward to forward messages from a local JMS queue a remote WebLogic JMS destination. You need to determine if the messages are being sent from the local Weblogic Server.Where do you find information and metrics about Store and Forward components in the WebLogic Admin Console?（）
A.JMS Persistent Store
B.JMS Server
C.JMS Distributed Destination
D.JMS Store and Forward
E.Automatic Service Migration
单项选择题
You issued the following statement： SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What will be the result of issuing the statement？（）
A. The control file will be multiplexed.
B. The control file will be recreated.
C.The script containing the CREATE CONTROLFILE statement will be created.
D. The binary backup of the control file will be created.
多项选择题
In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
A.The database instance aborts.
B.The database operation temporarily halts till the member becomes available.
C.Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D.The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E.The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
单项选择题
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine？（）
A.host naming method
B.local naming method
C.external naming method
D.directory naming method
单项选择题
The INV_HISTORY table is created using the command： SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’））（partition p0 values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））； The following data has been inserted into the INV_HISTORY table ： INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000 You would like to store the data belonging to the year 2006 in a single partition and issue the command： SQL> ALTER TABLE inv_history MERGE PARTITIONS FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py； What would be the outcome of this command？（）
A. It executes successfully，and the transition point is set to ’1-apr-2006’.
B. It executes successfully，and the transition point is set to ’15-apr-2006’.
C. It produces an error because the partitions specified for merging are not adjacent.
D. It produces an error because the date values specified in the merge do not match the date values stored in the table.