CIS*2750: Final Exam Questions With
Correct Answers 100% Guaranteed Pass.
Protocol Stack - Answer✔Lowest Levels - Communicate bytes/packets between computers
Higher Levels - Fault Tolerance
Highest Levels - Application Specific
Internet Protocol (IP) - Answer✔Relays datagrams across networks
Routing functionality
Basis of The Internet
Transmission Control Protocol (TCP) - Answer✔Adds reliability, ordering, and error checking
User Datagram Protocol (UDP) - Answer✔Doesn't include the reliability, Faster, Used on
gaming
Early Applications of HTTP - Answer✔Military Communications, Personal Communications
(E-mail, Net-news, Bulleting boards, Early social media, Early hypertext: archie, veronica,
gopher)
What does HTTP stand for? - Answer✔Hypertext transmission protocol
What does SQL stand for? - Answer✔Structured Query Language
Pros of Standards - Answer✔Reduce training costs,
Promotes application portability, Promotes application longevity, Intersystem communications
(Different management systems function well on a single database if they support the same
interface), Customer Choice (Customers choose an interface to meet their needs)
Cons of Standards - Answer✔Reduce creativity, Flaws in the design of SQL
1|Page
,What is SQL used for? - Answer✔Used to define, manipulate, and control data in relational
databases
Relative Database - Answer✔A database that is perceived as a collection of tables by the user.
Table - Answer✔An unordered collection of rows
How can SQL statements be invoked? - Answer✔Can be invoked interactively or from within an
application
SELECT - Answer✔Used for data retrieval
Syntax of Complete Call:
SELECT S.CITY
FROM S
WHERE S.SNO = 'S4'
FROM - Answer✔Indicates the table to retrieve from
WHERE - Answer✔Used to describe column features that are desired in retrieved data
Can use all comparisons
Strings must be in single quotes
What happens if there is no WHERE? - Answer✔Returns all of the rows
CREATE TABLE - Answer✔Constructs an empty table
Must provide a table name and unique column names
Syntax of Complete Call:
CREATE TABLE S ( SNO CHAR(5),SNAME CHAR(20),STATUS DECIMAL(3),CITY
CHAR(15),PRIMARY KEY (SNO) )
2|Page
, Primary Keys - Answer✔Columns described as primary key cannot have two columns with the
same column value
Composite Key - Answer✔Primary key consisting of more than one column (values unique in
combination)
Foreign Key - Answer✔A primary key of one table that appears an attribute in another table and
acts to provide a logical relationship among the two tables
INSERT - Answer✔Adds a new row
Syntax:
INSERT
INTO SP ( SNO, PNO, QTY)
VALUES ( 'S4', 'P1', 1000)
UPDATE - Answer✔Change values in existing records
Syntax of Complete Call:
UPDATE S
SET STATUS = 2 * S.STATUS
WHERE S.CITY = 'London'
DELETE - Answer✔Remove row(s)
Syntax of Complete Call:
DELETE
FROM P
WHERE P.WEIGHT > 15
DISTINCT - Answer✔No duplicate rows
SELECT * - Answer✔Select the entire row
INTEGER - Answer✔Numbers without decimal points
3|Page
Correct Answers 100% Guaranteed Pass.
Protocol Stack - Answer✔Lowest Levels - Communicate bytes/packets between computers
Higher Levels - Fault Tolerance
Highest Levels - Application Specific
Internet Protocol (IP) - Answer✔Relays datagrams across networks
Routing functionality
Basis of The Internet
Transmission Control Protocol (TCP) - Answer✔Adds reliability, ordering, and error checking
User Datagram Protocol (UDP) - Answer✔Doesn't include the reliability, Faster, Used on
gaming
Early Applications of HTTP - Answer✔Military Communications, Personal Communications
(E-mail, Net-news, Bulleting boards, Early social media, Early hypertext: archie, veronica,
gopher)
What does HTTP stand for? - Answer✔Hypertext transmission protocol
What does SQL stand for? - Answer✔Structured Query Language
Pros of Standards - Answer✔Reduce training costs,
Promotes application portability, Promotes application longevity, Intersystem communications
(Different management systems function well on a single database if they support the same
interface), Customer Choice (Customers choose an interface to meet their needs)
Cons of Standards - Answer✔Reduce creativity, Flaws in the design of SQL
1|Page
,What is SQL used for? - Answer✔Used to define, manipulate, and control data in relational
databases
Relative Database - Answer✔A database that is perceived as a collection of tables by the user.
Table - Answer✔An unordered collection of rows
How can SQL statements be invoked? - Answer✔Can be invoked interactively or from within an
application
SELECT - Answer✔Used for data retrieval
Syntax of Complete Call:
SELECT S.CITY
FROM S
WHERE S.SNO = 'S4'
FROM - Answer✔Indicates the table to retrieve from
WHERE - Answer✔Used to describe column features that are desired in retrieved data
Can use all comparisons
Strings must be in single quotes
What happens if there is no WHERE? - Answer✔Returns all of the rows
CREATE TABLE - Answer✔Constructs an empty table
Must provide a table name and unique column names
Syntax of Complete Call:
CREATE TABLE S ( SNO CHAR(5),SNAME CHAR(20),STATUS DECIMAL(3),CITY
CHAR(15),PRIMARY KEY (SNO) )
2|Page
, Primary Keys - Answer✔Columns described as primary key cannot have two columns with the
same column value
Composite Key - Answer✔Primary key consisting of more than one column (values unique in
combination)
Foreign Key - Answer✔A primary key of one table that appears an attribute in another table and
acts to provide a logical relationship among the two tables
INSERT - Answer✔Adds a new row
Syntax:
INSERT
INTO SP ( SNO, PNO, QTY)
VALUES ( 'S4', 'P1', 1000)
UPDATE - Answer✔Change values in existing records
Syntax of Complete Call:
UPDATE S
SET STATUS = 2 * S.STATUS
WHERE S.CITY = 'London'
DELETE - Answer✔Remove row(s)
Syntax of Complete Call:
DELETE
FROM P
WHERE P.WEIGHT > 15
DISTINCT - Answer✔No duplicate rows
SELECT * - Answer✔Select the entire row
INTEGER - Answer✔Numbers without decimal points
3|Page
