As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
What is RAID and what are different types of RAID configurations?1 2539
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?1 4605
What is blocking and how would you troubleshoot it?1 4215
Explain CREATE DATABASE syntax?2 4881
How to start SQL Server in minimal configuration mode?1 4736
What are the different ways of moving data or databases between servers and databases in SQL Server?3 4341
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?1 3029
What is database replicaion? What are the different types of replication you can set up in SQL Server?1 2103
How to determine the service pack currently installed on SQL Server?1 2010
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?3 7319
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to start SQL Server in minimal configuration mode?
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: firstname.lastname@example.org
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :email@example.com
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
what are the differences of where and if in SAS?
Why does Oracle not permit the use of PCTUSED with indexes?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Explain materialized views and how they are used.
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.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are statistics, under what circumstances they go out of date, how do you update them?