INF2603 Latest exam pack questions and answers and summarized notes for exam preparation. Updated for 2024 exams . For assistance Whats-App.0.6.7..1.7.1..1.7.3.9 . All the best on your exams!!
Exam (elaborations) INF3703 Assignment 2 (COMPLETE ANSWERS) 2024 - DUE 28 June 2024 • Course • Databases II - INF3703 (INF3703) • Institution • University Of South Africa • Book • Principl...
All for this textbook (14)
Written for
University of South Africa (Unisa)
INF2603 - Databases I (INF2603)
All documents for this subject (41)
2
reviews
By: jabu_5 • 1 month ago
By: melluzzo • 10 months ago
Seller
Follow
iStudy
Reviews received
Content preview
INF2603
EXAM PACK
FOR ASSISTANCE WITH THIS MODULE +27 67 171 1739
,UNIVERSITY EXAMINATIONS
OCTOBER/NOVEMBER 2023
INF2603
Database 1
100 Marks
Duration 2 Hours
EXAMINERS:
FIRST: Mr ME Bogopa
SECOND: Ms CL Hlengwa
This paper consists of 5 pages.
Instructions:
1. Answer all questions.
2. The marks for each question are given in brackets next to the question.
3. Please answer the questions in the order in which they have been set.
4. You signed an Honesty Declaration. This means you will complete this paper on
your own and without help.
5. This final pdf document should not be password protected.
6. Convert all the pages into a single PDF file.
7. Poorly scanned and hard to read answer files will result in a zero mark.
8. Once your document meets all the criteria, then you can upload the file to myAdmin.
GOOD LUCK.
, 2
INF2603
OCTOBER/NOVEMBER 2023
QUESTION 1 [20 marks]
Carefully select the most correct answer to each of the following questions. Please write
down only the question number and corresponding to it put the correct option’s
number (e.g. Qu. 11. (e)) (2 marks each):
1. The _____ is actually a system-created database whose tables store the
user/designer-created database characteristics and contents.
a. unique index
b. database tuple
c. system catalogue
d. systematic database
2. Within the relational model, tables are known as ____, columns of tables are referred
to as ____ and rows of tables are called ____.
a. tuples, attributes, entities
b. relations, attributes, tuples
c. relations, tuples, attributes
d. relation, attributes, tuples
3. Which of the following returns all tuples in one relation that are not found in the other
relation?
a. PRODUCT
b. SELECT
c. PROJECT
d. DIFFERENCE
4. The STUDENT table’s primary key is STUDENT_NUMB. The STUDENT primary key
column has no null entries, and all entries are unique. This is an example of _____
integrity.
a. null
b. entity
c. relational
d. referential
5. Which of the following is true of NoSQL databases?
a. They do not support distributed database architectures.
b. They are not based on the relational model.
c. They are geared toward transaction consistency rather than performance.
d. They do not support very large amounts of sparse data.
6. Which of the following is NOT a true statement about constraints:
a. Constraints are important because they help to ensure data integrity.
b. Constraints support high-level inserts, updates and deletes.
c. Constraints are normally expressed in the form of rules.
d. A constraint is a restriction placed on the data.
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 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 these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller iStudy. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $2.85. You're not tied to anything after your purchase.
