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;

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'
)

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers   Cognizant,

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

Explain the use of table functions.

1 Answers  

---

Where do you find the default index fill factor and how to change it? : sql server DBA

0 Answers  

---

the process of adding a cpu in sql server is called..?

2 Answers   TCS,

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1 Answers  

---

What would you do with an "in-doubt" distributed transaction?

0 Answers  

---

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?

0 Answers   HSBC,

---

What is replication? : sql server DBA

0 Answers  

---