Mainframe | Practice Questions | Aliensbrain

Multiple choice technology mainframe

What happens if both JOBLIB & STEPLIB is specified ?

STEPLIB will be ignored
JOBLIB will be ignored
Both are referred
JOBLIB overrides the STEPLIB

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

The DISP in the JCL is MOD, the dataset is already available and the program opens the file in OUTPUT mode. What happens ?

Records will be appended at the end
Records will be overwritten
Dataset will be deleted and records will be written by creating a new file
Job will abend

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Maximum number of steps in a job

16
255
256
No limit

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Which of the following DB2 data types CANNOT be used to contain the date an employee was hired?

TIMESTAMP
VARCHAR
TIME
CLOB

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Which of the following is defined on the dependent table to implement a referential constraint?

Primary Key
Check constraint
Foreign Key
Update trigger

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Given the DDL statement: CREATE TABLE newtab LIKE tab. Which of the following would occur as a result of the statement execution?

NEWTAB would have the same column names, attributes and referntial integrity as TAB.
NEWTAB would have the same column names and attributes as TAB.
NEWTAB would have the same column names, attributes, indexes and constraints as TAB.
NEWTAB would have the same column names, attributes and data as TAB.

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Which of the following occurs if an application ends abnormally during an active unit of work?

The unit of work moves to pending status
The unit of work moves to CHECK_PENDING
The unit of work is rolled back
The unit of work remains active

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Given the table: COUNTRY NAME CITIES PERSON Argentina 30 1 Cuba 20 2 Canada 10 2 Germany 40 1 Given the statement: SELECT name,cities FROM country Which of the following clauses must be added to the statement for it to return rows sorted by NAME ascending and then sorted by CITIES ascending?

ORDER BY 2,1
ORDER BY 2 ASC, 1 ASC
ORDER BY 1,2
ORDER BY 1 ASC, 2 ASC

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

Given the table COUNTRY: NAME CITIES PERSON Argentina 30 1 Cuba 20 2 Canada 10 2 Germany 40 1 Given the statement: SELECT name,cities FROM country Which of the following clauses must be added to the statement for it to return rows sorted by NAME ascending and then sorted by CITIES ascending?

ORDER BY 2,1
ORDER BY 2 ASC, 1 ASC
ORDER BY 1,2
ORDER BY 1 ASC, 2 ASC

Reveal answer Fill a bubble to check yourself

Multiple choice technology mainframe

ORDER BY 2,1
ORDER BY 2 ASC, 1 ASC
ORDER BY 1,2
ORDER BY 1 ASC, 2 ASC

Reveal answer Fill a bubble to check yourself

Tag: mainframe

Questions Related to mainframe