You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?

2 Answers  

---

Explain armstrong rules? How they are complete and/or sound?

0 Answers  

---

Explain 3nf?

0 Answers  

---

What is an artificial (derived) primary key? When should it be used?

0 Answers  

---

How to detect applications and users that hold transactions open too long?

0 Answers  

---

---

IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?

0 Answers  

---

How data are stored in database?

0 Answers  

---

determine the minimum salary of the employee and his details who join on the same date

3 Answers  

---

What is the difference between a shared lock and exclusive lock?

0 Answers  

---

If an UNIQUE KEY constraint on DATE column is created, will it accept duplicate values?

2 Answers  

---

What is rdbms table?

0 Answers  

---

Define join and enlist its types.

0 Answers  

---