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 ...
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 ...
Submit an interview question Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of Toptal, LLC. Name Email Enter Your Question Here … Enter Your Answer Here … I agree with the Terms and Conditions of ...
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. ...
Here are some e-commerce SQL interview questions: 1.Product Catalog Query: Write an SQL query to retrieve the names and prices of all products in the product catalog. 2.Order Summary Query: Create an SQL query to calculate the total revenue generated from orders placed in the last month. ...
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?
Advanced SQL Server Interview Questions Now that we've covered intermediate-level concepts let's dive into some advanced SQL Server interview questions. What are the different types of replication in SQL Server (Transactional, Merge, Snapshot)?
6.What are different types of indexes?(Mostly asked in Interview Questions For SQL) Answer: There are following types of indexes used while Indexing in SQL: 1.Normal index 2.Unique Index 3.Bit Map Index 4.Composite Index 5.B-Tree Index(Oracle considered Normal indexes as B-Tree Indexes) ...
创建表格 - 接下来,我们需要在数据库中创建一个表格来存储面试题的相关信息。 ```sql USE InterviewQuestions; GO CREA Server SQL sql 原创 mob64ca12d652c7 2023-12-16 07:56:14 44阅读 sql server的sql面试题 sql server常见面试题 1.磁盘柜上有14块73G的磁盘, 数据库为200G 大小包括日志文件,...
觉得不错,记录一下 转载:https://www.yanxurui.cc/posts/mysql/2016-11-10-10-sql-interview-questions/ 很多查询都可以用经典的学生-课程-成绩案例来表示 表结构 学生表student(id,name) 列表项目 课程表cours