Which is a valid wildcard character in a LIKE clause of a SELECT statement?
Which is a valid wildcard character in a LIKE clause of a SELECT statement?
Which set operators can be used to produce a result data set that contains only records that are not found in
Given the following queries:
SELECT c1 FROM tab1;
SELECT c1 FROM tab2;
Which set operators can be used to produce a result data set that contains only records that are
not found in the result data set produced by each query after duplicate rows have been
eliminated?
Which of the following is the cause?
Wallace is attempting to alter the roles assigned in a database. However, when he opens the
Access Control List for that database, he does not see any reference to roles. Which of the
following is the cause?
Which two statements are true about the HAVING clause?
Which two statements are true about the HAVING clause?
What rights will the user obtain automatically?
A user accesses a Domino database, via the Notes client, where he or she is not listed explicitly or
in a group contained in the Access Control List. What rights will the user obtain automatically?
which type of delete operation?
The following SQL statement:
DELETE FROM tab1 WHERE CURRENT OF csr1 WITH RR
Is used to perform which type of delete operation?
which describes the order of the rows in the result data set produced?
Given the following table definition:
If the following SELECT statement is executed, which describes the order of the rows in the result
data set produced?
SELECT * FROM sales
what must he do?
Jose wants to see the replication topology map of his Notes domain. To see this topology, what
must he do?
Which DB2 data types does NOT have a fixed length?
Which DB2 data types does NOT have a fixed length?
which of the following locations?
The inbox cleanup feature for user mailfiles may be set by the administrator in which of the
following locations?