Answer Posted / apparao akki

Hi all,

plz find the below executed report on the same.
------------------------------------------------------


SQL> select * from person;

PERSON_ID FIRST_NAME LAST_NAME
TITLE_1 TITLE_2 SOCS
---------- --------------------- -------------------------
---------- ---------- -----------
9 ssss rrrrr
tttt gggg 67778-3
1 THUUTHTUT lofstrom
ba null 4940-343
1 ffsdf fsdfsd
fdsfsd fsdf 5454
1 THUUTHTUT lofstrom
ba null 4940-343
1 THUUTHTUT lofstrom
ba null 4940-343
1 appa akki
s/w btech 3i
2 rao
s/w kmm 3i
4 bunny neel
lkg ukg home

8 rows selected.

SQL> select unique(person_id),last_name from person;

PERSON_ID LAST_NAME
---------- -------------------------
2
1 lofstrom
4 neel
1 fsdfsd
9 rrrrr
1 akki

6 rows selected.

SQL> select distinct(person_id) from person;

PERSON_ID
----------
4
9
2
1

What is union, minus and interact commands?

1226

---

How many triggers can be applied on a table?

888

---

What is indexing in sql and its types?

1017

---

What is an invalid partition table?

968

---

What are the benefits of pl sql?

1066

---

How to use sql statements in pl/sql?

1063

---

what is self-join? : Sql dba

1071

---

What is the difference between partitioning and sharding?

961

---

what is the difference between primary key and unique key? : Sql dba

985

---

What are instead of triggers?

1004

---

Can unique keys be null?

858

---

What is plpgsql language?

988

---

Is postgresql a server?

1005

---

Can you selectively load only those records that you need? : aql loader

994

---

Can a procedure in a package be overloaded?

995

---