A2090-556 試験問題を無料オンラインアクセス

What is the primary return code for an SQL statement executed by the database server?

• A.SQLWARN array
• B.SQLCODE field
• C.SQLSTATE value
• D.SQLERRD array

What does the UNION operator do?

• A.Combine two columns into one, eliminating duplicates.
• B.Combine two result sets, eliminating duplicates.
• C.Combine two regular tables into one.
• D.The same as the UNION ALL operator.

Given the following program code: What is the minimum privilege required to successfully execute the program?

• A.DBA
• B.CONNECT
• C.RESOURCE
• D.CREATE

Which statement about casting is correct?

• A.In most cases, you can explicitly cast a named row type to built-in data types without creating the cast.
• B.When you create a distinct data type, the database server automatically registers explicit casts from the distinct data type to the source data type and from the source data type to the distinct data type.
• C.You don't need create casts on distinct types to handle conversions between the new distinct data type and other data types in the database, the server takes care of that automatically.
• D.When you create an opaque data type, the server automatically define template casts to handle conversions between the internal and external representations of the opaque data type.

Table stock with columns stock_num, manu_code and price has following four rows in it

• A.3
• B.6
• C.4
• D.2