Interview questions

Database Administrator (dba) interview questions – page 31

1,040 questions. Tap “Show answer” to check yourself.

  1. What is VLDB?

  2. What is the difference between off-line back up and on-line back up in ibm db2 udb?

  3. What are the steps you will take, if you are tasked with securing an SQL Server?

  4. Can we have two reports running parallely and both the reports sharing the same internal table for processing the data?

  5. What is the soft code for deadlock ?

  6. What is the disk migration?what isthe steps involved in diskmigration?

  7. How do I handle -911 (deadlock) error in a db2 program sothat the program will never abend?

  8. Wht happens if we close cursor with cursor with hold option?

  9. Select names starts with a,b,c

  10. Why you choose teaching as a profession?

  11. How to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables?

  12. Which NLS parameter can be specified only as an environment variable?a. NLS_LANGUAGE b. NLS_LANGc. NLS_TERRIROTYd. NLS_SORT

  14. Which command is used to define CONNECT and RESOURCE as the default roles for user JAMES?a. ALTER USERb. ALTER ROLEc. SET ROLEd. SET PRIVILEGE

  15. Which clause should be specified to enable the grantee to grant the system privilege to other users?a. WITH GRANT OPTIONb. WITH ADMIN OPTIONc. CASCADEd. WITH MANAGE OPTION

  16. What are constraints? Explain different types of constraints?

  17. Can we rewrite subqueries into simple select statements orwith joins? Example?

  18. What is the Magic Tables in Sqlserver2000?

  19. I have 1000 rows in a db2 table.I want to update first 100records,How do I do it?

  20. How do you fetch current date in normal cobol pgm and incobol-db2 pgm?

  21. When you feel that a team is working efficiently, except for the fact that one member is clearly not pulling their weight? What steps will you take?

  22. Choose two NLS parameters that cannot be modified using the ALTER SESSION statement. a. NLS_CHARACTERSET b. NLS_SORTc. NLS_NCHAR_CHARACTERSETd. NLS_TERRITORY

  23. What role views play in dimensional modeling?

  24. What is the difference between IN subselects and EXISTS subselect?

  25. Is data insertion is fast in SYBASE IQ if we have moreindexes on a table?

  27. What are conformed dimensions?

  28. When a new user is created, and you do not specify a profile,a. Oracle prompts you for a profile name. b. No profile is assigned to the user. c. THE DEFAULT profile is assigned.

  29. Can Somebody tell me the difference between Clustered & Non-Clustered Index?

  30. The dd name for ksds is dest1 and what is the dd name for alternate index of ksds ?a.dest b.dest1 c.dest1a d.dd1

  31. How to insert more than one record using insert?

  32. What are the possible data marts in Retail sales.?

Companies that ask Database Administrator (dba) questions

Bending Spoons Interview guide Spiralyze Interview guide Winman Software India Interview guide Namecheap Interview guide Softsquare Interview guide E-Con Systems Interview guide