which built-in data types CANNOT be used to store the day an employee was hired?
Given the requirements to store employee names, employee numbers, and when employees were
hired, which built-in data types CANNOT be used to store the day an employee was hired?
Which two are optional and do not have to be specified when creating a table?
Which two are optional and do not have to be specified when creating a table?
Which of the following provides that functionality?
Users in your environment have been contacting update sites and updating composite applications
on their own. Your company wishes to restrict the users from this ability. Which of the following
provides that functionality?
Which CANNOT be used to restrict specific values from being inserted into a column in a particular table?
Which CANNOT be used to restrict specific values from being inserted into a column in a
particular table?
Which of the following abilities would allow the administrators to set the policy value at one time?
The General Marble Corporation has decided to let users choose their own final values for their
desktop settings. They want to provide a basic deployment through policies. Which of the following
abilities would allow the administrators to set the policy value at one time?
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 of the following?
The purpose of the RnRMgr task is which of the following?
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?
What can Mike use to determine the effect of the new policies on his users?
Mike needs to determine how a set of new policies will affect his users. What can Mike use to
determine the effect of the new policies on his users?
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?