0

databases Online Quiz - 48

Description: databases Online Quiz - 48
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

What does the Handle Aid command do?

  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.


Correct Option: A
  1. The number of bytes is compiler dependent

  2. 2

  3. 4

  4. 8


Correct Option: D

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

  1. A warm

  2. An emergency

  3. An auto

  4. A cold


Correct Option: D

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

  1. drop

  2. Delete

  3. truncate

  4. None of the Above


Correct Option: C
  1. Lower send map; link.

  2. Lower logical level; return.

  3. Higher logical level; freemain

  4. Issued transaction ID; load.


Correct Option: B
  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


Correct Option: C

Protocols supported by WCF

  1. TCP

  2. HTTP

  3. A and B

  4. None of the Above


Correct Option: C
  1. Indexes use B-TREE for searching data.

  2. Can create more than one non clustered index on a table.

  3. Up to 256 columns can be combined into a single composite index key.

  4. If not specified, a nonclustered index is created.


Correct Option: C
  1. toNumber()

  2. conString()

  3. valueOf()

  4. None of the Above


Correct Option: C
  1. Apache web server

  2. java.net.HttpURLConnection class

  3. Java web server Tomcat

  4. None of the Above


Correct Option: C
  1. At least one data mart

  2. Data that can extracted from numerous internal and external sources

  3. Near real-time updates

  4. All of the above.


Correct Option: B
  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Default tablespace for system


Correct Option: C

Which of the following views provides all the grants on all the objects in the database?

  1. DBA_SYS_PRIVS

  2. DBA_COL_PRIVS

  3. DBA_OBJ_PRIVS

  4. DBA_TAB_PRIVS


Correct Option: A
  1. You need to have the same hardware.

  2. The database you mirror to will be in an unused standby state.

  3. You cannot have automatic failover.

  4. You need to have at minimum three servers.


Correct Option: B

Which Oracle access method is the fastest way for Oracle to retrieve a single row?

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan


Correct Option: C
- Hide questions