Tag: databases

Questions Related to databases

Where do sync points occur in a Transaction?
technology databases

  1. At the beginning

  2. At the end

  3. Where they are programmed

  4. After each READ FOR UPDATE command

Show answer
Correct Option: D

What does the Handle Aid command do?
technology databases

  1. It specifies terminal keys and/or other attention identifiers with corresponding routines for execution.

  2. It automatically tries to correct error storage abends.

  3. It identifies status codes on file reads to determine error messages.

  4. It sets all PF-keys to ANSI standards where pre-processing proceeds to generate logic for routines necessary.

Show answer
Correct Option: A

You want to create a replication strategy that will allow users in four branch offices to have a fresh copy of data from the database in the central office every day at 5 a.m. for their daily reports. Although there are many changes to the data during the course of a day, the entire publication is not that large. Which replication strategy should you use?

technology databases

  1. Transactional replication

  2. Peer-to-peer replication

  3. Merge replication

  4. Snapshot replication

Show answer
Correct Option: D

What is the number of bytes used by Java primitive long?

technology databases

  1. The number of bytes is compiler dependent

  2. 2

  3. 4

  4. 8

Show answer
Correct Option: D

During which start, CICS does not try to match the state of resources to their state before shutdown?
technology databases

  1. A warm

  2. An emergency

  3. An auto

  4. A cold

Show answer
Correct Option: D

Which statement is used to delete all rows in a table without having the action logged?

technology databases

  1. drop

  2. Delete

  3. truncate

  4. None of the Above

Show answer
Correct Option: C

Tools for importing and exporting data in sql server
technology databases

  1. BULK insert

  2. BCP

  3. DTS

  4. All the above

Show answer
Correct Option: D

The link command can call another program at the next __________ control when the last program issues a ____________.

technology databases

  1. Lower send map; link.

  2. Lower logical level; return.

  3. Higher logical level; freemain

  4. Issued transaction ID; load.

Show answer
Correct Option: B

If MENU links to MENU2, what action does CICS take when MENU2 issues a RETURN command?

technology databases

  1. It starts executing at the beginning of MENU

  2. It starts a new task called MENU

  3. It returns to the statement after the LINK command in MENU

  4. It links to MENU

Show answer
Correct Option: C

Protocols supported by WCF

technology databases

  1. TCP

  2. HTTP

  3. A and B

  4. None of the Above

Show answer
Correct Option: C