Computer Science Quiz

What is the function of the union operation?

• It combines the result of any two different queries

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

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

• It gives the cartesian product of the result of any 2 queries

Select statement has 4 clauses -> where, having, group by, order by the correct order of using these clauses in select statement is

• Where, having, group by, order by

• Having, where, group by order by

• Group by, having, where, order by

• Where, group by, having, order by

Communication offered by TCP is

• Full-duplex

• Half-duplex

• Semi-duplex

• Byte by Byte

What will be the output of the following pseudocode? Int x, y, z y=1,x=2 z=x^y Print z

• 2

• 1

• 3

• 4

How does a compiler differ from an interpreter?

• A compiler executes code, while an interpreter does not

• A compiler debugs code, while an interpreter does not

• A compiler translates the entire program at once, while an interpreter translates it line by line

• A compiler is used only in C programming, while an interpreter is not

SELECT INSTR("CampusMonk", "p") AS MatchPosition;

• 3

• 4

• -1

• 0

How many layers are there in the ISO OSI reference model?

• 7

• 5

• 4

• 6

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

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

• Half-duplex

• Full-duplex

• Simplex

• Automatic

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

• SMTP

• HTTP

• FTP

• Telnet