DeltaX MCQ Mock Test 1

What is the function of Union Operations in SQL?

• It combines the results of two different queries

• It combines the results of two different queries which have same set of attributes in select clause

• It combines the results of two different queries which have same condition in where clause

• It is the cartesian product of the results of any two queries

Select statements have 4 clauses ->Where, having, group by, order by. The correct order of the using these clause is

• Where, group by, having ,order by

• Group by, where, having, order by

• Having, where, order by, group by

• Where, group by, having, order by

Communication offered by TCP is

• Full-duplex

• Half-duplex

• Semi-duplex

• Byte by Byte

What is the output of following pseudo code?

int x,y,z

x=2, y=1

z=x^y

print z

• 1

• 2

• 3

• 4

Which type of transmission is involved in communication between a computer and a keyboard?

• Half-duplex

• Full-duplex

• Simplex

• Automatic

How many layers in ISO OSI Reference Model?

• 4

• 5

• 6

• 7

Which layer does the data link layer take packets from and encapsulate them into frames for transmission?

• Transport Layer

• Application layer

• Network layer

• Physical layer

Which of the following allow you to connect and login to the remote computer?

• HTTP

• Telnet

• FTP

• SMTP

What is the sizeof(char) in 32 bit C Compiler?

• 1 bit

• 2 bit

• 1 byte

• 2 byte

Exception Handling is targeted at

• Compile Time Error

• Runtime Error

• Logical Error

• All the above