Welcome! Log In Create A New Profile

Advanced

exam

Posted by peanut001 
Announcements Last Post
Announcement : Programming Students at UNISA School of Computing 06/19/2019 02:01PM
Announcement SoC Curricula 09/30/2017 01:08PM
Announcement Demarcation or scoping of examinations and assessment 02/13/2017 07:59AM
Announcement School of Computing Short Learning Programmes 11/24/2014 08:37AM
Announcement Unisa contact information 07/28/2011 01:28PM
exam
November 18, 2009 06:21AM
Are there any past papers for this subject?
Re: exam
November 18, 2009 04:02PM
Maybe you guys can clear this up for me:

According to tut 102:

SECTION B Oracle code: SQL & SQL *Plus (70) Chapters 1 – 6

SECTION C PL/SQL (20) Chapters 7, 8

But isn't PL/SQL chapter/Lesson 6 and 7 (instead of 7,8)
Chapter 8 is exception handling...

What does this mean? That we can leave out 8,9,10?
Re: exam
November 18, 2009 04:07PM
Hi there

No you can leave out chapters 9, 10 and 11 you have to study chapters 1 to 8
Re: exam
November 18, 2009 07:48PM
I'm just wondering...

Does anybody else have a problem with the answers to the exam q's in tut102?

so far I'm stuck on 1.3 and 1.5, they don't make sense to me....
Re: exam
November 18, 2009 08:19PM
Don't worry, those are solutions based on Access, similar but different...
avatar Re: exam
November 18, 2009 08:42PM
Geeza Wrote:
-------------------------------------------------------
> Don't worry, those are solutions based on Access,
> similar but different...

you do know that you were the one that asked the question you just supplied an answer for right...from the answer it just look as if someone else asked the question and you provided an answer...
Re: exam
November 18, 2009 08:48PM
Hi

Nice to know you are around XL, any tips. Do we have to remember all the functions?
Re: exam
November 18, 2009 09:36PM
Ha Ha! yeah......

This stuff is making my brain turn to mash.....
avatar Re: exam
November 19, 2009 12:09AM
LOGAN Wrote:
-------------------------------------------------------
> Hi
>
> Nice to know you are around XL, any tips. Do we
> have to remember all the functions?

i guess we do...i will just find out on friday with you
avatar Re: exam
November 19, 2009 12:11AM
peanut001 Wrote:
-------------------------------------------------------
> Hi there
>
> No you can leave out chapters 9, 10 and 11 you
> have to study chapters 1 to 8

i still need to do chapter 5,6,7,8...that's not ayoba
Re: exam
November 19, 2009 01:38AM
Geeza,

1.3 and 1.5 are perfectly valid Oracle scripts and are not necessarily Access based, infact Access doesnt like doing subqueries and rather does JOINs like 1.2.

What the sub query is doing is building a list of all the Department names which are on floor 1. The "IN" from the main query then makes the comparison.
The results would be similar to hardcoding the dept.names like

Language: SQL
SELECT DISTINCT Item_Name FROM SALE WHERE Dept_Name IN ('Books', 'Navigation')

The question is not very specific as you could also use the following subquery script

Language: SQL
SELECT DISTINCT Item_Name FROM SALE, (SELECT DISTINCT Dept_Name FROM DEPT WHERE Dept_Floor = '1') XYZ WHERE SALES.Dept_Name = XYZ.Dept_Name

So as you can see those are just 2 ways of getting the results using subqeries, and there are probably many more costly ways smiling smiley

The eaisiet way to work with SQL is to try and structure it similar to the above (or to your preferrence). I find it just helps to read it better, plus subqueries are easier to understand if read from the inside out.

Cheers
Darren
Re: exam
November 19, 2009 09:31AM
Thanks Darren,

Yeah, i was battling to see what it actually does...

I'll keep plodding along here...
Re: exam
November 19, 2009 09:37PM
Hey,
Is it just me or are the question in assignment 2 much easier than the question in tut102 ?
Re: exam
November 19, 2009 11:12PM
No You're right.

I'm afraid tomorrow is just gonna be a lucky dip...

Those last q's in assignment 2, (9 & 10) i don't think are part of what we have to study...

With all the cursor stuff etc...

What bugs me is that the q's in the manual are fairly straightforward then come those exam q's in tut102
which are a totally diff calibre!

theres also a lot of ways the lecturer has answered the q's which I can't find anywhere!

sadly we're the first bunch using oracle, so no real past q's for us to practice!

Anyways...

I'm gonna go in there and give it hell, last one for the year!
avatar Re: exam
November 19, 2009 11:27PM
let just hope we gwt the same type of questions as in the assignement...goodluck everybody
avatar Re: exam
November 19, 2009 11:31PM
NO ONE TOLD ME THAT THE ORACLE CD DOESNT WORK ON WINDOWS VISTA!!!sad smiley
avatar Re: exam
November 20, 2009 10:15AM
ExtraLarge Wrote:
-------------------------------------------------------
> NO ONE TOLD ME THAT THE ORACLE CD DOESNT WORK ON
> WINDOWS VISTA!!!sad smiley

Doesn't work on 7 either as I found out yesterday sad smiley
avatar Re: exam
November 20, 2009 10:48AM
Working through the example exam paper... some of the answers seem wrong... annoying.
sac
Re: exam
November 20, 2009 11:12AM
Just under 3 hours to go. Good Luck everybody. Keep the faith...
Re: exam
November 20, 2009 12:13PM
anyone know if we're allowed to use pencil for coding?
avatar Re: exam
November 20, 2009 03:54PM
Well that was easy enough.
Except for that last question. BULK COLLECT?
Where'd that come from?
Re: exam
November 20, 2009 03:58PM
It was definately easier than i expected..
Also didnt knw where it flew in from..lol..thank God it was only for 4 marks
Re: exam
November 20, 2009 04:07PM
Yeah, not to difficult.
The last question... wtf?!
Re: exam
November 20, 2009 04:17PM
@fran13- lmao..i took a serious gamble on in it. .
avatar Re: exam
November 20, 2009 04:18PM
Does the last question actualy result in any output?
What tickled me was the "DBMS_OUTPUT.PUT_LINE(variable(loopindex));"
No column name or anything? Surely this will error?

Section A and B was easy enough. C seems to be the "extra effort" section.

Cobus Neethling
avatar Re: exam
November 20, 2009 04:34PM
It should produce output, from what i've found online here no column name required it seems.

What did you all put down for the last question anyway?
I just took a wild guess and listed the product names.
Luckily it was only 4 marks though.
Re: exam
November 20, 2009 04:47PM
I left it out.

Had no clue what it was!

Well you know what they say, prepare for the worst and usually you get pleasantly surprised...

I'm just concerned cause I wrote everything in pencil, then wrote over it with a pen and when I rubbed it out the pencil the ink started coming off, haha!

now there is pen over pencil and it looks atrocious! legible but atrocious!

have mercy mr or mrs marker!

Check back in when the results come out!

beer anyone?
sac
Re: exam
November 20, 2009 05:09PM
Not too bad but I thought it was just a little long.
avatar Re: exam
November 20, 2009 05:49PM
eish...i messed this paper up big time. im so mad at myself. that the forth paper in a row that i completely fucked up :/
Re: exam
November 20, 2009 09:01PM
Don't tell me we were not allowed to use pencil for coding.
Sorry, only registered users may post in this forum.

Click here to login