Tag: technology

Questions Related to technology

What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual?
technology databases

  1. NULL

  2. NOT NULL

  3. Function NVL2 is not defined

  4. None of the above

Show answer
Correct Option: A
Explanation:

To solve this question, the user needs to know the function NVL2 in SQL.

The NVL2 function in SQL returns one value if an expression is not null, or another value if it is null. The syntax for the NVL2 function is:

NVL2( expression1, expression2, expression3 )

If expression1 is not null, then NVL2 returns expression2. If expression1 is null, then NVL2 returns expression3.

In this case, expression1 is NULL, so NVL2 will return the value of expression3, which is also NULL.

Therefore, the answer is:

The Answer is: A. NULL

Functions for error trapping are contained in which section of a PL/SQL block?

technology databases

  1. Header

  2. Declarative

  3. Executable

  4. Exception

Show answer
Correct Option: D

AI Explanation

To answer this question, you need to understand the structure of a PL/SQL block. A PL/SQL block consists of three sections: the header, the declarative section, and the executable section. The header section contains the declaration of the PL/SQL block, including its name, parameters, and return type. The declarative section contains variable declarations, cursor declarations, and other items that are used within the block. The executable section contains the actual code that is executed when the block is invoked.

The correct answer is:

D. Exception - Functions for error trapping are contained in the exception section of a PL/SQL block. The exception section is used to catch and handle any errors that occur during the execution of the block. It contains exception handlers, which specify how to handle specific types of errors.

What is the result if two NULL values are compared to each other?
technology databases

  1. TRUE

  2. FALSE

  3. Undefined

  4. NULL

Show answer
Correct Option: D

PL/SQL raises an exception, in which TWO of the following cases?

technology databases

  1. When a SELECT statement returns more than one row

  2. When a SELECT statement returns no rows

  3. When INTO statement is missing in the SELECT statement

  4. Both I and II

Show answer
Correct Option: D
Explanation:

To answer this question, the user needs to know the basics of PL/SQL and how it handles exceptions.

A. When a SELECT statement returns more than one row: This is one of the cases where PL/SQL raises an exception. If a SELECT statement returns more than one row in a context where a single value is expected, such as in an assignment statement or a SELECT INTO statement, then PL/SQL will raise the TOO_MANY_ROWS exception.

B. When a SELECT statement returns no rows: This is another case where PL/SQL raises an exception. If a SELECT statement returns no rows in a context where a single value is expected, such as in an assignment statement or a SELECT INTO statement, then PL/SQL will raise the NO_DATA_FOUND exception.

C. When INTO statement is missing in the SELECT statement: This is not a case where PL/SQL raises an exception. If an INTO statement is missing in a SELECT statement, then a compilation error will occur, but it will not result in an exception at runtime.

D. Both I and II: This option is correct. PL/SQL raises exceptions in both cases where a SELECT statement returns more than one row (TOO_MANY_ROWS) and where a SELECT statement returns no rows (NO_DATA_FOUND).

Therefore, the correct answer is: D.

What output will the follwing statement produce? Select NVL2(NULL,NOT NULL, NULL) from dual?
technology databases

  1. NULL

  2. NOT NULL

  3. Function NVL2 is not defined

  4. None of the above

Show answer
Correct Option: A

What is the smallest unit of information transfer in FC?
technology storage

  1. Block

  2. Frame

  3. Cylinder

  4. File

Show answer
Correct Option: B
Explanation:

To solve this question, the user needs to have an understanding of the basic components and terminology used in Fibre Channel (FC) networks.

In Fibre Channel, data is transferred in units called "frames." A frame is the smallest unit of information transfer in FC. It contains the data being transmitted as well as control information such as headers and CRC (Cyclic Redundancy Check) for error detection.

With this knowledge, let's evaluate each option:

A. Block: A block is a unit of data storage and is not the smallest unit of information transfer in FC. It refers to a set of data, typically a fixed size, that is read from or written to storage devices.

B. Frame: This option is correct. In Fibre Channel, a frame is the smallest unit of information transfer. It contains the data being transmitted along with control information.

C. Cylinder: A cylinder is a term used in disk storage and refers to a group of tracks that are located at the same radial distance from the center of the disk. It is not the smallest unit of information transfer in FC.

D. File: A file is a collection of data stored on a file system and is not the smallest unit of information transfer in FC.

Therefore, the correct answer is:

B. Frame

WSDL STands for:
technology web technology

  1. Web service descriptive language

  2. web select decription language

  3. web service descriotion language

  4. web sure decriptive language

Show answer
Correct Option: A

Which is the Tape storage
technology storage

  1. Digital Linear Tape

  2. Advanced intelligent tape

  3. Linear Tape open

  4. All the above

Show answer
Correct Option: D

UDDI stands for:
technology web technology

  1. Universal Description Discovery and Integration

  2. Unit Description Discovery and Integration

  3. Universal Description Disco and Display

  4. NOne of the above

Show answer
Correct Option: A

SOAP stands for:
technology web technology

  1. Simple object oriented protocol

  2. Sample object oriented protocol

  3. Simple object opposite protocol

  4. None

Show answer
Correct Option: A