Inf3707 study notes Study guides, Study notes & Summaries
Looking for the best study guides, study notes and summaries about Inf3707 study notes? On this page you'll find 16 study documents about Inf3707 study notes.
Page 2 out of 16 results
Sort by
-
INF3707- Database Design And Implementation EXAM PACK 2022.
- Exam (elaborations) • 156 pages • 2022
-
- R60,24
- + learn more
INF3707- Database Design And Implementation EXAM PACK 2022. Question 1 10 marks 
1.1 Which Oracle Database management system is prescribed for this module? (2 marks) 
1.2 How do you login as the system administrator on the Oracle SQL*plus interface? Provide the code. 
(2 marks) 
1.3 After you have successfully installed Oracle database, how do you open the pluggable databases so 
that they can automatically open? (4 marks) 
1.4 By default, Oracle pluggable databases remain closed and must be o...
-
INF3707 EXAM PACK 2022
- Exam (elaborations) • 159 pages • 2022
-
- R56,47
- + learn more
INF3707 EXAM PACK 2022. Which Oracle Database management system is prescribed for this module? (2 marks) 
1.2 How do you login as the system administrator on the Oracle SQL*plus interface? Provide the code. 
(2 marks) 
1.3 After you have successfully installed Oracle database, how do you open the pluggable databases so 
that they can automatically open? (4 marks) 
1.4 By default, Oracle pluggable databases remain closed and must be opened manually or set to 
automatically open. Which Oracle 18c ...
-
INF3707-Database Design And Implementation EXAM PACK 2022.
- Exam (elaborations) • 155 pages • 2022
-
- R56,47
- + learn more
INF3707-Database Design And Implementation EXAM PACK 2022. Question 1 10 marks 
1.1 Which Oracle Database management system is prescribed for this module? (2 marks) 
1.2 How do you login as the system administrator on the Oracle SQL*plus interface? Provide the code. 
(2 marks) 
1.3 After you have successfully installed Oracle database, how do you open the pluggable databases so 
that they can automatically open? (4 marks) 
1.4 By default, Oracle pluggable databases remain closed and must be open...
-
INF3707 EXAM NOTES.
- Exam (elaborations) • 7 pages • 2021
-
- R65,70
- + learn more
INF3707 EXAM NOTES. Database Design And Implementation. Difference between inner & outer join: 
Both inner & outer are used to combine rows for different tables into a single result. The 
difference is that inner join does not allow/retrieve non-matching rows (matched by PK & 
FK) where outer join does. The outer join will display ALL records from the table selected (by 
LEFT or RIGHT keyword) as well as the matching records from the other table that is in the 
query. The inner join will only di...
-
INF3707 Exam Notes
- Exam (elaborations) • 7 pages • 2021
-
- R65,70
- + learn more
INF3707 Exam Notes 
b.View – virtual table, not table on its own but mirrors table(temp table). Multiple tables – 
complex, single table – simple. In addition, the function and GROUP BY clause prevent 
changing the displayed data because each record might represent more than one row in the 
underlying key-preserved 
Reasons for view table – security, not direct DB access, efficiency – less direct DB hits 
table. 
CH. 13, text book pg 517 e-book pg 539 
1.2 c. _ and % allows white chara...
Too much month left at the end of the money?
-
INF3707 Exam Notes
- Exam (elaborations) • 7 pages • 2021
-
- R65,70
- + learn more
INF3707 Exam Notes 
1.1 b.View – virtual table, not table on its own but mirrors table(temp table). Multiple tables – 
complex, single table – simple. In addition, the function and GROUP BY clause prevent 
changing the displayed data because each record might represent more than one row in the 
underlying key-preserved 
Reasons for view table – security, not direct DB access, efficiency – less direct DB hits 
table. 
CH. 13, text book pg 517 e-book pg 539 
1.2 c. _ and % allows white c...
R115 for your summary multiplied by 100 fellow students... Do the math: that's a lot of money! Don't be a thief of your own wallet and start uploading yours now. Discover all about earning on Stuvia