Tag: technology

Questions Related to technology

Examine this procedure: CREATE OR REPLACE PROCEDURE UPD_BAT_STAT (V_ID IN NUMBER DEFAULT 10, V_AB IN NUMBER DEFAULT 4) IS BEGIN UPDATE PLAYER_BAT_STAT SET AT_BATS = AT_BATS + V_AB WHERE PLAYER_ID = V_ID; COMMIT; END; Which two statements will successfully invoke this procedure in SQL *Plus? (Choose two)
technology programming languages

  1. a) EXECUTE UPD_BAT_STAT;

  2. b) EXECUTE UPD_BAT_STAT(V_AB=>10, V_ID=>31);

  3. c) EXECUTE UPD_BAT_STAT(31, 'FOUR', 'TWO');

  4. d) UPD_BAT_STAT(V_AB=>10, V_ID=>31);

  5. e) RUN UPD_BAT_STAT;

Show answer
Correct Option: A,B

Which three are true regarding error propagation? (Choose three)
technology programming languages

  1. a) An exception cannot propagate across remote procedure calls.

  2. b) An exception raised inside a declaration immediately propagates to the current block.

  3. c) The use of the RAISE; statement in an exception handler reprises the current exception

  4. d) An exception raised inside an exception handler immediately propagates to the enclosing block.

Show answer
Correct Option: A,C,D

Which statements about JDBC are true? (2 answers)
technology programming languages

  1. [_] [a] JDBC is an API to connect to relational-, object- and XML data sources

  2. [_] [b] JDBC stands for Java DataBase Connectivity

  3. [_] [c] JDBC is an API to access relational databases, spreadsheets and flat files

  4. [_] [d] JDBC is an API to bridge the object-relational mismatch between OO programs and relational

Show answer
Correct Option: B,C

The file extension of Shared object repository file and Local object repository file are
technology testing

  1. (.TSR and .QRS)

  2. (.QRS and .MTR)

  3. (.TSR and .MTR)

  4. (.MTR and .QFL)

Show answer
Correct Option: C

Which packages contain the JDBC classes?
technology programming languages

  1. O (a) java.jdbc and javax.jdbc

  2. O (b) java.jdbc and java.jdbc.sql

  3. O (c) java.sql and javax.sql

  4. O (d) java.rdb and javax.rdb

Show answer
Correct Option: C
Explanation:

To answer this question, the user needs to have knowledge about the JDBC (Java Database Connectivity) API and its packages.

Option A: This option is incorrect. There is no package called javax.jdbc in the JDBC API.

Option B: This option is also incorrect. There is no package called java.jdbc.sql in the JDBC API.

Option C: This option is correct. The JDBC API contains two key packages: java.sql and javax.sql.

Option D: This option is incorrect. There is no package called java.rdb or javax.rdb in the JDBC API.

Therefore, the correct answer is:

The Answer is: C. java.sql and javax.sql.

In QTP which method is used to retrieve data from HTML TABLE?
technology testing

  1. GetCellData (Row,Col);

  2. GetRowValue (Rowid,Colname);

  3. GetData (Row,Col);

  4. GetCellValue (Row,Col);

Show answer
Correct Option: A

In QTP, what command is used to insert the transactions in test?
technology testing

  1. Services.StartTransaction "Name", Services.EndTransaction "Name";

  2. StartTransaction.Services “Name”,EndTransaction. Services "Name";

  3. StartTransaction ("Name"), EndTransaction ("Name");

  4. Services.StartTransaction "Name", EndTransaction. Services "Name";

Show answer
Correct Option: A

Which type of driver provides JDBC access via one or more ODBC drivers?
technology programming languages

  1. O (a) Type 1 driver

  2. O (b) Type 2 driver

  3. O (c) Type 3 driver

  4. O (d) Type 4 driver

Show answer
Correct Option: A

To refer the global data sheet, we can use the statement/statements
technology testing

  1. dtglobalsheet

  2. dtglobalsheet and Global

  3. dtGlobal and dtglobalsheet

  4. dtGlobal AND Global

Show answer
Correct Option: B

What is the standard for ethernet ?
technology

  1. 802.5

  2. 802.3

  3. 802.11

  4. 802.16

Show answer
Correct Option: B