(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
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q6: A relational database contains details about journeys
Q7: The following tables form part of a
Q8: Write SQL*Plus commands to do the following:
Q9: Assume that the following table is created
Q10: What is a sequence? Write an SQL
Q12: (a) What is a named block
Q13: Assuming that a single-row form is
Q14: Oracle database consists of logical and physical
Q15: State the three primary uses of Oracle
Q16: (a)SQL*Plus environment variables are set to
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents