1. Unable to start SQL Server, what is the reason, how to find issue? A: Check Physical Error Log path : Open Configuration Manager > RC properties of Instance >Advanced check Startup Parameter 2. Log file is corrupted (there is no backups, how u will...
Log file is corrupted (there is no backups, how u will get database? A: SELECT name, state, state_desc FROM sys.databases WHERE name='ABCD' Output for state_desc was RECOVERY_PENDING. I instructed him to set database to the emergency mode. ALTER DATABASE...
Resource Governor 1. What is Resource governor? A: Resource Governor is a feature which can manage SQL Server Workload and System Resource Consumption. We can limit the amount of CPU and memory consumption by limiting /governing /throttling on the SQL...
SQL DBA-INTERVIEW QUESTIONS INTERVIEW QUESTIONS --------------------------------------------------------------------------------- 1. What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We...
· What is a “Database Transactions “? · What is ACID? · What is “Begin Trans”, “Commit Tran”, “Rollback Tran” and “Save Tran”? · What are “Checkpoint’s” in SQL Server? · What are “Implicit Transactions”? · Is it good to use “Implicit Transactions”? ·...
Attach\Detach: 1. Take full database backup before performing activity. 2. After go to SQL Server database> tasks> detach> select drop all connections options 3. Copy files from one location to another location by using copy option but not cut method....
/3GB Switch: ___________________ By default SQL Server can be able to utilize 2 GB max meO\Smory in 32-bit o/s. If required to use SQL Server more than 2 GB then recomnded to enable /3GB swtch in BOOT.INI file. Note pad will be opened and at last enable...
Active Directory: Its a framework that holds the objects. The AD network can be addressed at different levels (Forest, Tree and Domain). Active Directory || Forest || Tree || Domains || Objects (Nodes/Computers) Forest: A forest is a collection of trees...
Examlpes For Complex Views Here are few examples of complex views in Oracle, a)Create Or Replace View Dept_Sum_Vu (Name,Minsal,Maxsal,Avgsal) As Select D.Dname,Min(E.Sal),Max(E.Sal),Avg(E.Sal) From Emp E,Dept D Where E.Deptno=D.Deptno Group By D.Dname...
Update and Delete in Correlated Sub query Correlated sub queries as you all know are used for row-by-row processing. Here each sub query is executed once for every row of the outer query. The oracle server performs a correlated subquery when the subquery...
