Interview Questions Answers in DB Administration, Database Management, Oracle General, SQL Server, DB Development, Databases AllOther, SQL PLSQL

Questions / { manoj }

Questions Answers Category Views Company eMail

Question { TCS, 19773 }

Explain the difference between a hot backup and a cold
backup and the benefits associated with each?

Answer

Hot Backup: Its logical backup of database. It is done while
the database is running. One can backup Entire database or
Users or Tables optinally in this type.

Cold Backup: Its physical backup of the database. It requres
database to be shutdown. Files are physically copied to some
other location as backup.

Is This Answer Correct ?

9 Yes

26 No

Question { 2942 }

Is it possible to modify a Datatype of a column when column
contains values?

Answer

No, its not possible to modify the datatype of a column when
the column contains values

Is This Answer Correct ?

3 Yes

1 No

Question { 5854 }

How to find the date and time of last updated table?

Answer

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

Is This Answer Correct ?

2 Yes

7 No

Question { 8319 }

How to find the date and time of last updated table?

Answer

select table_name from user_tables where last_analyzed in
(select max(last_analyzed) from user_tables)

Is This Answer Correct ?

4 Yes

2 No

Question { 8319 }

How to find the date and time of last updated table?

Answer

select table_name, to_char(last_analyzed, 'DD-MM-YY
HH:MI:SS') from user_tables where last_analyzed in (select
max(last_analyzed) from user_tables)

Is This Answer Correct ?

0 Yes

3 No

Question { ESS, 4753 }

SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN
WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?

Answer

Suppose that the tables are having same structure:

insert into T4 ( select ,, ... from T1
UNION select ,, ... from T2 UNION select
,, ... from T3)

Is This Answer Correct ?

6 Yes

3 No

Question { IBM, 28301 }

how will I find the first 5 highest salaried employees in
each dept in oracle.

Answer

SELECT employee_id, employee_name, salary FROM employees
where rownum < 6 ORDER BY
salary DESC
group by department_id;

Is This Answer Correct ?

4 Yes

29 No

Question { 5042 }

how will I find the duplicate rows count from employees
tablein oracle.

Answer

select employee_id, count(*) from employees group by
employee_id having count(*) > 1

Is This Answer Correct ?

18 Yes

0 No

Question { CSC, 5446 }

what is cardinality

Answer

The no. of records in a table in a table is called its
cardinality.

Is This Answer Correct ?

3 Yes

1 No

Question { Robert Half, 5571 }

how insert selected column only ?

Answer

insert into (,)
values(

Is This Answer Correct ?

11 Yes

0 No