ASE/REP/IQ Interview Ques

Adaptive Server Enterprises :

Q1: Please let me know system db names, what is the purpose of sybsystemdb?

Q2: Suppose our tempdb is filling up or filled up, you cant recycle the db server, then what would be your steps?

Q3: Business Team(AD) is reporting the query slow performance, how will you investigate, pls consider all case.  (Hint: memory, stats, indexes,reorg,locks etc)

Q4: Suppose our temdb is not recovered ,can we create new database?

Q5:  We have configured 7 dataserver engines  for our PROD server(we have sufficient cpus), still we are facing the performance hit? Possible root cause?

Q6: Suppose we are doing the ASe 15 upgrade by dump & load , and in 12.5 server having 2000 logins. Since syslogins having different table structure in both enviorment, we cant use bcp,  how will we move these logins from 12.5 to 15.0?

Q7: Which feature of ASE15.o most impressed you and why?

Q8: What is your org's backup policy, what is dump tran with standby_access?

Q9: What is log suicide ?

Q10: When we require log suicide of a DB?

Q11: What is the bypass recovery, when we require the bypass recovery?

Q12: What is the difference between shutdown and shutdown with no_wait, besides the immediate shutdown difference.

Q13: Suppose In our one database  huge trans are going on, we issued the shutdown with no_wait . Will it hit the server restart and how?

Q14: Whats the named data cache, what is buffer pooling and how the cache hit effects the system performance ?

Q15: We are getting stack traces for one of our databases? How will you investigate?

Q16: Is object level recovery possible in ASE?

Q17: What is the difference between sysstats and systabstats table?

Q18: What is histogram and what its default step value?

Q19: Why we requires non default step value in histogram ?

Q20: Can we run the update stat on one table one two step(halt table in first time and after that  rest half of table)?

Interview Questions on User Management & Permissions

1. What is sybase security model for any user/login?

2. What is the diffrence between syslogins and sysusers?

3. How can we add the login in ase? What are the required parameter of sp_addlogin?

4. What are aliases?

5. Whats the diff between role and group and which one is better?

6. How can we sync the logins from prod to uat server, how many tables we need take care for the login sync?

7. Whats suid mismatch?

8. Why do we require aliases?

9. Whts the importance of sysrole table in each database?

10. Explain syslogins syssrvroles, sysloginroles and sysroles and whts the linkup among all?

11. What is proxy authorization?

12. During the refresh from PROD -> UAT env,tables which we require to take care?

13. Explain about sysprotect tabel and sp_helprotect sp?

14. Can we change the password of other login, if yes, how?

15. What is the role required for user management?

16. diffrence b/w 12.5 syslogins and 15.5 syslogins?

17. What is guest user in database and why we require guest user?

18. What is the keycustodian_role in ASE 15.5?

19. How can we include the passwordpolicy? explain sp_passwordpolicy?

20. Can we include password history feature? From which version it is avilable and how can we do that?

21. Can we include one sql proc which exceute during login and how can we do that?

Replication Server:

Q1:  How can we know, the current ASE and Replication Server Setup is  warm standby setup or not?

Q2: What is the function of SQM and SQT?

Q3: What is the 1TP & 2TP?

Q4: In how many ways we can know the tran details which is causing the thread down?

Q5 : Pls explain the functionality of rep server starting from PDB logs to RDB

Q6: What is the diff between DSI and DSI EXEC thread?

Q7: Can we dump the queues?

Q8: Suppose our queues are filling up, in next 2 hrs 100% would be fill, how will you investigate and steps for troubleshooting?

Q9: How can we know RSSD server name from replication Server?

Q10: What is the importance of materialize & de-materialize queue?

Q11: What is DIST thread of Replication server?

Q12: What is the difference between connection and route?

Q13: What is the purpose of ID server in replication setup?

Q14: What is switch active ?

New Questions:

What is the diffrence between sp_setreplicate and sp_setreptable?

What is the diffrence between route and connections?

How can we check the current replication setup whether it is WS , table level or db level?

What would be  the impact of long running tran running in PDB in whole replication setup?

suppose there is temp table in sp and we want to replicate it?

What is the importance of rs_locator table in replication server?

What is dbcc settruc ltm, valid/ignore? When we use this dbcc command?

What is diffrence between rs_zeroltm and dbcc settrucn ltm,valid?

What are the diffrent users in common replication setup?

What is rs_subcmp?