CSE I.T QUIZ BEE DIFFICULT

In the Context of OSI or TCP / IP computer network models, which of the following is FALSE? Besides the span of geographical area, the other major difference between LAN and WAN is the latter uses switching element A repeater is used just to forward bits from one network to another one. A gateway is used to connect incompatible networks The IP Layer is a connected oriented layer in TCP / IP

• Besides the span of geographical area, the other major difference between LAN and WAN is the latter uses switching element

• A repeater is used just to forward bits from one network to another one.

• A gateway is used to connect incompatible networks

• The IP Layer is a connected oriented layer in TCP / IP

You have a table named Product. The product table has columns for ProductDescription and ProductCategory. You need to change the ProductCategory value for all the spoons in the Product table to 43. A ProductDescription of a spoon indicates that the item is a spoon. Which statement should you use?

• SET Product TO ProductCategory = 43 WHERE ProductDescription = 'spoon'

• UPDATE Product SET ProductCategory = 43 WHERE ProductDesription = 'spoon'

• SET Product WHERE ProductDescription = 'spoon' TO ProductCategory = 43

• UPDATE Product WHERE ProductDescription ='spoon' SET ProductCategory = 43

Which query correctly returns a result set for all orders where the ship_state excludes Texas(TX) and Arizona (AZ)?

• SELECT * FROM Orders WHERE ship_state NOT = 'TX' AND ship_state NOT = 'AZ';

• SELECT * FROM Orders WHERE NOT ship_state = 'TX' AND NOT ship_state = 'AZ';

• SELECT * FROM Orders WHERE NOT ship_state = 'TX' OR NOT ship_state = 'AZ';

• SELECT * FROM Orders WHERE ship_state NOT = 'TX' OR ship_state NOT = 'AZ';

You create the following query to determine whether Sample Movie appears only once in the Movie table. SELECT Title FROM Movie WHERE Title = 'Sample Movie' ORDER BY Title GROUP BY Title HAVING COUNT(*) = 1 When you run this query, it returns a syntax error. You need to modify the query to run without error and return accurate results. What should you do?

• Change the HAVING clause to HAVING COUNT(Title) = 1

• Change the HAVING clause to HAVING COUNT(1) = 1

• Remove the GROUP BY clause

• Remove the ORDER BY clause

All of the following are steps involved in the boot process EXCEPT:

• Load the operating system into RAM

• The power on self-test

• Activate the basic input/output system (BIOS)

• Load application programs