Blog Archives
Page 1 of 3
1 2 3

10: Getting started with MySQL database beginner tutorial

All Java developers not only must know “SQL”, but also a database is required for “JDBC tutorials”, “Hibernate Tutorials”, and so on. Any decent Java application will require a database. So, your self-taught Java projects must perform CRUD (i.e. Create Read, Update and Delete) operations on the database.

Read more ›



14+ SQL beginner interview Q&As

SQL interview Questions & Answers is a must for any developer as all non-trivial applications need to talk to a database with CRUD operations. Q3 – Q15 are very popular with the interviewers. If you want to quickly practice your SQL skills try DB Fiddle or install MySQL locally as...

Members Only Content
Log In Register Home


15 Database design interview Q&As

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
Log In Register Home


15+ 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

Read more ›



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. … Read more ›...

Members Only Content
Log In Register Home


Page 1 of 3
1 2 3

800+ Java Interview Q&As Menu

Top