Inf3707 2022 Study guides, Study notes & Summaries

INF3707 EXAM PACK 2022. INF3707 - Database Design And Implementation 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...

INF3707 EXAM PACK 2022. INF3707 - Database Design And Implementation Assume that a table named MyTable exist in your database. MyTable has five columns Col#, Col1, Col2, Col3 and Col4. NAME NULL TYPE -------- ------ --------- Col# NOT NULL Number Primary key Col1 NOT NULL VARCHAR2(2) Col2 NOT NULL VARCHAR2(10) Col3 NOT NULL VARCHAR2(10) Col4 NOT NULL VARCHAR2(10) 2.1 Write an SQL statement that enables you to view the structure of MyTable. (2 marks) 2.2 Write an SQL statement that all...

INF3707 EXAM PACK 2022

INF3707 EXAM PACK 2022

INF3707 EXAM PACK 2022.INF3707 - Database Design And Implementation 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 ...

INF3707 MCQs ASSIGNMENT 4 SOLUTIONS 2022

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

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

Question 1 1.1 Which Oracle Database management system is prescribed for this module? (2 marks) Oracle 18c XE 1.2 How do you login as the system administrator on the Oracle SQL*plus interface? Provide the code. (2 marks) Enter user-name: sys as sysdba Enter password: oraclepassword1234 1.3 After you have successfully installed Oracle database, how do you open the pluggable databases so that they can automatically open? (4 marks) SQL> ALTER PLUGGABLE DATABASE ALL OPEN; SQL> ALTER ...