Explain CREATE DATABASE syntax?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / rohit bhosale
Create Database [database_name] On Primary
(
Name='abc', Filename='path_of_mdf_file'
)
log on
(
Name='abc_log', Filename='path_of_ldf_file'
)
Eg:
Create database emp on primary
(
name='emp1', filename='d:\sql\emp.mdf'
)
log on
(
name='emp1_log', filename='d:\sql\emp_log.ldf'
)
Is This Answer Correct ? | 0 Yes | 0 No |
What would you do with an "in-doubt" distributed transaction?
From the database level, how can you tell under which time zone a database is operating?
internal architecture
Explain the use of table functions.
what is incremental checkpoint?
What are the commands used in dcl? : sql server DBA
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
Why would you call update statistics? : sql server DBA
Name a tablespace automatically created when you create a database.
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
How would you force a log switch?
Oracle 11g new features?