Blog Archives

♦ 9 SQL scenarios based interview questions answered

Q1 How will you go about identifying duplicate records in a table? A1 The following SQL query will do the trick.

Note: Interviewer is testing if you understand that the aggregate queries need to have a “group by” clause on columns that are not aggregated. E.g. code, user_name. Finding

Read more ›

Posted in Judging Experience Interview Q&A, SQL

Deleting records in SQL Interview Questions and Answers

The following is a very popular SQL job interview question. Q. What is the difference between “Truncate” and “Delete” commands? A.  TRUNCATE TABLE_NAME always locks the table and page but not each row, whereas  DELETE statement is executed using a row lock, each row in the table is locked for

Read more ›

Posted in SQL

SQL Subquery interview questions and answers

Q. What is a subquery? A. Subquery or Inner query or Nested query is a query in a query. A subquery is usually added in the WHERE clause of the sql statement. A subquery can be nested inside a SELECT, INSERT, UPDATE, or DELETE statement or inside another subquery.  Subqueries

Read more ›

Posted in SQL

Auditing database record changes in Oracle

Q. What are some of the considerations in auditing database table data? A. Creating audit tables without any constraints to store record changes.  Audit tables are heavily hit with inserts, hence needs to have fewer indices if at all required. Decide on what combination of triggers are required like  Create,

Read more ›

Posted in QoS, SQL
Tags:

Transaction management in SQL — Sybase example

Q. How do you perform transaction management in SQL stored procedures? A. Handled with begin, commit, and rollback ‘tran’ commands in Sybase server. Q. Why is it important? A. It is important to leave the database in a consistent state. Q. Can you give an example? A. For example, as demonstrated

Read more ›

Posted in SQL, Transaction Management

♦ 14+ SQL interview Questions & Answers

Q1. Can you explain DDL statements in regards to SQL? A1. DDL stands for Data Definition Language, which are statements used to define the database structure or schema. CREATE – to create objects in the database, ALTER – alters the structure of the database, DROP – delete objects from the…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Training, 90-Day-Java-JEE-Career-Training, 180-Day-Java-JEE-Career-Training, 365-Day-Java-JEE-Career-Training, 60-Day-Java-JEE-Career-Training, 2-Year-Java-JEE-Career-Training and 10-Day-Java-Interview-Refresher

Want to evaluate the quality of the contents to see if they will add value to you?

Click Here and check the contents with Try.

Log In | Register
Posted in member-paid, SQL
Tags: , ,

♦ 15 Database design interview Questions & Answers

Q1. What is normalization? When to denormalize? A1. Normalization is a design technique that is widely used as a guide in designing relational databases. Normalization is essentially a two step process that puts data into tabular form by removing repeating groups and then removes duplicated data from the relational tables.…...

Members Only Content

This content is for the members with any one of the following paid subscriptions:

30-Day-Java-JEE-Career-Training, 90-Day-Java-JEE-Career-Training, 180-Day-Java-JEE-Career-Training, 365-Day-Java-JEE-Career-Training, 60-Day-Java-JEE-Career-Training, 2-Year-Java-JEE-Career-Training and 10-Day-Java-Interview-Refresher

Want to evaluate the quality of the contents to see if they will add value to you?

Click Here and check the contents with Try.

Log In | Register
Posted in member-paid, SQL
Tags: , ,
1050+ subscribers. Reviews | Free Contents. 220K+ page views/month. Certified or not, you will be challenged with industrial strength problems to solve at work & job interviews.

600+ Interview Q&As – ♥ Free, ♦ FAQs

open all | close all

200+ FAQs for Quick Interview Prep

open all | close all

16 Technical Key Areas to standout

open all | close all

80+ Tutorials for self-taught projects

open all | close all

100+ pre-interview coding tests

open all | close all

How good are your …..?

open all | close all