Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

Where in the Oracle directory tree structure are audit traces placed?

1 Answers  

---

How to determine the service pack currently installed on SQL Server?

1 Answers  

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

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

1 Answers   Tech Mahindra,

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

What is the difference between Datapump & export/import?

2 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  

---