Question: a) Create a new Tablespace called BLUE with an initial size of 10M and that all extents are automatically sized and llocated by Server. Dat

a) Create a new Tablespace called BLUE with an initial size of 10M and that all extents are automatically sized and llocated by Server. Dat file blueOl dbf should go to DISi4 folder. b) Create a new Tablespace called RED with an initial size of 5M with all e.. tents of equal size 200K. Datafile re -0! dbf should go to DISK2 folder and should have auto extend or tion turned on with all new extents of 1281

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To address this task lets break it down step by step based on the instructions a Create Tablespace BLUE Use the CREATE TABLESPACE command with autoext... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

EXTERNALLY CREATE USER username IDENTIFIED { BY password GLOBALLY AS 'external name' } [ DEFAULT TABLESPACE tablespace) [ TEMPORARY TABLESPACE { tablespace tablespace_group_name } ] [QUOTA { integer...

Apply in sql and screenshot output// pls correct answer -------------------------------------------------------------------------- Create New Tablespace " create tablespace tabl espace_name datafile...

Subject: Oracle DBA 1. A table is created with this statement: Create table emp_copy tablespace users as select * from employees; Which of the following changes would make it impossible to drop the...

1. Consider the following table structures of a certain abc database: student (studentid (PK), studentname, Phone, address) module (modulecode (PK),studentid (FK), modulename startdate, time) write...

Subject: Oracle DBA 1. Your database has a single undo tablespace, and you decide to add another. How can you ensure that the new one will be used? A. Change the UNDO_TABLESPACE parameter to point to...

Tablespace Creation and Reassignment using SQL PLUS (Oracle) It has been determined that user "SCOTT" should use a new temporary tablespace called TEMP2 size equivalent to TEMP tablespace (refer to...

Work with Undo Tablespaces Simulate a problem with undo. You will need to be connected as user SYSTEM or some other user to whom you have granted the DBA role. Create an undo tablespace with a single...

Subject: Oracle DBA 1. Which is the effect of running the following command? alter database add logfile (/u01/oradata/redo04.log, /u02/oradata/redo05.log) size 500m; A. One member will be added to...

Use SQL*Plus to test a tablespace configuration with multiple datafiles 50 points Create a tablespace with one datafile. Use a uniform extent of 40 KB. Create three tables in this tablespace, and...

1. What are the SQL statements to perform the following tasks? a) Create a tablespace Hw3Tbs that contains a 32MB datafile in directory C:\app\Student\oradata\csc544744\TEMP . b) Add another 8MB to...

If a $1,000 bond is selling at 95, how much cash will the issuing company receive? If a $1,000 bond is selling at par, how much cash will the issuing company receive? If a $1,000 bond is selling at...

Wichita, Inc. reported the following amounts in its financial statements prepared as of the end of the current accounting period: Income ps 200,000 Bills 180.000 Net Income ps 20,000 Current assets...

Do disability payments require a 1 0 9 9 - R ?

Question 3 Mario was 78 years old and single when he recently died. He had the following assets at the time of his death: House $887,947 RRIF portfolio $300,000 (Beneficiary: Omar, Adult son) Life...