Here we are going to discuss top 30 SQL (Structure Query Language) Server interview Questions & Answers that are generally asked in Every interview. In 2020 every day every person created 1.7 MB of Data and with the time 2.5 Quintilian bytes of data are produced by humans every day in 2020.
so now a days Database playing important role to Management Data for this purpose Relational database playing role to manage data . that why Market Demand SQL ((Structure Query Language) ) Database Administrator to Manage All data. we are here to Discuss with you. You can Download Complete PDF with 100 question and Answers.with the help of this PDF we are sure you can pass you Database Administrator Interview. PDF Downloading link given below. we are shared Complete video on our YouTube channel you can watch with Detail.
Starting with one Basic Question of SQL (Structure Query Language) Server
Difference Between Delete and Truncate Query.
Delete
- Delete Query is used to delete specific data like a Row or number of rows
- we can use Delete query simply with where clause
- With the help of delete query we can locks the table row before deleting the row
- if we have deleted something we can rollback easily .
- Delete query is slower than truncate.
Truncate
- Truncate query is used to wash complete table
- there is no option that we can use with where clause
- whenever we have Run Truncate query there is no option that we can roll back our Data
- Truncate also delete or Allocate spaces
- if we have deleted something we can rollback easily .
- It Faster then Delete
Difference Between Entities and Relationship
Entities :Data can be Store in the form of person , Place , or Thing in the real work. data can be store in the form of Data in database and table is called entities.
Relationship: When table or entities is do something with each other that is call relationship
Watch Complete Video
Leave a Comment