Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


write the Sql query for creating database backup?

Answers were Sorted based on User's Feedback



write the Sql query for creating database backup?..

Answer / gourvendra singh

if you need to take tha backup of the database on ur hard
disk then u can use the following query:

exp userid=system/manager@orcl file=location\abc.dmp full=y
log= abc

Is This Answer Correct ?    23 Yes 4 No

write the Sql query for creating database backup?..

Answer / k.l.rajesh babu

BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'

Is This Answer Correct ?    16 Yes 2 No

write the Sql query for creating database backup?..

Answer / suresh

BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'

Is This Answer Correct ?    8 Yes 1 No

write the Sql query for creating database backup?..

Answer / vikneswaran

SELECT column_name(s)
INTO new_table_name
FROM old_tablename

Is This Answer Correct ?    3 Yes 8 No

write the Sql query for creating database backup?..

Answer / rk

we can do it from user_tables

like

select table_name,tablespace_name from user_tables;

Is This Answer Correct ?    5 Yes 12 No

write the Sql query for creating database backup?..

Answer / ganesh

create table backup as select * from user_tables;

create table backup1 as select * from user_source;

Is This Answer Correct ?    4 Yes 13 No

write the Sql query for creating database backup?..

Answer / manojbatra071

create table backuptablename as select * from originaltablename;

Is This Answer Correct ?    3 Yes 13 No

Post New Answer



More SQL PLSQL Interview Questions

What are predefined functions in sql?

0 Answers  


What is the left table in sql?

0 Answers  


How do I view a sql trace file?

0 Answers  


Why we use joins in sql?

0 Answers  


Where not exists in sql?

0 Answers  






tell us something about heap tables. : Sql dba

0 Answers  


What is the difference between SQL and PLSQL

4 Answers   IBM,


why use cursors?

5 Answers   Oracle,


how to shut down the server with 'mysqladmin'? : Sql dba

0 Answers  


What is differance unique key and primary key.

7 Answers   EDS,


table :- city name country code abc 11 bcd 22 cde 232 def 33 write a procedure , so that when we give a phone no. eg - 1123456789 - o/p sud be city name = abc if phone no. - 2322345897 , o/p sud be =cde note - bcd and cde city name sud be diff. as dey diff only with th last no. Pls ans. this questnion.

1 Answers  


What does over partition by mean in sql?

0 Answers  






Categories