Institute of Technology, Carlow

yompmulligrubsInternet και Εφαρμογές Web

31 Οκτ 2013 (πριν από 3 χρόνια και 7 μήνες)

43 εμφανίσεις



No:177s


Institute of Technology, Carlow

School of Science

Department of Computing & Networking

March 2010 Examinations





Course Code:

KCCSYD (CW217)





Course Title:

BSc in Computing

in Systems Management





Course Year:

3





Subject:

Application Development




Date:

03/03 AM




Duration:

3 hours





Examiners:

Mr E Cass






Mr A McDonald





Special Requirements:




Instructions to Candidate:




1.

Write your Name, Course, Course Year and Class Group on your answer

book.

2.

Answer any
FIVE
questions. All questions carry equal marks




Question 1.



(a)

For the following data file with key underlined:

c_no

sname

inits

street

city

balance

1

S
ullivan

G.R.

12 Fax Rd

Dublin

€16.26

O

i
ynch



㔠5ux St

i潮摯d

€200.00

3

Jac歳潮



㈠Oux Ave

iee摳

€510.00

4

a
敡e



㌱⁌潷 St

a
un摡lk

€149.23

5

t潯摳

S⹑.

ㄷ⁎ax Rd

au扬in

€350.10

6

tilliams



㐱⁃ax St

C潲k

€412.21

7

A摡ms



ㄱ⁃潲欠kt

Carl潷

€412.21

8

Ba步r



ㄲ1

aux St

au扬in

€500.00

9

O’Brian




T
畸u


Carl潷

€500.00



J潮es





⸮.

⸮.









⸮.

⸮.




(i)

Show with the aid of a diagram how a primary index can be constructed

(
5

marks)

(ii)

Show with the aid of a diagram
ONE way a secondary index
on
city


can be constructed.
What are the pros and cons of having a number of secondary indexes on a data file?












(7 marks)

(b)

Why is primary indexing efficient? Outline the reasons. Calculate (approximately) the average
nu
mber of block reads needed to locate a record in a 10,000 record data file which has a primary
index, assuming that 40 index entries can fit into each index block.
















(
8

marks)



Question 2.


(a)

With the aid of a diagram, outline the
two tier

client

server

architecture.















(3 marks)

(b)

(i) With the aid of a diagram, outline the
three tier
client server architecture
, referring to typical
technologies / protocols used
.








(
9

marks)

(ii)

Describe the role of an
application server

in the three tier
architecture.















(
4

marks)

(c)

Outline
FOUR
main reasons for the
use

of the three tier architecture

in large scale systems
.













(
4
marks)




Question
3.


(a)

What is XML? Explain how it differs from HTML illustrating with
a short sample.














(
7
marks)

(b)

Discuss the usefulness or otherwise of XML for data interchange
.













(
7

marks)


(c)

Outline the Service Oriented Architecture (SOA), referring to XML in your answer. How does it
compare with the three
-
tier architec
ture?







(6 marks)








Question 4.


Using the three tables below
, which show details of
supplier
s,
part
s and the parts that each supplier
currently
sells
:



SUPLIER

SNO

SNAME

CITY

1

Smith

London

2

Jones

Dublin

3

Johnson

Carlow

4

L
ynch

Cork


PART

PNO

PNAME

PRICE

1

screw

10

2

nut

NULL

3

bolt

20

4

washer

5



SELLS

SNO
____

PNO

1

1

1

2

2

4

3

1

3

3

4

2

4

3

4

4


(a)
write out the SQL code for the following

(i)

Get all PART
details
where the a price is
less

than
5
0



(
2

Mark)

(ii)

Get all
SUPPLIER

details
for suppliers whose name begin
s

with “
J”

(2 Marks)

(iii)

Find the average cost of all parts in table PART




(2 Marks)

(iv)

How many parts are sold by each supplier.






(4 Marks)

(v)

Add
a

record
to the SUPPLIER Table





(3 Marks)

(vi)

Change to 15

the
price
of all

part
s

whose price is less than 17 or whose part number is 3 or
greater









(
4

Marks)


(b)

Explain why testing for
NULL
s should not use operators =, <>. What should be coded instead?











(3 Marks)



Question 5.


(a)

Suppose that a database is required in which there will be
4
0 (user) tables. A table will have
15
00 rows with each row requiring
6
K bytes (averages). Show how you could
estimate
the
initial size of the database, ignoring the non
-
user portion.

What other ty
pes of object could be
relevant from a space viewpoint?

i.

(
7

marks)


(b)


What is a stored procedure?


Give an example in

T
-
SQL
code of a

user
defined
stored
procedure

which includes at least one
parameter
.

Explain also how you would call
your
procedure
.









(
9

marks)

(c)

Outline
SQL Server Profiler and its use by the administrator.


(
4

marks)








Question 6.


(a)

Make a comparison between (i)
BULK INSERT

and (ii)
INSERT INTO

referring to the main syntax or
examples to illustrate
.


(8

Marks)

(b)

What is the purpose of the bcp utility
?

How are
format files

useful in conjunction with bcp?


(
4

Marks)

(c)

What is the difference

in
SQL Server

between a
connection to a
remote server
and a
linked

server?
In each case outline why these features are used. Exp
lain what is involved in a
four part name
.

(8 marks)




Question 7.


(a)

Why is the Surface Area Configuration (SAC) tool useful

to the
administrator? Describe its uses
and briefly outline what other measures are available in SQL Server to control remote acc
ess to
stored data.

(8 marks)

(b)

What are
roles

in SQL Server? Refer to server roles and database roles in your answer. Give any
two advantages of roles.


(8 marks)


(c)

Explain the syntax and use of

o

GRANT

o

REVOKE


(4 marks)