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 spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How would you best determine why your MVIEW couldn't FAST REFRESH?
Where would you look for errors from the database engine?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you connect from 10g user to 11g user??
What are the commands you'd issue to show the explain plan for "select * from dual"?
What purpose does the model database server? : sql server DBA
What is dbcc? : sql server DBA
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 the different components in replication and what is their use? : sql server DBA
how can you find out if a table can be redefined?
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
Why does Oracle not permit the use of PCTUSED with indexes?
