Answer Posted / guest
alter system switch logfile
Regards
Abhinav Phadnis
Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
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 dbcc? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how can you find out if a table can be redefined?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : 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.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is fill factor? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
internal architecture
how can you create a user-defined lock?
What is the importance of a recovery model? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
what is asm?