Answer / monal

FACT TABLE: SALES
DIMENSION TABLE: GEOGRAPHY, PRODUCT, TIME

Answer / jeshani

Fact tables and dimension tables.
A fact table contains measurements while dimension tables will contain data that will help describe the fact tables.

What command would you use to create a backup control file?

2 Answers  

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

0 Answers  

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

how can you enable flashback feature?

0 Answers   Oracle,

---

Explain how you would restore a database using RMAN to Point in Time?

1 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.

4 Answers   Cognizant,

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---