Which one is a system privilege?
SELECT
EXECUTE
ALTER TABLE
CREATE TABLE
DELETE
2) What is the file status for Logic error?
44
92
61
89
3) What compiler option would you use for dynamic linking?
DYNM
NDYNAM
DYNA
DYNAM
4) The maximum number of dimensions that an array can have in COBOL-85 is -----?
6
8
7
9
Which functions are available in SQL?
string and date
character and numeric
integer and conversion
calendar and date
date and conversion
translation and date
What is the maximum length of the field you can define using COMP-3?
12 bytes
16 bytes
14 bytes
10 bytes
Which three are true?
A MERGE statement is used to merge the data of one table with data from another.
A MERGE statement can be used to update existing rows in a table.
A MERGE statement replaces the data of one table with that of another.
A MERGE statement can be used to insert new rows into a table.
What is Web2.0?
Web as a platform
Web in mobile device
A standard
New architecture style
Which statements are true about constraints?
The UNIQUE constraint does not permit a null value for the column.
The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.
The NOT NULL constraint ensures that null values are not permitted for the column.
A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.
Which statements about subqueries are true?
A subquery should retrieve only one row.
A subquery can retrieve zero or more rows.
Subqueries CANNOT be nested by more than two levels.
A subquery can be used only in SQL query statements.
A subquery CANNOT be used in an SQL query statement that uses group functions.
When a subquery is used with an inequality comparison operator in the outer SQL statement,