We can explicitly start a distributed transaction using “BEGIN DISTRIBUTED TRANSACTION <TranName>” For example, if BEGIN DISTRIBUTED TRANSACTION is issued on ServerA, the session calls a stored procedure on ServerB and another stored procedure on ServerC. The stored procedure on ServerC executes ...
But what if you have to create a database with two filegroups, one on drive C and the other on drive D with log on drive E with an initial size of 600 MB and with a growth factor of 15%? That's why being a DBA you should be familiar with the CREATE DATABASE syntax. Check ...
SQL Interview Questions and answers on Stored Procedures and Triggers What is a stored procedure? Stored Procedure is a function which contain collection of SQL Queries. Procedure can take inputs , process them and send back output. SQL INTERVIEW QUESTIONS AND ANSWERS 14 | P a g e 51.What ...
Intermediate PL/SQL Interview Questions Having covered the basic questions, now let's move on to some intermediate-level data structure interview questions. After testing your basic knowledge, interviewers are going to now test your technical proficiency in implementing and using PL/SQL concepts. 5. ...
Hello All, I have been collecting interview questions from the people who given interviews at various organizations. Below are the list of questions. It includes, SQL DBA, MSBI, SQL Developer, SQL Server. 1 SSRS: 1. How to render a report to a user email?
List of Top 500 SQL Interview Questions & Answers with queries and more - GitHub - kansiris/SQL-interview-questions: List of Top 500 SQL Interview Questions & Answers with queries and more
These are just basic questions and you can check the data analyst interview questions here. CLICK HERE TO GET INTERVIEW QUESTIONS FOR TCS… Following are some important Interview Questions for SQL : 1.What is SQL?Where SQL is used? Answer: SQL is Structured Query Language, which is a ...
Information from a previous student "asked in an interview". What is a linked server? Allows remote access and the ability to write queries directly on a database on another machine.Day03 What is a cursor? (A loop that allows row by row processing in a result set.In order to work ...
Intermediate SQL interview questions with detailed answers: 11. Find Customer Order Counts Question: Write a query to list customers who have placed more than 5 orders. Use the customers and orders tables. Answer: SELECT c.customer_id, c.customer_name, COUNT(o.order_id) AS order_count ...
觉得不错,记录一下 转载:https://www.yanxurui.cc/posts/mysql/2016-11-10-10-sql-interview-questions/ 很多查询都可以用经典的学生-课程-成绩案例来表示 表结构 学生表student(id,name) 列表项目 课程表cours