Which two statements about subqueries are true? （） A single row subquery can retrieve data from only one table.。 A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.。 A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.。 A single row subquery can retrieve data from more than one table.。 A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.。 A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.。
Which POWER6 virtualization technology is the minimum to enable multiple shared processor pool functionality？（） PowerHA Standard Edition。 PowerVM Standard Edition。 Power6 Management Edition。 Power6 Virtualization Editio。
Which NLS parameter can be used to change the default Oracle sort method from binary to linguistic for the SQL SELECT statement？（） NLS_LANG。 NLS_COMP。 NLS_SORT。 None of the above。
What is the minimum amount of memory required for a new LPAR to be built via NIM on AIX6.1（）？ 128 MB。 256 MB。 512 MB。 1024 MB。
User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（） It fails to delete the records because the records are locked in SHARE mode.。 It deletes the rows successfully because the table is locked in SHARE mode。 It fails to delete the records because the table is locked in EXCLUSIVE mode.。 It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.。
retail company plans to consolidate 180 existing dual processor Xeon servers, all running a web server application on Windows Server 2003. They are planning consolidating to a single x3950 X5 running vSphere.Which of the following should be discussed with this customer? （）
