Essay
(a) What is a 'table' and what is a 'tablespace' in Oracle9i? Write an SQL statement to create a tablespace, say MyTableSpace, with default storage. You can use a datafile called 'MyDataFile.dbf' for this tablespace. (b) Explain what is a DUAL table, where is it stored, and what is it useful for? Give an example of its use.
Correct Answer:
Verified
(a) • A table is a basic conceptual stru...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q4: Consider the following relational schema:<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBE0001/.jpg"
Q5: Assuming that a single-row form is
Q6: (a) In PL/SQL what is a Cursor?
Q7: The relational schema shown below is part
Q8: (a)SQL*Plus environment variables are set to
Q10: Oracle database consists of logical and physical
Q11: A relational database contains details about journeys
Q12: Write SQL*Plus commands to do the following:
Q13: (a) What is a SQL*Plus script? Why
Q14: The following tables form part of a