• databases Online Quiz - 48
Back
0

databases Online Quiz - 48

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

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

Choose the incorrect option about the sql server index

technology databases

  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.

Show answer
Correct Option: C

Interface methods can be declared with which the following modifiers

technology databases

  1. public

  2. private

  3. synchronised

  4. native

Show answer
Correct Option: A

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

technology databases

  1. toNumber()

  2. conString()

  3. valueOf()

  4. None of the Above

Show answer
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

technology databases

  1. Apache web server

  2. java.net.HttpURLConnection class

  3. Java web server Tomcat

  4. None of the Above

Show answer
Correct Option: C

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

technology databases

  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.

Show answer
Correct Option: B

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

technology databases

  1. System tablespace

  2. Users tablespace

  3. Default tablespace for the user

  4. Default tablespace for system

Show answer
Correct Option: C

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

technology databases

  1. DBA_SYS_PRIVS

  2. DBA_COL_PRIVS

  3. DBA_OBJ_PRIVS

  4. DBA_TAB_PRIVS

Show answer
Correct Option: A

What is one of the disadvantages of database mirroring?

technology databases

  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.

Show answer
Correct Option: B

Which command will delete all data from a table and will not write to the rollback segment?

technology databases

  1. Drop

  2. Delete

  3. Cascade

  4. Truncate

Show answer
Correct Option: D

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

technology databases

  1. Open

  2. BeginTransaction

  3. Execute

  4. CommitTransaction

Show answer
Correct Option: C

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

technology databases

  1. Primary key access

  2. Access via unique index

  3. Table access by ROWID

  4. Full table scan

Show answer
Correct Option: C
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions