Where is configuration information for parallel index loading maintained?
Where is configuration information for parallel index loading maintained?
Which catalog table stores the SIMILARITY CHECK flag?
Which catalog table stores the SIMILARITY CHECK flag?
In order to distribute an SQL table across nodes, you must have _______.
In order to distribute an SQL table across nodes, you must have _______.
The correct OSS command used to SQL compile the native C program "sqlprog.c" is _______.
The correct OSS command used to SQL compile the native C program “sqlprog.c” is _______.
This statement makes use of the CLUSTERING KEY option_______.
CREATE TABLE names (last_name CHAR(30), first_name CHAR(30), location VARCHAR(200))
CLUSTERING KEY (last_name, first_name); This statement makes use of the CLUSTERING KEY
option_______.
Which NonStop server feature supports enhanced application availability?
Which NonStop server feature supports enhanced application availability?
Which INSERT command will fail with an error?
Given the table definition:
(CUSTNUM NUMERIC (6,0) NO DEFAULT NOT NULL,
CUSTNAME PIC X(20) DEFAULT NULL,
STREET VARCHAR(100) DEFAULT NULL,
CITY VARCHAR(40) DEFAULT NULL,
ZIP CHAR(5) DEFAULT “00000”)
Which INSERT command will fail with an error?
Which operation does the optimizer perform first?
Which operation does the optimizer perform first?
What is the heading output for SELECT MAX(DOB)?
A column definition includes DOB DATE HEADING “Birth Date”. What is the heading output for
SELECT MAX(DOB)?
Which PARTITION clause is valid to complete the statement?
Click the Exhibit button.
The exhibit shows an incomplete table creation statement. Which PARTITION clause is valid to complete the statement?