Answer Posted / anbarasu

UNIQUE KEY: A Table may contain one or more UNIQUE
constraints. It’s allowing only one null value. Use this
key we maintain unique vales in the table.

FOREIGN KEY: A key used in one table to represent the value
of a primary key in a related table. While primary keys
must contain unique values, foreign keys may have
duplicates. For instance, if we use student ID as the
primary key in a Students table (each student has a unique
ID), we could use student ID as a foreign key in a Courses
table: as each student may do more than one course, the
student ID field in the Courses table (often shortened to
Courses. student ID) Will hold duplicate values.

HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?

2381

---

What is the function of cluster index?

1092

---

What are database connection details?

1083

---

What is lagging in DBMS ?

1210

---

What is the difference between a stored procedure and a query?

1035

---

sparse lookup and where its options we find in OCI and db2?

2153

---

What is the purpose of TNS?

981

---

What is database client?

957

---

i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

2040

---

What does currency type mean in database?

1126

---

Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

2354

---

What does new grouping sets enables you to do?

978

---

What is difference between data and database?

1015

---

I have single column in a file. Input 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15 my output is file 1 have 1,2,3,10,11,12 file 2 have 4,5,6,13,14,15 and file 3 have 7,8,9 how is it possible in datastage

1502

---

Write a query to retrieve for many to many relationships?

934

---