Interview questions

System Engineer interview questions – page 3

100 questions. Tap “Show answer” to check yourself.

  1. Define about Link Server in Sql Server?

  2. Explain Indexing and what are the advantages of it?

  3. Why to use Cursor in Sql Server?

  4. What is meant by SQL Wildcard Characters in Sql Server?

  5. List out the differences between Union, Interact and Minus operators?

  6. Why to use Cross Join in Sql Server?

  7. Define Common Table Expression (CTE) in Sql Server?

  8. Define 'CHECK Constraint' in Sql Server?

  9. Define 'ROW_NUMBER()' in Sql Server?

  10. What is terminal emulation, in which layer it comes?

  11. Tell the minimum and maximum length of the header in the TCP segment and IP datagram?

  12. Define Beaconing?

  13. Define virtual channel?

  14. Explain OSPF?

  15. Name the different type of networking / internetworking devices?

  16. Define Gateway-to-Gateway protocol?

  17. Expand IDEA in terms of networking?

  18. Describe passive topology?

  19. What do you mean by redirector?

  20. Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?

  21. Define a Data Dictionary ?

  22. Describe the different type of Integrity Constraints supported by ORACLE ?

  23. Can objects of the same Schema reside in different tablespaces.?

  24. What are the components of Logical database structure of ORACLE database?

  25. What is the use of Redo Log Information ?

  26. What are the Referential actions supported by FOREIGN KEY integrity constraint ?

  27. What are the components of Physical database structure of Oracle Database?

  28. How to define Data Block size ?

  29. What is npa

  30. Define Private Database Link ?

Companies that ask System Engineer questions