Answer Posted / dpkar

Primary Key:
Primary key will create column data uniqueness in the table.
Primary key will create clustered index by default
Only one Primay key can be created for a table
Multiple columns can be consolidated to form a single
primary key
It wont allow null values.

Unique Key :

Unique key constraint will provide you a constraint like
the column values should retain uniqueness.
It will allow null value in the column.
It will create non-clustered index by default
Any number of unique constraints can be added to a table.

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2207

---

How to convert csv to table in oracle?

989

---

How to create a stored function in oracle?

1105

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2898

---

What to do if dba lost the system password?

1167

---

Explain the use of analyse option in exp command.

1124

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2117

---

What exactly do quotation marks around the table name do?

958

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

---

does the query needs a hint to access a materialized view?

1857

---

Name the three major set of files on disk that compose a database in Oracle?

1119

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2121

---

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1655

---

How to find out what oracle odbc drivers are installed?

1040

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4167

---