Answer Posted / amit

Suppose your 2 databases are name as PROD1 and PROD2
1) How can create a table in particular database?
=> First you have to connect to the database where you want
to create table with given login and password.
and then if you have create permission than you can use
following sql
CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2",
... )

2) select * from tab; will show you how many tables,view or
synonyms are there in your schema.

Is primary key an index?

989

---

how many ways to get the current time? : Sql dba

1001

---

What is scalar function in sql?

1033

---

When to use inner join and left join?

951

---

How do you get column names only for a table (sql server)?

1149

---

What is a record in a database?

1055

---

Does sql full backup truncate logs?

1012

---

What is a pdo connection?

1022

---

Enlist some predefined exceptions?

1051

---

Can we commit in trigger?

960

---

What is rownum and rowid?

1025

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1180

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1632

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

1020

---

Why do we need databases?

1036

---