Answer Posted / ali

Alias is the temporay name , where as rename is the permanent given.

RENAME:
1. RENAME OLD_TABLENAME to NEW_TABLENAME;
2. alter table table_name rename column column_name to new_columnname;

ALIAS:
1. select ename as name from table_name1 as empl1, table_name2 as empl2 where empl1.id = empl2.id;

interview questions with answer for cts

2588

---

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2081

---

What are internal user account in oracle?

1011

---

What do database buffers contain?

1040

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2162

---

how to clone 9i Database on to 10g Database.

2343

---

What is a lookup table in oracle?

973

---

How to synchronize 2 schema's objects?

2186

---

How to join two tables in a single query using oracle?

1000

---

What is oracle server autotrace in oracle?

1166

---

How different is ms access and oracle?

1044

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

1022

---

List out the components of logical database structure of oracle database.

1039

---

How to get a create statement for an existing table?

974

---