Which can be inserted into TABLEA?
Given the statement:
CREATE TABLE tablea (col1 INTEGER NOT NULL,
CONSTRAINT const1 CHECK (col1 in (100, 200, 300))
Which can be inserted into TABLEA?
Which causes a lock that is being held by an application using the Cursor Stability isolation level to be rele
Which causes a lock that is being held by an application using the Cursor Stability isolation level to
be released?
Which is the best isolation level to use for this application?
A table contains a list of all seats available at a football stadium. A seat consists of a section
number, a seat number, and whether or not the seat has been assigned. A ticket agent working at
the box office generates a list of all unassigned seats. When the agent refreshes the list, it should
only change if another agent assigns one or more unassigned seats. Which is the best isolation
level to use for this application?
Which of the following is TRUE about CASCADE delete rule?
Which of the following is TRUE about CASCADE delete rule?
Query: SELECT * FROM TABLE T1 INNER JOIN T2 ON T1.ID = T2.ID is equivalent to?
Query: SELECT * FROM TABLE T1 INNER JOIN T2 ON T1.ID = T2.ID is equivalent to?
Which of the following is not TRUE for Repeatable Read?
Which of the following is not TRUE for Repeatable Read?
Which one of the following is true for Granting SYSADM authority to the group ‘grp’:
Which one of the following is true for Granting SYSADM authority to the group ‘grp’:
Which of the following false for Online Backup
Which of the following false for Online Backup
Which package privilege is required to rebind, drop or execute a package?
Which package privilege is required to rebind, drop or execute a package?
which of the following operations Trigger cannot be used?
On which of the following operations Trigger cannot be used?