Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
1755Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
1501Provide 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.
1510What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
3 5344What would you use to improve performance on an insert statement that places millions of rows into that table?
TCS,
2 5208If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
1 2605How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
1 2797Post New DB Administration Questions
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
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?
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 the different topologies in which replication can be configured? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
which background process invoke at the time of upgradation tell me???
how can you enable flashback feature?
Why would you use sql agent? : sql server DBA
What is transparent data encryption? : sql server DBA
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
What the different types of replication and why are they used? : sql server DBA
how can you find out if a table can be redefined?