IT Trainer Questions


Q:

How many joining conditions are required to join 4 tables in SQL?

A) 1 B) 2
C) 3 D) 4
 
Answer & Explanation Answer: C) 3

Explanation:

To join 'n' tables 'n-1' conditions should be satisfied.

So to join 4 tables 3 conditions should be satisfied.

Report Error

View Answer Report Error Discuss

38 13953
Q:

First Bank to introduce Credit Card in India

A) HSBC Bank B) ICICI Bank
C) State Bank of India D) Central Bank of India
 
Answer & Explanation Answer: D) Central Bank of India

Explanation:

 

        • First Bank to introduce Credit Card in India - Central Bank of India
        • First Bank to introduce ATM  -  HSBC, 1987
        • First Bank to introduce Internet Banking - ICICI Bank

 

 

Report Error

View Answer Report Error Discuss

21 13937
Q:

P, Q, and R can do a job in 12 days together.  If their efficiency of working be in the ratio 3 : 8 : 5, Find in what time Q can complete the same work alone?

A) 36 days B) 30 days
C) 24 days D) 22 days
 
Answer & Explanation Answer: A) 36 days

Explanation:

Given the ratio of efficiencies of P, Q & R are 3 : 8 : 5

Let the efficiencies of P, Q & R be 3x, 8x and 5x respectively

They can do work for 12 days.

=> Total work = 12 x 16x = 192x

 

Now, the required time taken by Q to complete the job alone = 162x8x = 24 days.

Report Error

View Answer Report Error Discuss

17 13929
Q:

In the following pieces of code, B and D will compile without any error. True or false ?

A: StringBuffer sb1 = "abcd";

B: Boolean b = new Boolean("abcd");

C: byte b = 255;

D: int x = 0x1234;

E: float fl = 1.2;

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:

The code segments B and D will compile without any error. A is not a valid way to construct a StringBuffer, you need to create a StringBuffer object using "new". B is a valid construction of a Boolean (any string other than "true" or "false" to the Boolean constructor will result in a Boolean with a value of "false"). C will fail to compile because the valid range for a byte is -128 to +127 (i.e., 8 bits, signed). D is correct, 0x1234 is the hexadecimal representation in java. E fails to compile because the compiler interprets 1.2 as a double being assigned to a float (down-casting), which is not valid. You either need an explicit cast, as in "(float)1.2" or "1.2f", to indicate a float.

Report Error

View Answer Workspace Report Error Discuss

16 13845
Q:

A web page is located using a

A) Universal Record Locator B) Universal Resource Locator
C) Uniform Record Linking D) Universal Record Linking
 
Answer & Explanation Answer: B) Universal Resource Locator

Explanation:

A web page is located using a URL (Universal Resource Locator). Universal Resource Locator is also known as web address.

 

It basically refers to a web resource which is meant for the specification of its location on the network of computer. It is also a mechanism through which information can be retrieved.

Report Error

View Answer Report Error Discuss

12 13801
Q:

8 S on a SS means?

Answer

8 S on SS means 8 Sides on a Stop Sign.


This is one type of Letter Equations which are well known phrases or facts where the key words have been replaced with the first letter of that word. These are often in the form of an equation, which contain a number, an = sign and the rest of the obscured phrase or fact.


 


Some more of them are ::


90 D in a RA


26 L of the A 


12 S of the Z.

Report Error

View answer Workspace Report Error Discuss

Subject: Logic Puzzles Exam Prep: AIEEE , Bank Exams , CAT , GATE
Job Role: Analyst , Bank Clerk , Bank PO , IT Trainer

22 13743
Q:

Which of the following is a comparison operator in SQL?

A) = B) <>
C) ` D) /
 
Answer & Explanation Answer: A) =

Explanation:

The comparison operator that is used in SQL is '='. Comparison operators test whether two expressions are the same. Comparison operators can be used on all expressions except expressions of the text, ntext, or image data types.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank Clerk , Bank PO , Database Administration , IT Trainer

7 13448
Q:

What is the theme of 2017 World Telecommunication and Information Society Day (WTISD)  ?

A) Entrepreneurship for social impact B) Reduce digital divide
C) Promote digital education for social welfare D) Big data for big impact
 
Answer & Explanation Answer: D) Big data for big impact

Explanation:

The World Telecommunication and Information Society Day (WTISD) is observed every year on May 17 to mark the anniversary of the signing of the first International Telegraph Convention (ITC) and the creation of the International Telecommunication Union (ITU). The purpose of the day is to help raise awareness of the possibilities that the use of the Internet and other information and communication technologies (ICT) can bring to societies and economies, as well as of ways to bridge the digital divide. The 2017 theme “Big Data for Big Impact” focuses on the power of Big Data for development and aims to explore how to turn imperfect, complex, often unstructured data into actionable information in a development context.

Report Error

View Answer Report Error Discuss

Filed Under: Important Days and Years
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , IT Trainer

15 13421