AXA Tech. Interview on 31 May 2014

AXA Tech. Interview on 31 May 2014

 

1.       If standalone production server is crashed what do you do?

2.       If standalone DB is crashed what do you do?

3.       How do you differentiate Windows Login and SQL Login?

‘Sp_helplogins’ gives the Login List. There you can differentiate Windows Login which is in format ‘<SERVERNAME>\<LOGINNAME>’

Go to INSTANCE>Security>Logins    

select loginname from sys.syslogins

 

4.       Pre and Post DB Migrations activities checklist?

5.       Explain Login Property dialog options and their significance?

6.       Alll of sudden, one Login/User not able to access the server and DB? What might be the reason?

7.       How do you fix users/Logins when DB/Server Migrated?

8.       What happens to Log backup job while full backup Job is running?

9.       How to check current running backup Progress and backup jobs information?

10.   How to check Long Running queries and understand its cost to resources?

11.   How to estimate the time for long running queries? (Ex: When it started and how much time it needs still to complete?)

12.   How do you monitor and improve performance with help of Which DBCC and DMV commands?

13.   Where can you check (error log/event log or what) for New Table creating status?

14.   What is the procedure to create an alert to DBA when a table is created?

15.   Explain about Query Execution Plan?

16.   How do you check if Login/User can access the database?

 

In Login Properties dialog under ‘User Mapping’ section, we can see which DB can be accessed by the Login

 

17.   Backup Strategy for 200GB Database for 2005 and 2008 versions?

18.   Compression is available in which versions of SQL and in which editions Compression is available in 2008?

19.   Mirroring and Logs hipping technologies same?

20.   How and where do you check for which hotfix is installed in the Syster?

 

21.   How to restore a deleted table from backups

 

22.   What possible errors you may get while DB is being restored?

 

23.   How do you create New server from Crashed Server

 

24.   One Old login lost access to Server and DB? What might be the reasons?

 

25.   Where do you enable compression?

 

‘Database Settings in Server Properties Dialog

<Write Command line queries.>

 

26.   What error message you check if a table is created.

27.   How do you check and fix orphaned users?

28.    

29.   Pre and Post actions after migrating servers from Prod to PreProd environment?

30.   In 2000, how do you check for long running queries?

31.   How do you check Windows Version?

32.