Given the following table definitions:
EMPLOYEE
ID NAME DEPTID
01Smith 10
02Bossy 20
03 20
Peterson
04Goss 30
05Pape 40
06Avery 50
07O'Neal 60
08Carter 50
DEPARTMENT ID DEPTNAME
05 Hardware 10 Kitchen 20 Shoes 30 Toys 40 Electronics 50 Automotive and the following query: SELECT e.id, d.deptname FROM employee e, department d WHERE e.deptid = d.id AND e.id > 4
Which of the following queries will produce the same result set as the query above?（）
An application needs a table for each connection that tracks the ID and Name of all items previously ordered and committed within the connection. The table also needs to be cleaned up and automatically removed each time a connection is ended. Assuming the ITEMS table was created with the following SQL statement:
CREATE TABLE items item_no INT, item_name CHAR(5), item_qty INT)
Which of the following SQL statements will provide the table definition that meets the specified requirements?（）
The storage specialist is presenting the IBM System Storage TS3500 Tape Library including TS1040 and TS1130 tape drives. The customer asks which third party software supports these drives.
Which of the following documents should the storage specialist consult?（）
Given the following two tables:
TAB1 C1 C2
1 Antarctica 2 Africa 3 Asia 4 Australia TAB2 CX CY
5 Europe 6 North America 7 South America
Which of the following SQL statements will insert all rows found in table TAB2 into table TAB1?（）
Given the following two tables:
TAB1 C1 C2
A 11 B 12 C 13 TAB2 CX CY
A 21 C 22 D 23
The following results are desired:
C1 C2 CX CY
A 11 A 21 C 13 C 22 -- --D 23
Which of the following queries will yield the desired results?（）
（）is the budgeted amount for the work actually completed on the schedule activity or WBS component during a given time period.
Consider the events_% tables in performance Schema.
Which two methods will clear or reset the collected events in the tables?（）
Consider the following statement on a RANGE partitioned table: ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?（）
Given that tables T1 and T2 contain the following rows:
Table T1: C1 C2 1 4 1 3 1 2
Table T2: C1 C2 1 1 1 2 1 3
Which of the following queries will return only those rows that exist in both T1 and T2?（）
Given that tables T1 and T2 contain the following rows: Table T1:
C1 C2
5 4 5 2 5 5
Table T2: C1 C2 5 1 5 2 5 3
Which of the following queries will return only those rows that exist in T1 and not in T2?（）
Following an unscheduled power outage, theadministrator needs to power up an IVM-managed system.
For the given system,what is the first step in this process?（）
When ordering a new IBM Power Systems server, a customer is given the option of two types of Hardware Management Console:7042-CR4 and 7042-C06.
Which main difference between the options would influence the customer's decision?（）
Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?（）
Given the following table definition:
STOCK: item VARCHAR(30) status CHAR(1) quantity INT price DEC(7,2)
If items are indicated to be out of stock by setting STATUS to NULL and QUANTITY and PRICE to zero, which of the following statements would be used to update the STOCK table to indicate that all the items whose description begins with the letter "S" are out of stock?（）
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.
You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）
You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:
ALTER TABLE employees SHRINK SPACE CASCADE;
Which statement is correct in this scenario?（）
You discover that your Recycle Bin contains two tables with the same name, MY_TABLE. You also have a table named MY_TABLE in your schema.You execute the following statement:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2;
What will be the result of executing this statement?（）
You are working in an online transaction processing (OLTP) environment. You use the FLASHBACKTABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.
Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?（）
免费的网站请分享给朋友吧