Inf3707 notes - Study guides, Study notes & Summaries

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. 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 . 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 ope...

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-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...

Arithmetic Expressions You may need to modify the way in which number and date data are displayed, or you may want to perform calculations or look at what-if scenarios. These are all possible using arithmetic expressions. An arithmetic expression can contain column names, constant numeric values, and the arithmetic operators. Available arithmetic operators - + Add, - Subtract, * Multiply, / Divide. You can use arithmetic operators in any clause of an SQL statement, except the FROM claus...

INF3707 - Database Design & Implementation Summary - covers the entire module. Great for assignments and exams, document is searchable. The work has been done for you :-)

INF3707 - Database Design & Implementation Summary 2014 Ref. Lesson Title Page 1. 1-L1 Retrieving data using the SQL select statement 2 2. 1-L2 Restricting and sorting data 7 3. 1-L3 Using single row functions to customize output 15 4. 1-L4 Reporting aggregated data using the group functions 25 5. 1-L5 Displaying data from multiple tables 30 6. 1-L6 Using sub-queries to solve queries 37 7. 1-L7 Using the set operators 42 8. 1-L8 Manipulating data 46 9. 1-L9 Using DDL statements to cr...

MQC 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 characters - _ a...

This summary contains in depth concepts, explanations and examples which will not only allow you to reduce the amount of time you have to study, but will also assist you with getting a distinction for this module. This summary will replace your prescribe book entirely!