Which of the following is NOT a valid DB2 Table Space?
Which of the following is NOT a valid DB2 Table Space?
Which one of the following is a valid XPATH expression to retrieve an attribute value within an XML document?
Which one of the following is a valid XPATH expression to retrieve an attribute value within an
XML document?
Which of the following statements is correct?
Which of the following statements is correct?
which of the following database objects?
The SELECT privilege is NOT available for which of the following database objects?
Which of the following commands can be used to undo operations executed inside a unit of work?
Which of the following commands can be used to undo operations executed inside a unit of work?
What would the result be?
Given the following tables with the given data:
STUDENT
——————name id
—– —–Jim 1
Sarah 2
Frank 3
PROFESSOR
——————name course
—– —–Jenny PHY_102
Mark MAT_202
Angie DB_101
Jenny CSI_201
ENROLL
——————student_id course_id
—— —–
2 PHY_102
2 DB_101
3 PHY_102
1 CSI_201
3 MAT_202
After executing the query:
SELECT P.name, COUNT AS COUNT FROM STUDENT LEFT JOIN ENROLL
ON id=student_id, PROFESSOR AS P
GROUP BY P.name
What would the result be?
If the current session has an isolation level of CS, which of the following will change the isolation level to
If the current session has an isolation level of CS, which of the following will change the isolation
level to UR for the current statement
The Data Manipulation Language is used to:
The Data Manipulation Language is used to:
which schema is the table MYTABLE created?
Consider the following scenario. You are currently connected to a database called MYDB as the
user MYUSER. When creating a table within this database, you use the command:
CREATE TABLE MYTABLE (DEPT CHAR(3) NOT NULL)
Under which schema is the table MYTABLE created?
Which of the following isolation levels lets you see data that has been updated by other applications before i
Which of the following isolation levels lets you see data that has been updated by other
applications before it is committed?