Question

QUESTION 8

1. Which layer of the TCP/IP hierarchy presents incoming messages to the computer user?

   	a.	Network
   	b.	Link
   	c.	Transport
   	d.	Application

2.5 points   

QUESTION 9

1. A relational database is a collection of one or more tables that are related by key values.

   True

   False

2.5 points   

QUESTION 10

1. Which standards organization produced the OSI reference model for internet communication?

   	a.	IEEE
   	b.	ISO
   	c.	ANSI

2.5 points   

QUESTION 11

1. Which of the following is used to translate between IP addresses and mnemonic addresses?

   	a.	File server
   	b.	Mail server
   	c.	Name server
   	d.	FTP server

2.5 points   

QUESTION 12

1. A join enables you to use a single SELECT statement to query two or more tables simultaneously.

   True

   False

2.5 points   

QUESTION 13

1. The exclamation mark (!) in the following WHERE clause means NOT: WHERE Location LIKE '[!A-C]';

   True

   False

2.5 points   

QUESTION 14

1. The DISTINCT keyword is used to display the duplicate values in a column.

   True

   False

2.5 points   

QUESTION 15

1. The OR operator is processed before the AND operator in the order of evaluation.

   True

   False

2.5 points   

QUESTION 16

1. Which layer of the TCP/IP hierarchy chops messages into units whose size is compatible with the Internet?

   	a.	Link
   	b.	Application
   	c.	Transport
   	d.	Network

2.5 points   

QUESTION 17

1. Which of the following is not a way of classifying networks?

   	a.	Star versus bus
   	b.	WAN versus LAN
   	c.	Router versus bridge
   	d.	Closed versus open

2.5 points   

QUESTION 18

1. Which of the following identifies the application to which a message arriving from the Internet should be given?

   	a.	Port number
   	b.	Protocol
   	c.	Domain
   	d.	Hop count

2.5 points   

QUESTION 19

1. Given the relation below
   
         X:      A      B      C
               2      5      7
               3      3      6
               4      4      2
               5      2      2
   
   what values will be retrieved by the following SQL statement?
   
         select A, B
         from X
         where X.B = X.C

   	a.	2, 5
   	b.	2, 2
   	c.	5, 2
   	d.	3, 6

2.5 points   

QUESTION 20

1. Which layer of the TCP/IP hierarchy decides the direction in which message segments are transferred across the Internet?

   	a.	Application
   	b.	Network
   	c.	Link
   	d.	Transport

2.5 points   

QUESTION 21

1. The WHERE keyword is used to insert a record into a table.

   True

   False

2.5 points   

QUESTION 22

1. Updating data in temporary tables does not affect data stored in tables.

   True

   False

2.5 points   

QUESTION 23

1. Which of the following provides large scale streaming services?

   	a.	CGI
   	b.	ICANN
   	c.	PAN
   	d.	CDN

2.5 points   

QUESTION 24

1. Which layer of the TCP/IP hierarchy decides which application should receive an incoming message?

   	a.	Application
   	b.	Network
   	c.	Link
   	d.	Transport

2.5 points   

QUESTION 25

1. Which layer of the TCP/IP hierarchy reassembles messages as their pieces arrive at the destination?

   	a.	Transport
   	b.	Link
   	c.	Application
   	d.	Network

2.5 points   

QUESTION 26

1. The NOT operator is used to instruct Microsoft Access to match any condition opposite of the one defined.

   True

   False

2.5 points   

QUESTION 27

1. A primary key is a column in a table that uniquely identifies every record in that table.

   True

   False

2.5 points   

QUESTION 28

1. Which of the following is not a means of connecting networks?

   	a.	Bridge
   	b.	Server
   	c.	Router
   	d.	Switch

2.5 points   

QUESTION 29

1. The DELETE TABLE keywords are used to delete or remove an index.

   True

   False

2.5 points   

QUESTION 30

1. Which of the following relational operations combine data from more than one relation?

   	a.	SELECT
   	b.	JOIN
   	c.	PROJECT

2.5 points   

QUESTION 31

1. The following queries are equivalent:
   Query 1:
   SELECT *
   FROM Tools
   WHERE ToolID > 3 AND ToolID <10;
   
   Query 2: SELECT *
   FROM Tools
   WHERE ToolID BETWEEN 3 AND 10;

   True

   False

Answer 1

8.

Application layer of the TCP/IP hierarchy presents incoming messages to the computer user.

Option d

9.

A relational database is a collection of one or more tables that are related by key values.

True

10.

ISO standards organization produced the OSI reference model for internet communication.

Option b

11.

Name server is used to translate between IP addresses and mnemonic addresses.

Option c

12.

A join enables you to use a single SELECT statement to query two or more tables simultaneously.

True

13.

The exclamation mark (!) in the following WHERE clause means NOT: WHERE Location LIKE '[!A-C]'

True

14.

The DISTINCT keyword is used to display the duplicate values in a column.

False

15.

The OR operator is processed before the AND operator in the order of evaluation.

False

16.

Transport layer of the TCP/IP hierarchy chops messages into units whose size is compatible with the Internet.

Option c

17.

Router versus bridge of the following is not a way of classifying networks.

Option c

According to HomeworkLib guidelines i have to solve first four questions only but i solve first 10 questions.

Please do next post for remaining answers