SQL Interview Questions (S3)

⇩
This is the 3rd one in this series. Check the 2nd one 👇

Disclaimer:

• The questions covered here are mostly conceptual
• I never claim only these type of questions are/should be asked during interviews
• For interviews, you should have fundamentals strong. And you should be able to provide solutions to practical problems.
Series: 3️⃣
Level: Beginner
Topics:

1️⃣ DDL
2️⃣ DML
3️⃣ Sequence
4️⃣ Synonym
5️⃣ Trigger
1️⃣ DDL

✪ Give some examples of DDL commands
✪ Write syntax of creating a table
✪ How to specify default value for a column?
✪ How to specify a foreign key?
✪ How to specify a unique key?
✪ How to specify multiple columns as primary key?
✪ What are different constraints you can add to a column while creating a table?
✪ How to create a copy of a table? (both structure and, data)
✪ You have 'n' tables and asked to create a separate table which will contain few columns from these tables being data copied.
✪ What is SELECT INTO used for? (SQL Server)
✪ Difference between ALTER and RENAME
✪ Can a previously nullable column be altered to a NOT NULL column? If yes, how?
2️⃣ DML

✪ What are different syntax for inserting records into a table?
✪ What is the syntax to insert multiple records at a time?
✪ Explain how DML operations are performed on a View. Or, View is for SELECT queries only?
3️⃣ Sequence

✪ What is a sequence? Why is it useful?
✪ Write syntax for creating a syntax.
✪ What does a sequence return?
✪ How to fetch the value from a sequence?
✪ Can a sequence definition be changed once after creating? What is the syntax?
✪ What details we can pass while creating a sequence?
✪ What details of a sequence can be changed?
✪ How to reset a sequence?
4️⃣ Synonym

✪ What is a synonym?
✪ Why is synonym useful?
✪ For which all database objects, a synonym can be created?
✪ Write syntax for creating a synonym.
✪ What is a public and private synonym?
✪ Can a private synonym be changed to public and vice versa later?
✪ How to change definition of a synonym?
✪ What all details can be changed for a synonym?
5️⃣ Trigger

✪ What is a trigger?
✪ Describe how a trigger functions.
✪ Write syntax for creating a trigger.
✪ What are different types of triggers?
✪ Give examples of some events (operations) for which a trigger can be run.
✪ Describe a BEFORE trigger.
✪ Describe an AFTER trigger.
✪ Describe an INSTEAD OF trigger.
✪ What can an INSTEAD OF trigger do?
✪ How to use a view for all DML operations using a trigger? Describe.
The next series would cover,

1️⃣ More on SELECT Query
2️⃣ More on Operators
3️⃣ Custom Functions
4️⃣ Stored Procedures
👇 is one of the creative content I have made. It’s a cheat sheet on creation of arrays in JavaScript. Do check and share your feedbacks.

• • •

Missing some Tweet in this thread? You can try to force a refresh
 

Keep Current with Swapna Kumar Panda ✨

Swapna Kumar Panda ✨ Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @swapnakpanda

20 Nov
JavaScript Arrays[] Interview Questions 💙

⇩
Before proceeding, do check the previous one of this series 👇

Disclaimer:

• The questions covered here are mostly conceptual
• I do not claim only these type of questions are/should be asked during interviews
• For interviews, you should have fundamentals strong. And you should be able to provide solutions to practical problems.
Read 18 tweets
14 Nov
📚 Books you must read for

⇨ DSA
⇨ SQL
⇨ JavaScript

⇩
Books were and still are the most important medium for our knowledge growth.

Do you love to read books? How about for technical subjects? If no, I would suggest you should.

Here, I will list few of my favourite ones. If you want to add any, feel free.
1️⃣ DSA

1️⃣ Grokking Algorithms
Author: Aditya Bhargava

2️⃣ Introduction to Algorithms
Authors: Thomas H. Cormen, Charles E. Leiserson, Ronald L. Rivest, and Clifford Stein

3️⃣ Introduction to Algorithms
Author: Udi Manber

4️⃣ The Algorithm Design Manual
Author: Steven S. Skiena
Read 11 tweets
13 Nov
Introduction to SQL Commands and their Categorisation

⇩
Topics to be covered:

0️⃣ Introduction
1️⃣ DDL
2️⃣ DML
3️⃣ DQL
4️⃣ DCL
5️⃣ TCL
6️⃣ Final Words
0️⃣ Introduction

✪ SQL stands for Structured Query Language.

✪ SQL is a computer language for storing, manipulating and retrieving data stored in a relational database.

✪ SQL uses certain commands to carry out the required task.
Read 16 tweets
13 Nov
🤷‍♀️ JavaScript Interview Questions (Series 3)

👉 A detailed coverage on functions

👇
Before proceeding, do check the previous one of this series 👇

Disclaimer:

• The questions covered here are mostly conceptual
• I never claim only these type of questions are/should be asked during interviews
• For interviews, you should have fundamentals strong. And you should be able to provide solutions to practical problems.
Read 18 tweets
12 Nov
💙 Spread and Rest Parameter Operators (...) in JavaScript

Follow this 🧵 for the easiest and never-to-forget type explanation. Thank me later 😝

Happy Weekend 👋

👇👇👇
🤷‍♀️ What is the need? [The Background]

We all know that an array is a collection of elements "kept together" in memory in a contiguous manner so that we can easily access any element using an index.

⇨ As all elements were kept together, how can we break those apart?
🤷‍♀️ Why does an array need to be broken apart?

If elements of an array are going to be "treated separately", you have to take all them out. Let's take an example.

🤷‍♀️ Problem: Print all elements in an array separately.
✅ Solution:

✪ If size is 1.
⇨ console.log(a[0])
Read 17 tweets
12 Nov
👉Interview Questions👈

🕸 Python 🐍 : Series 2

⇩
Series: 2️⃣
Level: Beginner
Topics:

1️⃣ Operators
2️⃣ Arithmetic Operators
3️⃣ Logical Operators
4️⃣ Comparison Operators
5️⃣ Assignment Operators
6️⃣ Operators Precedence
7️⃣ Operators Associativity
8️⃣ Operator Overloading
Before proceeding, do check the first one of this series👇

Read 16 tweets

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3/month or $30/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal

Thank you for your support!

Follow Us on Twitter!

:(