Tag: mainframe

Questions Related to mainframe

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

technology mainframe

  1. NEWTAB would have the same column names, attributes and referntial integrity as TAB.

  2. NEWTAB would have the same column names and attributes as TAB.

  3. NEWTAB would have the same column names, attributes, indexes and constraints as TAB.

  4. NEWTAB would have the same column names, attributes and data as TAB.

Show answer
Correct Option: B

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

technology mainframe

  1. The unit of work moves to pending status

  2. The unit of work moves to CHECK_PENDING

  3. The unit of work is rolled back

  4. The unit of work remains active

Show answer
Correct Option: C

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?
technology mainframe

  1. ORDER BY 2,1

  2. ORDER BY 2 ASC, 1 ASC

  3. ORDER BY 1,2

  4. ORDER BY 1 ASC, 2 ASC

Show answer
Correct Option: C,D

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?
technology mainframe

  1. ORDER BY 2,1

  2. ORDER BY 2 ASC, 1 ASC

  3. ORDER BY 1,2

  4. ORDER BY 1 ASC, 2 ASC

Show answer
Correct Option: C,D

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?
technology mainframe

  1. ORDER BY 2,1

  2. ORDER BY 2 ASC, 1 ASC

  3. ORDER BY 1,2

  4. ORDER BY 1 ASC, 2 ASC

Show answer
Correct Option: C,D

Use OCCURS clause at 01 level

technology mainframe

  1. True

  2. False

Show answer
Correct Option: B

What does CICS stand for

technology mainframe

  1. Customer Interface Control System

  2. Central Information Control System

  3. Customer Information Control System

  4. Computing Instructions Control System

Show answer
Correct Option: C

What does DASD stand for
technology mainframe

  1. Data Systems Authorization Directory

  2. Direct Access Storage Device

  3. Data Systems Storage Device

  4. Digital's Attempted Storage Domination

Show answer
Correct Option: B

What does RACF stand for

technology mainframe

  1. Resource Allocation Control Facility

  2. Really Alarming Computing Fact

  3. Remote Access Computing Facility

  4. Resource Access Control Facility

Show answer
Correct Option: D

What does MVS stand for
technology mainframe

  1. Mainframe Virtual System

  2. Multiple Virtualization System

  3. Multiple Virtual Storage

  4. Mainframe Virtualization System

Show answer
Correct Option: C