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

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?

  1. Transactional replication

  2. Peer-to-peer replication

  3. Merge replication

  4. Snapshot replication

Correct Option: D

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

  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

Tools for importing and exporting data in sql server

  1. BULK insert

  2. BCP

  3. DTS

  4. All the above

Correct Option: D

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

  1. Lower send map; link.

  2. Lower logical level; return.

  3. Higher logical level; freemain

  4. Issued transaction ID; load.

Correct Option: B

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

  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
  1. TCP

  2. HTTP

  3. A and B

  4. None of the Above

Correct Option: C

Choose the incorrect option about the sql server index

  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

Which of the function is used to convert String to Number in java program?

  1. toNumber()

  2. conString()

  3. valueOf()

  4. None of the Above

Correct Option: C

AI Explanation

To convert a String to a Number in a Java program, the function used is the valueOf() function.

Let's go through each option to understand why it is correct or incorrect:

Option A) toNumber() - This option is incorrect because there is no built-in function in Java called toNumber().

Option B) conString() - This option is incorrect because the function name does not suggest any conversion from a String to a Number.

Option C) valueOf() - This option is correct because the valueOf() function is a built-in function in Java that can be used to convert a String to a Number.

Option D) None of the Above - This option is incorrect because the correct answer is option C) valueOf().

The correct answer is C) valueOf(). This option is correct because it is the function used to convert a String to a Number in a Java program.

Implementations of servlets include

  1. Apache web server

  2. java.net.HttpURLConnection class

  3. Java web server Tomcat

  4. None of the Above

Correct Option: C

The generic two-level data warehouse architecture includes which of the following?

  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

When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?

  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?





Correct Option: A

What is one of the disadvantages of database mirroring?

  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 command will delete all data from a table and will not write to the rollback segment?

  1. Drop

  2. Delete

  3. Cascade

  4. Truncate

Correct Option: D

Which of the following is not a method of a Connection Object in VB.NET?

  1. Open

  2. BeginTransaction

  3. Execute

  4. CommitTransaction

Correct Option: C

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