网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
29． Where are the basketballs?
A． On the table．
B． Behind the door．
C． Under the table．
D． In the． drawer．
参考答案
更多 “ 29． Where are the basketballs?A． On the table．B． Behind the door．C． Under the table．D． In the． drawer． ” 相关考题
考题
I'm terribly sorry that I've spilled some coffee on the table. ()A. I don't care.B. It doesn't matter.C. Don't be sorry.
考题
There are ________ on the table.
A.two glass of watersB.two glass of waterC.two glasses of watersD.two glasses of water
考题
You added a PHONE_NUMBER column of NUMBER data type to an existing EMPLOYEES table. The EMPLOYEES table already contains records of 100 employees. Now, you want to enter the phone numbers of each of the 100 employees into the table. Some of the employees may not have a phone number available. Which data manipulation operation do you perform? （）A. MERGEB. INSERTC. UPDATED. ADDE. ENTERF. You cannot enter the phone numbers for the existing employee records.
考题
Examine the data in the EMPLOYEES and DEPARTMENTS tables:Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables:On the EMPLOYEES table, EMPLOYEE_ID is the primary key.MGR_ID is the ID of managers and refers to the EMPLOYEE_ID.DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table.On the DEPARTMENTS table, DEPARTMENT_ID is the primary key.Examine this DELETE statement:What happens when you execute the DELETE statement?（）A. Only the row with department ID 40 is deleted in the DEPARTMENTS table.B. The statement fails because there are child records in the EMPLOYEES table with department ID 40.C. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.D. The row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.E. The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.F. The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
考题
Which of the following is a common location of the CMOS battery in a laptop?()
A. Under the keyboardB. Behind the removable hard driveC. Under the removable CD driveD. Behind the laptop battery
考题
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）A.SequenceB.Table FunctionC.Identity ColumnD.INSTEAD OF Trigger
考题
25． Where is the nurse-s house?A． Behind Mike's．B． Beside Jack's．C． Beside Mike's．D． Under Jack's．
考题
BHi! My name is Tina． I’m an American girl． I like sports and I like ping-pong best． Do you know my favorite ping-pong star? She's a Chinese girl and she's very beautiful． Her name is Wang Nan． Do you know her? I have a great photo of Wang Nan． It's on the wall of my room．Welcome to my room． It's a nice room． Look! 12 soccer balls are on the table． 10 volleyballs are under the table． Behind the door are 12 basketballs． Only 5 baseballs are in my drawer． But I don’t have a tennis racket． I don't like to play tennis．( )26．Wang Nan is a ________star．A． soccerB． basketballC． volleyballD． ping-pong
考题
Which of the following is a common location of the CMOS battery in a laptop?（）A、Under the keyboardB、Behind the removable hard driveC、Under the removable CD driveD、Behind the laptop battery
考题
A programmer wants to generate values for a numeric ID column in their EXPENSE table. The ID column values need to be incremented by 1000 for each new expense report added to the EXPENSE table. Which DB2 object can be referenced by an INSERT statement to meet thisrequirement?（）A、SequenceB、Table FunctionC、Identity ColumnD、INSTEAD OF Trigger
考题
Which action(s) will cause a compression dictionary to be removed from a table?（）A、Set the table COMPRESS attribute to NO. B、Set the table COMPRESS attribute to NO; run REORG against the table. C、Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table. D、Set the table COMPRESS attribute to NO; run RUNSTATS against the table.
考题
You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（） A、 Drop the table.B、 Partition the table.C、 Truncate the table.D、 Add a column to the table.E、 Rename a column in the table.
考题
The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table. Which multitable INSERT statement would you use？ （）A、 Pivoting INSERTB、 Unconditional INSERTC、 Conditional ALL INSERTD、 Conditional FIRST INSERT
考题
A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）A、 Flashback DropB、 Flashback QueryC、 Flashback Versions QueryD、 Flashback Transaction QueryE、 Flashback Table
考题
You are responsible for managing the database schema for an order entry application in a SQL Server 2005 database. After a design review, a member of the development staff asks you to add a new column named CommissionRate to the Product table. Because the actual commission rates for all products are not known at this time, each product has a default commission rate of 12 percent. The rate can be modified as necessary. You add the new column. You need to configure the table to assign the default value as efficiently as possible. What should you do?（）A、 Create an INSERT trigger to assign the default value to each item in the table. B、 Create a CHECK constraint to validate the data and to assign the default value to each item in the table. C、 Create an UPDATE trigger to update the default value for each new item in the table. D、 Create a DEFAULT constraint to assign the default value specifying the WITH VALUES argument.
考题
单选题The details of the order ID， order date， order total， and customer ID are obtained from the ORDERS table. If the order value is more than 30000， the details have to be added to the LARGEjDRDERS table. The order ID， order date， and order total should be added to the ORDERJHISTORY table， and order ID and customer ID should be added to the CUSTJHISTORY table. Which multitable INSERT statement would you use？ （）A
Pivoting INSERTB
Unconditional INSERTC
Conditional ALL INSERTD
Conditional FIRST INSERT
考题
单选题Which action(s) will cause a compression dictionary to be removed from a table?（）A
Set the table COMPRESS attribute to NO. B
Set the table COMPRESS attribute to NO; run REORG against the table. C
Set the table COMPRESS attribute to NO; run INSPECTRESETDICTIONARY against the table. D
Set the table COMPRESS attribute to NO; run RUNSTATS against the table.
考题
单选题You have a server that has very limited memory but has a very large table. You will use mysqldump to back up this table. Which option will ensure mysqldump will process a row at a time instead of buffering a set of rows?（）A
— quickB
— skip-bufferC
— single-transactionD
— tab
考题
单选题You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）A
Drop the table.B
Partition the table.C
Truncate the table.D
Add a column to the table.E
Rename a column in the table.
考题
单选题A user performs an update on a table. Shortly after committing the transaction， they realize that they had an error in their WHERE clause causing the wrong rows to be updated. Which Flashback option would allow you to undo this transaction and restore the table to its previous state？（）A
Flashback DropB
Flashback QueryC
Flashback Versions QueryD
Flashback Transaction QueryE
Flashback Table
考题
单选题EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）A
Exhibit AB
Exhibit BC
The query returns no rowsD
The query fails because the outer query is retrieving more than one columnE
The query fails because both the inner and outer queries are retrieving data from the same table.
热门标签
最新试卷