Other
INF November/December Exam Paper
- Institution
- University Of South Africa (Unisa)
INF November/December Exam Paper
[Show more]
Content preview
UNIVERSITY EXAMINATIONSOCT/NOV 2022
INF3707
DATABASE DESIGN AND IMPLEMENTATION
Duration: 2 hours
Total marks: 100
Examiners:
First: Dr B. Chipangura
Second: Dr L. Motsi
External: Dr G. Toko
This is a closed book examination, under IRIS invigilation. Unisa exam policy applies.
Instructions to students
1. Answer all questions in the given order.
2. You are not allowed to use Mobile devices, Calculators or Oracle XE during this exam.
3. Study the tables in Annexure A.
4. Students must upload their answer scripts in a single PDF file (answer scripts must not be
password protected or uploaded as “read only” files.)
5. NO emailed scripts will be accepted.
6. Students are advised to preview submissions (answer scripts) to ensure legibility and that
the correct answer script file has been uploaded.
7. Students are permitted to resubmit their answer scripts should their initial submission be
unsatisfactory.
8. Incorrect file format and uncollated answer scripts will not be considered.
9. Incorrect answer scripts and/or submissions made on unofficial examinations platforms
(including the invigilator cellphone application) will not be marked and no opportunity will
be granted for resubmission.
10. Mark awarded for incomplete submission will be the student’s final mark. No opportunity
for resubmission will be granted.
11. Mark awarded for illegible scanned submission will be the student’s final mark. No
opportunity for resubmission will be granted.
12. Submissions will only be accepted from registered student accounts.
13. Students who have not utilised the IRIS invigilation tools will be subjected to disciplinary
processes.
14. Students suspected of dishonest conduct during the examinations will be subjected to
disciplinary processes. UNISA has a zero tolerance for plagiarism and/or any other forms
of academic dishonesty.
15. Students are provided 30 minutes to submit their answer scripts after the official
examination time. Submissions made after the official examination time will be rejected by
the examination regulations and will not be marked.
16. Students experiencing network or load shedding challenges are advised to apply together
with supporting evidence for an Aegrotat within 3 days of the examination session.
Students experiencing technical challenges, contact the SCSC 080 000 1870 or email
Examenquiries@unisa.ac.za or refer to Get-Help for the list of additional contact numbers.
[Turn over]
, 2 INF3707
OCT/NOV
Question 1 20 marks
Choose the most applicable answers and write in your on your answer sheet. For example, 1.1 A,B, C,D
1.1 Which four(4) statements are true regarding views? (4 marks)
A. Data can’t be added to a view column containing an expression
B. Only simple views can use indexes existing on the underlying tables
C. Both simple and complex views can use indexes existing on the underlying tables
D. Complex views can be created only on multiple tables that exists in the same schema
E. Complex views can be created on multiple tables that exist in the same or different schemas
F. Row on a view cannot be deleted through a view if the view definition contains the DISTINCT keyword
G. If a view is dropped with the DROP VIEW command, the data in the original table will get affected.
H. DML operations are permitted on non-key-preserved tables
1.2 Examine the data in the Orderitems tables (2 marks)
ORDER# ITEM# QUANTITY
---------- ---------- ----------------
1007 2 1
1007 3 1
1007 4 1
1008 1 2
1009 1 1
Evaluate the following query:
select item#, avg(quantity) from orderitems having avg(quantity) >
min(quantity)*0.5 group by item#;
Which statement is true regarding the outcome of the above query?
A. It gives an error because the having clause should be specified after the GROUP BY clause
B. It gives an error because all the aggregate functions used in the HAVING clause must be specified in the
SELECT list.
C. It displays the item numbers with their average quantity where the average quantity is more than 0.5 the
minimum quantity of that item in the table
D. It displays the item numbers with their average quantity where the average quantity is more than 0.5 the
overall quantity of the items in the table.
1.3 Which three (3) SQL statements would display the value 2190.55 as $1, 890.55? (3 marks)
A. Select to_char(2190.55,’$0G000D00’ from dual;
B. Select to_char(2190.55, ‘$9,999V99’) from dual;
C. Select to_char(2190.55, ‘$99,999D99’) from dual;
D. Select to_char(2190.55, ‘$99G999V99’) from dual;
E. Select to_char(2190.55, ‘$9,999V99’) from dual;
1.4 If a column has high selectivity or cardinality, which index type is most appropriate for that column?
(2 marks)
A. IOT
B. B-tree
C. Bitmap
D. Function based index
[Turn over]
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller StudyWellNotes. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R80,00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53068 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 14 years now