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

In DBMS, what are the two integrity rules used?

938

---

What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....

1878

---

What is index hunting and how does it help in improving query performance?

1986

---

What are stored procedures in a database?

939

---

Why its better to use files than a DBMS when there are multiple users to access the data

1175

---

What is the full meaning of dbms?

1056

---

What is big data in database?

873

---

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?

2214

---

What is distributed queries?

944

---

How can I join two tables in database?

1048

---

What are the differences between hash join, merge join and nested loops?

992

---

How do databases help businesses?

867

---

Enlist the cursor types.

1029

---

Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com

2651

---

Which database is best for storing large data?

890

---