If an MQT named Q1_SALES was created as follows:
Which statement will execute successfully?
A. ALTER TABLE q1_sales REFRESH IMMEDIATE
B. INSERT INTO q1_sales VALUES(80.2)
C. DELETE FROM q1_sales
D. REFRESH TABLE q1_sales
正解:D
質問 2:
Which SQL/XML publishing function can be used to convert XML data into other formats, including other XML schemas?
A. XSLCONVERT
B. XSLTRANSFORM
C. XSLELEMENT
D. XSLPARSE
正解:B
質問 3:
What type of Label-Based Access Control (LBAC) security label component is used to define a scale in which the first element listed represents the highest level of trust a person can have and the last element listed represents the lowest level of trust a person can have?
A. Array
B. Set
C. Range
D. Tree
正解:A
質問 4:
Which statement is NOT true about a database restore operation?
A. A table space is not usable until the restore operation completes successfully.
B. A user can restore a database from a backup image on a 32-bit level into a 64-bit level, but not vice versa.
C. A database restore operation requires an exclusive connection. No applications can run against the database while the operation is inprogress.
D. A table space restore operation must be done offline.
正解:D
質問 5:
What authority is required to create, alter and drop workload management objects?
A. SYSADM
B. ACCESSCTRL
C. WLMADM
D. SECADM
正解:C
質問 6:
Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?
A. IMPORT WITH BUFFERED INSERT
B. INGEST
C. REPLICATION
D. LOAD WITH READ ACCESS
正解:B
質問 7:
What is the purpose of the Design Advisor?
A. To recommend physical changes to objects in a database.
B. To generate profiles for autonomic activity within the database.
C. To recommend database configuration parameter changes.
D. To generate query definitions required to create usage reports.
正解:A
質問 8:
You have an High Availability and Disaster Recovery (HADR) environment set up and you want to read from the standby database. What must you do?
A. Execute the TAKEOVER HADR command to instruct the standby database to takeover as the new primary database.
B. Assign the value ON to the DB2_HADR_ROS registry variable.
C. Execute the STOP HADR command to temporarily break the HADR connection to the standby.
D. Assign the value ON to the DB2_HADR_SNAP registry variable.
正解:B
質問 9:
Which statement about BEFORE triggers is FALSE?
A. A BEFORE trigger is used to perform validation of input data and to automatically generate values for newly inserted rows.
B. A BEFORE trigger's action is executed for each row in the set of affected rows instead of executing the trigger event.
C. A BEFORE trigger's action is executed for each row in the set of affected rows before the trigger event executes.
D. A BEFORE trigger cannot be used to modify data in a database because they are activated before the trigger event is applied to the database.
正解:B
细川** -
C2090-611試験対策はこの問題集ひとつで充分足りるんじゃないかと思ってます。Pass4Testさんはいつも信用しております。