Which join methods does NonStop SQL support?
Which join methods does NonStop SQL support?
Which statement will most likely use index-only access?
A large table $D.A.T (EmployeeNo (primaryKey), Name, LastName, Salary, Dept, Address) has an
index (Name, LastName) Which statement will most likely use index-only access?
which PARTITION ARRAY attribute must be specified for the table?
To mix Format 1 and Format 2 partitions in the same table, which PARTITION ARRAY attribute
must be specified for the table?
SQLCODE is a variable in a host program to which SQL returns _______.
SQLCODE is a variable in a host program to which SQL returns _______.
Which clause can change this behavior for an SQL object?
The Storage Management Foundation (SMF) allows a collection of disk volumes to be configured
as a virtual volume. Generally the actual disk used for a file assigned to a virtual volume is
determined by SMF. Which clause can change this behavior for an SQL object?
What should you do?
Your application receives an SQL Error 8204 (Lost Open Error) on a FETCH statement. What
should you do?
How is this accomplished?
In order to simulate the production environment for compilations on a test system, it is possible to
move statistics from the production environment to the test environment. How is this
accomplished?
Which statement is valid?
Click the Exhibit button.
The exhibit shows the definition of table CUSTOMER and view V1. Which statement is valid?
Which combination of SQLCI commands can be used to capture a row layout for inclusion in a host language progr
Which combination of SQLCI commands can be used to capture a row layout for inclusion in a
host language program?
Where can text explanations of SQL error numbers be found?
Where can text explanations of SQL error numbers be found? Select TWO.