Answer Posted / naresh
CREATE DATABASE DB1
LOGFILE
GROUP 1 '/oracle/oradata/db1/redo1a.log' size 5m,
GROUP 2 '/oracle/oradata/db2/redo2a.log' size 5m
TABLESPACE USERS datafile '/oracle/oradata/db1/system.dbf'
size 100m
AUTOEXTEND ON,
DEFAULT TEMPORARY TABLESPACE
tempfile '/oracle/oradata/db1/temp.dbf' size 10m AUTOEXTEND
ON,
TABLESPACE UNDO datafile '/oracle/oradata/db1/undo.dbf'
size 10m
CHARACTER SET US7ASCII
NATIONAL CHARACTER SET US16UTF16;
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
what are the differences of where and if in SAS?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what do you understand by fine-grained auditing?
how can you process messages in order asynchronously?
How would you go about verifying the network name that the local_listener is currently using?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
what is the last version,the release date of that version and fix pack of ibm db2 udb?
what do you understand by flashback feature of oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is grd?
What purpose does the model database server? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How do you open a cluster administrator? : sql server DBA