Tag: technology

Questions Related to technology

How does SUM FIELDS = NONE work?
technology mainframe

  1. Sum up value in the fields specified in the SORT FIELDS statement and keep it as only one occurence in the o/p

  2. Removes the duplicates for the fields specified in the SORT FIELDS statement and keeps only the 1st occurence of it

  3. Works only for those records in the i/p file where no duplicates for the fields specified in SORT FIELDS statement,

  4. None of the above

Show answer
Correct Option: B

18.) What is the difference between at & cron?

technology programming languages

  1. a) Both are Unix scheduling utilities

  2. b) at is restricted one and crontab is not restricted

  3. c) No difference

  4. d) at takes input from user while cron takes from a confiuration file

Show answer
Correct Option: D

Which of the following is not a Linux GUI?
technology operating systems

  1. Motif

  2. KDE

  3. XUL

  4. GNOME

Show answer
Correct Option: C

19.) How to remove a queued file from the printer queue?
technology programming languages

  1. a) lpqrm

  2. b) lprm

  3. c) jobs -r

  4. d) lpc -rm

Show answer
Correct Option: B

Which task can you perform using only the TO_CHAR function?

technology databases

  1. convert 10 to 'TEN'

  2. convert '10' to 10

  3. convert '10' to '10'

  4. convert 'TEN' to 10

Show answer
Correct Option: C

AI Explanation

To answer this question, you need to understand the TO_CHAR function in SQL.

The TO_CHAR function is used to convert a value to a character data type. It takes a value as input and returns a character representation of that value. However, it does not perform any other type conversions or transformations.

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

Option A) convert 10 to 'TEN' - This option is incorrect because the TO_CHAR function cannot convert a numeric value to a character string representing the word 'TEN'.

Option B) convert '10' to 10 - This option is incorrect because the TO_CHAR function does not perform any type conversions. It only converts a value to a character data type, so it cannot convert a character string to a numeric value.

Option C) convert '10' to '10' - This option is correct because the TO_CHAR function can be used to convert a character string to another character string. In this case, it would simply return the same character string '10'.

Option D) convert 'TEN' to 10 - This option is incorrect because the TO_CHAR function cannot convert a character string representing the word 'TEN' to a numeric value.

The correct answer is Option C) convert '10' to '10'. This option is correct because the TO_CHAR function can be used to convert a character string to another character string.

In the i/p file A contains the records in the following sequence: Arun 20 Naveen40 Priya 35 Naveen10 Priya 25 Arun 50 If the following SORT query runs on file A, how would the o/p file B look like: SORT FIELDS = (1,6,CH,A) SUM FILEDS = (7,2,PD)
technology mainframe

  1. Arun 50 Arun 20 Naveen10 Naveen40 Priya 25 Priya 35

  2. Priya 60 Naveen50 Arun 70

  3. Arun 70 Naveen50 Priya 60

  4. Naveen50 Priya 60 Arun 70

Show answer
Correct Option: B

20.) If inet service is restarted, all the open sockets gets closed
technology programming languages

  1. a) True

  2. b) False

  3. c)

  4. d)

Show answer
Correct Option: B

In which scenario would an index be most useful?

technology databases

  1. The indexed column is declared as NOT NULL.

  2. The indexed columns are used in the FROM clause.

  3. The indexed columns are part of an expression.

  4. The indexed column contains a wide range of values.

Show answer
Correct Option: D

21.) The difference between telnet & rsh?
technology programming languages

  1. a) telnet works only with terminals where rsh works for all

  2. b) telnet is unix product while rsh is a TCP product

  3. c) telnet uses byte protocol while rsh uses stream protocol

  4. d) No difference. They can be used interchangably

Show answer
Correct Option: C

Which operator can be used with a multiple-row subquery?

technology databases

  1. =

  2. LIKE

  3. BETWEEN

  4. NOT IN

  5. Is

  6. <>

Show answer
Correct Option: D

AI Explanation

To answer this question, you need to understand the concept of subqueries in SQL.

A subquery is a query that is nested inside another query. It is used to retrieve data from one or more tables and use that result in the outer query. In the case of a multiple-row subquery, the subquery returns more than one row.

When using a multiple-row subquery, you can use various operators to compare the result of the subquery with the outer query. The correct answer in this case is option D) NOT IN.

The NOT IN operator is used to exclude rows from the result set that match the values returned by the subquery. It returns rows from the outer query where the value of a specified column does not match any value returned by the subquery.

Here's an explanation of each option:

A. = (Equals) - This operator is used to compare two values for equality. However, it is not specifically designed to work with multiple-row subqueries.

B. LIKE - The LIKE operator is used to compare a value to a pattern. It is typically used for pattern matching with wildcard characters. It is not specifically designed to work with multiple-row subqueries.

C. BETWEEN - The BETWEEN operator is used to check if a value is within a range of values. It is not specifically designed to work with multiple-row subqueries.

D. NOT IN - This operator is used to exclude rows that match the values returned by the subquery. It is specifically designed to work with multiple-row subqueries.

E. IS - The IS operator is used to compare a value to NULL. It is not specifically designed to work with multiple-row subqueries.

F. <> (Not Equal) - This operator is used to compare two values for inequality. It is not specifically designed to work with multiple-row subqueries.

In conclusion, the correct answer is D) NOT IN because it is the operator specifically designed to work with multiple-row subqueries.