Created by : JJ Sir Mohangarden, Delhi (India)

Logical Question and Answer.

New Excel,  VBA, MS Access,  SQL, SAS and PowerBI batch starting from Saturday, contact 8319560164 for more details.

Click LINK for more Details.

Q1-What do you understand DBMS?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q2-What is RDBMS?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q3-What is difference between DBMS and RDBMS?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q4 - What do you understand by SQL? Why SQL? if we have so many new technologies in market?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q5-What is a Database?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q6-What do you understand by Schema in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q7-What are tables in Database?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q8-How many data type we have in SQL, what their limit?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q9-What is a Table?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q10-What are Fields?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q11-How many type of DQL commands in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q12-How many type of DDL commands in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q13-How many type of DML commands in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q14-How many type of DCL commands in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q15-How many type of TCL commands in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q16-What do you understand by constraints?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q17-How many type of constraints we have in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q18-What is a Record in a Database?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q19-What is a primary key?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q20-What is a composite key?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q21-What is a unique key?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q22-What is a join?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q23-What is Self-Join?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q24-What is Cross-Join?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q25-What is the difference between an inner and outer join?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q26-What is normalization?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q27-What is Denormalization?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q28-How many type of normalization we have?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q29-What is View in SQL? Why we need them?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q30-What is an Index?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q31-How many types of indexes we have in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q32-What is a Cursor?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q33-What do you understad by relationship, why we need them in database?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q34-What is a query?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q35-What is subquery?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q36-What is Inner query?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q37-What are the types of subquery?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q38-What is difference between Sub-Query and inner query?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q39-What is difference in local and global variables?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q40-What are SQL constraints?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q41-What is data Integrity?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q42-What is Auto number?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q43-What is the difference between Cluster and Non-Cluster Index?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q44-What is Datawarehouse?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q47-What is the difference between DROP and TRUNCATE?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q46-What is the difference between DELETE and TRUNCATE?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q45-What is Union,Union All, minus and Interact commands?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q48-What is the difference between Nested and Correlated?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q49-What is the use of NVL function?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q50-What is the use of decode function?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q51-What is SQL Injection?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q52-What is SQL Sandbox in SQL Server?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q53-What is the difference between SQL, PL/SQL, T-SQL and MySQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q54-What is the difference between Having clause and Where clause?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q55-What is an ALIAS command?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q56-What is the Cartesian query?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q57-What do you understand by Like operator in SQL? Why we need them in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q58-What do understand by UDF? Why we need them?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q59-What is collation?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q60-What are all different types of collation sensitivity?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q61-Few Advantages and Disadvantages of Stored Procedure?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q62-What is CLAUSE? type of CLAUSE we have in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q63-What do you understand by recursive stored procedure?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q64-What are aggregate and scalar functions?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q65-How can you create an empty table from an existing table?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q66-How to fetch common records from two tables?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q67-How to fetch alternate records from a table?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q68-How to select unique records from a table?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q69-What do you understand Auto Increment in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q70-What are the different types of SQL commands?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q71-What are the advantages of Views?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q72-What is Synchronized?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q73-What is the difference between Local Variables and Global Variables?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q74-How do we use DISTINCT statement? What is its use?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q75-What do you understand by temp table in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q76-How to avoid duplicate records in Output?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q77-What is the difference between Rename and Alias?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q78-What are the constraints available in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q79-What do you mean by query optimization? why it is important?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q80-Differentiate between NULL, Zero and Blank values in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q81-How to pull NULL values records from database?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q82-What is Referential Integrity? how it is useful?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q83-What is CTE?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q84 - What is ACID? explain with Example?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q85-Explain SQL Data Types?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q86-What are the possible values that can be stored in a BOOLEAN data field?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q87-Explain make table query?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q88-What is a transaction?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q89-What are properties of the transaction?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q90-Online Transaction Processing (OLTP) in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q91-How to pull all table information from query?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q92-What is the difference between Union and Union All command?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q94-What are string functions in SQL?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q95-What are user defined functions?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q96-What are all types of user-defined functions?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q97-How to get unique records from a query?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q98-Define UNION, MINUS, UNION ALL, INTERSECT ?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q99-How to add a column in table? Is it possible?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q101-Explain execution order of SQL SELECT?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q100-Explain writing order of SQL SELECT?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q101-Does View contain Data?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q102-How nested View works?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q103-How we can update the view?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q104-What is the difference between Delete, Truncate and Drop command?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q105-What are triggers?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q106-What are Nested Triggers?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q107-How to update triggers?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q108-How to delete duplicate records from a table?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q109-Explain the working of SQL Privileges?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q110-What do you mean by ROWID?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.


Q111-Explain Commit, revoke and rollback?

Will update soon 🙂

Click LINK for more detail, contact 8319560164 for more details.