- What is RDBMS?
- What is SQL?
- What is a Database?
- What are tables and Fields?
- What do you mean by data manipulation language - DML?
- What is a primary key?
- What is a unique key?
- What is a foreign key?
- What is a join?
- What are the types of join and explain each?
- What is normalization?
- What is Denormalization?
- What are all the different normalizations?
- What is a View?
- What is an Index?
- What are all the different types of indexes?
- What is a Cursor?
- What is a relationship and what are they?
- What is a query?
- What is subquery?
- What are the types of subquery?
- What is a stored procedure?
- What is a trigger?
- What is the difference between DELETE and TRUNCATE commands?
- What are local and global variables and their differences?
- What is a constraint?
- What is data Integrity?
- What is SQL comments?
- What is Auto Increment?
- What is Datawarehouse?
- What is the difference between SQL and PL/SQL?
- What is the difference between SQL and MySQL?
- What is the difference between Cluster and Non-Cluster Index?
- What is Self-Join?
- What is Cross-Join?
- What is user defined functions?
- What are all types of user defined functions?
- What is collation?
- What are all different types of collation sensitivity?
- Advantages and Disadvantages of Stored Procedure.
- What is Online Transaction Processing (OLTP)?
- What is CLAUSE?
- What is recursive stored procedure?
- What is Union, minus and Interact commands?
- Which TCP/IP port does SQL Server run?
- What is an ALIAS command?
- What is the difference between TRUNCATE and DROP statements?
- What are aggregate and scalar functions?
- Which operator is used in query for pattern matching?
- How to select unique records from a table?
- List and explain each of the ACID properties that collectively guarantee that database transactions are processed reliably.
- What is the main difference between ‘BETWEEN’ and ‘IN’ condition operators?
- Why are SQL functions used?
- List the ways in which Dynamic SQL can be executed?
- List some case manipulation functions in SQL.
- What is a Non-correlated subquery?
- What is a SYSTEM Privilege?
- What are Object Privileges?
- What does the BCP command do?
- Does the data stored in the stored procedure increase access time or execution time? Explain
- Can a Stored Procedure contain a return value?
- Can a View be active if the Base table is dropped?
- What is the difference between the RANK() and DENSE_RANK() functions? Provide an example.
- What is the difference between char and varchar2?
- What is CTE?
- Does View contain Data?
- Define a temp table.
- What is Referential Integrity?
- What do you mean by query optimization?
- What is Database Black Box Testing?
- What do we need to check in Database Testing?
- What are Nested Triggers?
- What is SQL Sandbox in SQL Server?
- What is SQL Injection?
- What is returned by the cursor attribute SQL%NOTFOUND?
- What do you understand by explicit cursors?
- What is Deadlocking?
- How can you say that Database testing is different from that of GUI testing?
- How to prevent SQL Injection Attacks?