i had backup last manday.now i need back monday to now
..how do get backup?
Answer Posted / sarmistha
Take Differential Backup
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are statistics, under what circumstances they go out of date, how do you update them?
Can you redefine a table online?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What is fill factor? : sql server DBA
What is a system database and what is a user database? : sql server DBA
how can you record information about current session?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What would you do with an "in-doubt" distributed transaction?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What purpose does the model database server? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
What are the different sql server versions you have worked on? : sql server DBA