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 _______.
Which TMFCOM command is used to recover a specific file, regardless of the flags set in the file label?
Which TMFCOM command is used to recover a specific file, regardless of the flags set in the file
label?
Which NonStop server feature supports enhanced application availability?
Which NonStop server feature supports enhanced application availability?
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 TMFCOM command can be used to display the name of the current audit trail file?
Which TMFCOM command can be used to display the name of the current audit trail file?
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 must be done to preserve the ACID properties of transactions?
What must be done to preserve the ACID properties of transactions?
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)?