write the Sql query for creating database backup?
Answer Posted / suresh
BACKUP DATABASE DATABASE_NAME TO DISK='C:\BackupDB\DB.bak'
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are its different types of dbms?
What are local and global Indexes and where they are useful.
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
What is sql and db2?
What does the argument [or replace] do?
What are transaction and its controls?
how many sql dml commands are supported by 'mysql'? : Sql dba
What is pl sql variable?
What is pl sql block structure?
What are aggregate and scalar functions?
What are the possible values for the boolean data field?
What will you get by the cursor attribute sql%notfound?
what is transaction? : Sql dba
What is output spooling in sql*plus?
What is pl/sql language case sensitive?