Answer Posted / awa

SELECT
DBMS_METADATA.GET_DDL('PROCEDURE',a.object_name,a.owner)
FROM = dba_objects a WHERE OWNER =3D'SCHEMA_OWNER' AND
object_TYPE =3D'PROCEDURE' ORDER BY owner

There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?

2122

---

What are indexes? Mention the differences between the clustered and non-clustered index?

965

---

What is query in database?

922

---

What the default privileges which get assigned ?

939

---

What is openedge translation manager?

1079

---

Explain bcnf (boyce-codd normal form)?

1018

---

What is n tier architecture in dbms?

923

---

What is the importance of a database?

973

---

Which is the most used database?

937

---

Is google a database?

1185

---

How to improve query performance using index hunting?

1175

---

What is key dbms?

883

---

Explain the architecture of reporting services?

985

---

How do you rename a database?

909

---

How do convert or display the date or time as string?

1050

---