不考虑分子的振动自由度，刚性双原子分子和刚性多原子分子的自由度分别为______、______。

打开过程文件BAG．prg的命令是______。

A．OPEN PROCED URE BAG .prg

B． SET PROCEDURE TO

C．SET PROCEDURE BAG .prg

D．SET PROCEDURE TO BAG .prg

res the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.

Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.

CREATE PROCEDURE GetCustomer

(@CustomerID Int )

AS

SELECT FirstName, LastName, Address1, Address2, City,

State, Zip, MAX(PurchaseDate) AS LastPurchase

FROM Customers C

JOIN Addresses A ON A.AddressID = C.AddressID

JOIN Purchases P ON P.CustomerID = C.CustomerID

WHERE C.CustomerID = @CustomerID

GROUP BY FirstName, LastName, Address1, Address2, City, State, Zip

You want to improve the performance of the procedure by using the least amount of administrative effort. What should you do？

A．Recompile the stored procedure.

B．Update the database statistics.

C．Check the consistency of the database and repair errors.

D．Create a view and modify the stored procedure to use the view.

A、CREATE PROCEDURE; EXECUTE; ALTER PROCEDURE; DROP PROCEDURE

B、CREATE PROCEDURE; EXECUTE; UPDATE PROCEDURE; DROP PROCEDURE

C、CREATE PROCEDURE; EXECUTE; UPDATE PROCEDURE; DELECT PROCEDURE

D、CREATE PROCEDURE; EXECUTE; ALTER PROCEDURE; DELECT PROCEDURE

Given the following statements:CREATE TABLE tab1 (col1 INT); CREATE TABLE tab2 (col1 INT); CREATE TRIGGER trig1 AFTER UPDATE ON tab1 REFERENCING NEW AS new1 FOR EACH ROW MODE DB2SQL INSERT INTO tab2 VALUES(new1.col1); INSERT INTO tab1 VALUES(2),(3);What is the result of the following query？ SELECT count(*) FROM tab2;（）

A.3

B.2

C.1

D.0

s of users that have access to information about member profiles. The name of the list is stored in the listName variable. The user name of the user to whom access is given is stored in the username variable.You need to enable members to manage their lists of users.Which code segment should you use？（）

A.

B.

C.

D.

A、CREATE PROCEDURE

B、CREATE TABLE

C、DROP PROCEDURE

D、其他

rter. Write your answer on the ANSWER SHEET.