Tag: technology

Questions Related to technology

DataStage Server jobs are compiled into which code?

technology

  1. OSH Scripts

  2. C++

  3. BASIC

  4. Java

Show answer
Correct Option: C

Which client application is used to manage,browse and edit the metadata repository?

technology

  1. Administrator

  2. Designer

  3. Director

  4. Manager

Show answer
Correct Option: D

What is the default ip address and port for Information Server Web Console?

technology

  1. http://localhost:1000

  2. http://localhost:9080

  3. http://localhost:8080

  4. http://localhost:1080

Show answer
Correct Option: B

In the Table employee_Details there are two columns: Employee_Id-Integer[10] and Employee_Name-Char[10],The following select query Select distinct(Employee_Name) from employee_Details where Employee_Id='1232' fails due to:

technology databases

  1. The field mentioned in the where clause should be one of the columns selected

  2. The distinct function can not be used on a field of type Char

  3. The Integer value mentioned in the where clause should not be enclosed by quotes since it is of integer type.

  4. none of the above.

Show answer
Correct Option: C

The ORDER BY keyword sort the records in descending order by default.
technology databases

  1. True

  2. False

Show answer
Correct Option: B

fill up:A LEFT JOIN Return all rows from the _________ table, even if there are no matches in the __________ table
technology databases

  1. left,right

  2. right,left

  3. left,left

  4. right,right

Show answer
Correct Option: A

Fill Up: The UNION operator selects only distinct values by default. To allow duplicate values, use __________
technology databases

  1. UNION ENTIRE

  2. FULL UNION

  3. UNION ALL

  4. none of the above

Show answer
Correct Option: C

The following query fails. Select employee_name,employee_id,count() from employee_Details group by employee_id where count()>2; The right format is:
technology databases

  1. Select employee_name,count() from employee_Details group by employee_id where count()>2;

  2. Select employee_name,employee_id,count() from employee_Details group by employee_id having count()>2;

  3. Select employee_name,employee_id,count() from employee_Details order by employee_id where count()>2;

  4. NONE of THE ABOVE

Show answer
Correct Option: B

Select * from employee_Details with ur; in the follwoing query UR stands for:
technology databases

  1. Under Read

  2. neither a,c or d

  3. Uncommitted Read

  4. Uncommitted Ride

Show answer
Correct Option: C

An application program containing query with UR
technology databases

  1. can read data that has been changed and committed.

  2. can read data that has been changed but is not yet committed.

  3. both a and b

  4. neither a or b

Show answer
Correct Option: C