i need a brief information about db2 dba course and realtime
experts if any plz inform me
nareshbhupathi93@gmail.com
plzzz urgent
Answer / hraju.mr
Hi Naresh,
DB2 is a relational database from IBM and mainly used for
applications like any othr database products from
Oracle.the Procedure here is similar to work with
almost.There are 2 different platforms that you can go
ahead with this technology....as application programmer and
DataBase Architecture.here the second one is the one which
includes the responsibilities of designing
database,Tablespaces ..taking backups running the
Utitlities both Online and Offline..ofcourse this is an
intersting subject that u can always rely upon..
| Is This Answer Correct ? | 2 Yes | 0 No |
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 would you go about generating an EXPLAIN plan?
What is transparent data encryption? : sql server DBA
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
What is the difference between Datapump & export/import?
What are the different sql server versions you have worked on? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What the different topologies in which replication can be configured? : sql server DBA
Query processing is slow(eg select query)how will u solve that
How would you best determine why your MVIEW couldn't FAST REFRESH?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
how can you enable flashback feature?
Oracle (3253)
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)