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.

What is the difference between sum and count in sql?

986

---

What is the trigger in sql?

953

---

define data blocks ? : Sql dba

990

---

How many types of relationship are there?

1031

---

Explain the types of joins in sql?

1034

---

List the different type of joins?

1061

---

Enlist the advantages of sql.

1001

---

Define tables and fields in a database

1130

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1057

---

Is there a 64 bit version of ssms?

961

---

How many subqueries can be nested in a statement?

982

---

What are the types of functions in sql?

1019

---

What is crud sql?

982

---

What is difference between inner join and cross join?

969

---

How many unique keys can a table have?

1012

---