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

What is used in conjunction with a foreign key to define a relationship between two tables?

• A.Unique constraint
• B.Primary key
• C.Partitioning key
• D.Check constraint

When an index is created for a table, where is the metadata for that index stored?

• A.In the table definition.
• B.In the metadata of the table the index was created for.
• C.In the system catalog.
• D.In the schema that the index resides in.

User USER1 holds both DBADM and SECADM authority and you want to separate database administration activities from security administration tasks. What authority must you have in order to revoke SECADM authority from user USER1 and assign it to someone else?

• A.DBCTRL
• B.SECADM
• C.DBADM
• D.DBMAINT

When is an INTENT EXCLUSIVE (IX) lock required?

• A.When a transaction intends to change the system catalog.
• B.When a transaction intends to change but not read data.
• C.When a transaction intends to read or change data.
• D.When a transaction intends to read but not change data.

What type of mechanism is a simple token value that is used to refer to a much bigger large object (LOB)?

• A.reference
• B.locator
• C.address
• D.pointer