Exam (elaborations)
INF3707 EXAM PACK 2023.
- Course
- Institution
INF3707 EXAM PACK 2023.
[Show more]
Seller
Follow
MasterVincent
Reviews received
Content preview
ADMIN[COMPANY NAME]
,Downloaded by: sihlengubane | sihle13@gmail.com
Distribution of this document is illegal
, 2
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 opened manually or set
to automatically open. Which Oracle 18c XE service must you configure to do that? (2 marks)
Question 2 40 marks
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 allows you to see the data contained in all the columns of MyTable.
(3 marks)
2.3 MyTable contains some columns that are marked as unused. Write an SQL code that drops all the
columns marked as unused. (4 marks)
2.4 All the data entered into MyTable is not correct. Write an SQL code that deletes the data from the
table but leaving it intact. (3 marks)
2.5 You realised that Col1 and Col4 are too small to accommodate large variables, write an SQL code
that increases the size of Col1 from 2 to 17 and Col4 from 10 to 25. (5 marks)
2.6 Insert data into three columns of MyTable, by populating Col1, Col2 and Col4 with values A, B and
D in that order. Do not insert any data into Col3, store a null value. (5 marks)
2.7 If the primary key of this table was created with the following statement:
Col# Number GENERATED AS IDENTITY PRIMARY KEY;
What output do you expect after inserting the following data into MyTable? Explain your answer.
Downloaded by: sihlengubane | sihle13@gmail.com
Distribution of this document is illegal
, [Turn over]
Downloaded by: sihlengubane | sihle13@gmail.com
Distribution of this document is illegal
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 MasterVincent. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $2.70. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
81531 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now