Tag Archives: sql interview question and answers for fresher






MySql Interview Questions and Answers – Part 9

81 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”

more..

MySql Interview Questions and Answers – Part 8

71 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 72 What is

more..

  • Email Subscription

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

    Subscribe Here

  • Twitter Followers

    1377 people follow tut2learn
    swainudayabhanu swainuda GraciaStoessel3 GraciaSt danielgrc707 danielgr AmirKha40033031 AmirKha4 suren14386 suren143 J_D_Landis J_D_Land
Popup Dialog Box Powered By : XYZScripts.com
  • RSS
  • Facebook
  • Google+
  • Twitter