Tag Archives: RDBMS Interview functions

RDBMS Interview Questions and answers – Part5

41 What are indexes? What are B-Trees? Index makes your search faster. So defining indexes to your database will make your search faster.Most of the indexing fundamentals use “B-Tree” or “Balanced-Tree” principle. It’s not a principle that is something is created by SQL Server or ORACLE but is a mathematical derived fundamental.In order that “B-tree”


RDBMS Interview Questions and answers – Part4

31 Can you explain the SELECT INTO Statement? SELECT INTO statement is used mostly to create backups. The below SQL backsup the Employee table in to the EmployeeBackUp table. One point to be noted is that the structure of pcdsEmployeeBackup and pcdsEmployee table should be same. SELECT * INTO pcdsEmployeeBackup FROM pcdsEmployee 32 What is


RDBMS Interview Questions and answers – Part3

21 How to select the first record in a given set of rows? Select top 1 * from sales.salesperson 22 What is the default “-SORT ” order for a SQL? ASCENDING 23 What is a self-join? If we want to join two instances of the same table we can use self-join. 24 What’s the difference


  • Email Subscription

    Sign-up for our email newsletter and get free job alerts, current affairs and GK updates regularly.

    Subscribe Here

  • Twitter Followers

    1338 people follow tut2learn
    Kkkkiranjjj Kkkkiran himanshuast1585 himanshu Rachna997136829 Rachna99 DeepakS66027410 DeepakS6 kavadmayur7 kavadmay RenuKhurdi RenuKhur
Popup Dialog Box Powered By : XYZScripts.com
  • RSS
  • Facebook
  • Google+
  • Twitter