×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?
2.
A declared temporary table is used for which of the following purposes?
3.
Which of the following DB2 objects is NOT considered executable using SQL?
4.
Which of the following is NOT an accurate statement about views?
5.
Which of the following SQL statements can be used to create a DB2 object to store numerical data as EURO data?
6.
Which of the following DB2 objects are publicly referenced names that require no special authority or privilege to use them?
7.
Which of the following describes the objects of a DB2 database and their relationships?
8.
Which of the following database objects is considered executable using SQL?
9.
Given the following DDL and INSERT statements: CREATE VIEW v1 AS SELECT col1 FROM t1 WHERE col1 > 10; CREATE VIEW v2 AS SELECT col1 FROM v1 WITH CASCADED CHECK OPTION; CREATE VIEW v3 AS SELECT col1 FROM v2 WHERE col1 < 100; INSERT INTO v1 VALUES(5); INSERT INTO v2 VALUES(5); INSERT INTO v3 VALUES(20); INSERT INTO v3 VALUES(100); How many of these INSERT statements will be successful?
10.
When a client using the SERVER_ENCRYPT authentication type connects to a server using the SERVER authentication type, what happens?