Name three advisory statistics you can collect.
Answer / chowdary
Buffer Cache Advice, Segment Level Statistics and Timed
Statistics
| Is This Answer Correct ? | 4 Yes | 0 No |
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
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
Explain the use of table functions.
From the database level, how can you tell under which time zone a database is operating?
Which autogrowth database setting is good? : sql server DBA
why we use cursors
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
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 will u copy the objects of one schema to another schema in datapump & export/import?
What is checkpoint?
How would you determine who has added a row to a table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)