create table tablename select * from databasename.tablename

i'm expecting this will work. if anything wrong correct it

select * into databasename.<TableName> from (select * from 
databasename.<TableName>)

i think it is not possible to execute query at a time for 
two database

declare @i int
set @i=1
while @i < 100
begin
if (@i)%2 =1
begin
select * from TABLE1
end
else
select * from TABLE2
set @i=@i + 1
end

Create View emp_dept_vw with encryption as
select emp.empid,emp.ename,dept.deptid,dept.dname
from emp,dept where emp.deptid=dept.deptid 
with check option

A deadlock occurs when two or more
processes try to access a resource that another process has
a lock on. Microsoft SQL Server automatically
detects these deadlocks, terminates one of the processes,
and rolls back any changes made by that process.
The process chosen for termination will be the one with the
least amount of active time on the server. In
most cases, you can simply reissue the statements that were
rolled back and should have no problems.

Deadlocks occour when two or more processes place a lock on 
the same resources and each process waits for the others to 
release the lock.
The options to avoid deadlocks are basically the following:
1) always update data in the same order: if process A 
updates table t1 and then table t2 and process B updates 
table t2 and then table t1 deadlocks can occour. Choose an 
order and use it everywhere in your code.
2) issue the commands again when you catch the deadlock
3) always update data before data selection: no other 
process will place a lock on the modified records
4) identify the processes that can run with lower deadlock 
priority and issue SET DEADLOCK_PRIORITY LOW before these 
statements: this will tell SQLServer that the process is a 
good candidate for killing in case of deadlock, having 
the "important" processes free to run without kills

Hi 
1) 
First find out which process block the other process from 
activity monitor or sp_who2. Then kill that process. 
2)
If update locks are more  then it will make deadlock. So 
reduce that.

All are same.

Eg:

SELECT
	*
FROM  Emp INNER JOIN Emp1
ON eid=id


SELECT
	*
FROM  Emp EQUI JOIN Emp1
ON eid=id

SELECT
	*
FROM  Emp NATURAL JOIN Emp1
ON eid=id

INNER JOIN and EQUI-JOIN are same. Not sure about Natural 
Join. Found answer in Books On Line.

What is the difference between DROP,DELETE,TRUNCATE table ?
Delete:It's an DML command which is used for deleting
particular table in the database...even though we delete the
data we can regain it by rollback command.

Example:SQL> SELECT COUNT(*) FROM emp;

  COUNT(*)
----------
        14

SQL> DELESQL> SELECT COUNT(*) FROM emp;

  COUNT(*)
----------
        14

SQL> DELETE FROM emp WHERE job = 'CLERK';

4 rows deleted.

SQL> COMMIT;

Commit complete.

Truncate:This command is a DDL Command which is used to
delete a table...I Just Conclude it as
Truncate=Delete+Commit...once u applied this on table u
can't get the data back...but the structure will be there..

Example:

SQL> TRUNCATE TABLE emp;

Table truncated.

SQL> SELECT COUNT(*) FROM emp;

  COUNT(*)
----------
         0

Drop:It is used to destroy entire structure of a
table...once we apply this command on any particular table
we can't get it in anyway...so be cautious while applying
this command.

Example:

SQL> DROP TABLE emp;

Table dropped.

SQL> SELECT * FROM emp;
SELECT * FROM emp
              *
ERROR at line 1:
ORA-00942: table or view does not exist

Select 10 rows from a table ?

  Answer : Use TOP keyword to select 10 rows from a table.

Can we have more then primary Key in table ?

  Answer : We can't use more than one Primary key in a  
           table because Primary key is Unique Value.

What is mean by NULL value ?NULL means "" or 0 or
undefined ?

   Answer : NULL means empty ie. ""

What are the grouping function in SQL ?

Grouping functions are: 
max()
min()
sum()
avg()

Select 10 rows from a table ?
select * from table_name where count(*) <=10
or

select top 10 from table _name

10. What is mean by NULL value ? NULL means "" or 0 or
undefined ?

Null is not equal to "" or 0. it is un identified value

12. Can we have more then primary Key in table ?
no, we can't.

2. If base table of a view deleted means, what will happen
while we querying on view ? will give any error ?

i dont know exactly. but it likely base table doesnt exists.

4. What is constraints and types ?
types:
primary key
foreign key
not null
unique
defaults
check
rule

10) Null is not equal to "" or 0. it is un identified value
means suppose there is column Phone number.
If we do not any phone number we can insert NULL.
"" means empty String.
Select * from table where roll=""(EMPTY)
select * from table where roll is NULL(UNDEFINED)

2) Correct Answer.
View is made up of base tables. Suppose we select data from 
two table table1 & table2 ,these are base tables.
He wants to ask u if we drop a table table2,Will view give 
error.
  Yes.But if we recreate the table we can query the view 
again.

Try it by urself--
First create the view by selecting the data from two tables 
then select columns from view
Suppose select * from view1
then drop one of the tables 
then select * from view1 gives error.


12) NO.


13) ENTITY INTEGRITY--We cannit insert null in  a parimary 
key. CZ if two columns have tha value we cannot distinguish 
b/w two rows.

REFERENTIAL INTEGRITY---Vales in foregn key table are only 
those that match a value in a primary key table.

DOMAIN CONSTRAINT--A unique value for a column.
Exampl--Empid

RollBack Mean Transaction is Rolled Back to That State me 
undo The Thing That we Have Done

Commit Mean Transaction is Commited to that state me the 
the thing we have done is save

SavePoint is Concept of ORacle mean
For A Long Transaction we have Declare save point 
intermediate so that the transction before savepoint is 
commited .

DBA_Segment is Oracle Object which  contain information
about other object Created by Users like Tables,Indexes,
Veiws etc.
Its Store the information like initial ,
Extent,Min_Extent,Next_Extent, PCT_Increase,blocks, Owner of
the Object, TableSpace etc.

Declare @sql_tmp varchar(100)

set @sql_tmp="insert into table1(col1,col2..)
select 'val1','val2','') "

sp_executesql @sql_tmp

Timestamp is used typically as a mechanism for version-
stamping table rows.

time stamp data type is used to automatically generate the
unique number.A database-wide unique number.

select distinct * from table_name

To select distinct columns you can mention them in the SQL
query and to select all columns you can use select * from
information_schema.columns

You can find here in the following link : 
http://oraclebabu.blogspot.com/2008/04/oracle-certification-
to-z_29.html