Answer Posted / guest
alter system switch logfile
Regards
Abhinav Phadnis
| Is This Answer Correct ? | 19 Yes | 2 No |
Post New Answer View All Answers
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.
What is the default port no on which sql server listens? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What types of replication are supported in sql server? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Where would you look for errors from the database engine?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
what do you understand by fine-grained auditing?
how can you implement fine-grained auditing?
Which autogrowth database setting is good? : sql server DBA
What is dcl? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?