Skip to main content

Interview Questions : Databases Interview Questions For Fresh To Intermediate Level

Database is a fast growing domain and databases jobs are increasing day by day as we are getting advance technologies for keeping and managing our data in different places. Sometimes, being a programmer, it is almost guaranteed that you have to work on database in your programming career. Every programmer must deal with some type of data, and that is stored in database.

 Knowing about the basic things is very important; you must have good knowledge about database for being successful programmer. However, advance knowledge of everything makes you valuable no matter which field you are related to.  We will discuss a little SQL and database interview questions that maybe asked during interviews.
·        Definition of database
·        DBMS and RDBMS
·        Kind of interactions by DBMS
·        Isolate database technology’s development
·        Database model
·        Purpose of database language
·        Describe Union All and Union operator
·        Definition of cursor
·        Advantage and disadvantages of query
·        Index Hunting
·        Define B-Trees
·        Database Portioning and its importance
·        DDL interpreter
·        Aggregation and Atomicity
·        Transaction Phases
·        Entity and its types
·        Query Evolution Engine
·        Database System
·        Difference between Nested Loop, Hash Join and Merge Join
·        Definition of fragmentation
·        Difference between Table Scan and Index Scan
·        Method to efficiently code transactions
·        What do you mean by executive plan
·        Definition of Data warehousing
·        Definition of Correlated sub queries
·        Explain some commands of DDL
·        Features of database language
·        Normalization and de-normalization
·        Define Stored Procedure
·        Define Trigger
·        Definition of Storage Manager, Buffer Manager, Transaction Manager, File manager
·         Types Of Normalization
·        Differentiate between Truncate and Delete Table
·        Differentiate between Extension and Intension
·        Define Data Independence and its types
·        Differentiate between Entity, Entity Type and Entity Set
·        Explain Data Mining
·        Explain ELT Process in Data warehousing
·        Disadvantages of File Processing System
·        Explain three levels of data abstractions
·        Define View and its relationship with data independence
·        Define E-R model and Object Oriented Model
·       Differentiate between Data Definition Language, View Definition Language and Storage Definition   Language?
·        Explain DML and DDL complier
·        Differentiate between 1NF, 2NF, 3NF, 4NF and 5NF?
·        Explain Domain-Key Normal Form?
·        Explain Correlated Sub-query?
·        Explain Proactive, Retroactive and Simultaneous Update
·        Explain Simple Key?
·        What is the difference between Unique, Index and Primary Key?


Labels:

Comments

Post a Comment

Popular posts from this blog

Testing techniques that can be used to test a Smart Contract

There are several testing techniques that can be used to test a smart contract. Here are some of the most common ones: Unit Testing: This is a technique where individual units or components of a smart contract are tested in isolation to ensure that they work as expected. Integration Testing: This technique is used to test how different components of a smart contract work together to ensure that the entire system functions correctly. Functional Testing: This technique is used to test the functionality of a smart contract by executing various test cases to ensure that it behaves as expected. Security Testing: This technique is used to identify vulnerabilities and weaknesses in a smart contract's code that could be exploited by attackers. Performance Testing: This technique is used to test the speed, scalability, and reliability of a smart contract under various loads and conditions. Regression Testing: This technique is used to ensure that changes made to a smart contract do not in...
Post a Comment
Read more

On-the-job training - Training the New Employees at the Workplace

Fresh graduates or interns in their last year of bachelors, hired often have little to no work experience when they are called for interviews and taken into the team. It is because for most of them, it’s their very first interview and job and since they are never worked before, they are new to the office environment and how things work in a company and how the skills learnt in the bachelors are applied in the practical life. Usually, employees are given training on the job and assessed over a certain time period specified depending on the company, so that the company can know if the hired employee can hold on to the real-time pressures and be a part of the team, delivering quality service. Some companies however, cover the training during the internship period of the employee, and if they manage show good enough skills, they are offered a permanent job. That ensures that the employee is already prepared when he/she starts working for the company. But what if you’re left wit...
Post a Comment
Read more

Got an Interview? Here are 7 Ted Talks to watch before an Job Interview to make it awesome

So you have already done lots of research on job interview s and how to give the best interview. You already know what to do. Dressing well, being on time, definitely not winging it, and leaving a follow-up thank-you note for your interviewer, great. But you feel that’s just not enough for you. Often times even the most prepared candidates stumble after sitting on the chair. Luckily, there are inspirational videos on the popular media organization TED Talks , y ou can watch, which will give you a confidence boost for your next job interview . How to stay calm when you know you’ll be stressed-by Daniel Lavitin Just before a day or two, or for some, a week before the job interview , nervousness starts to kick in. You start to panic and get anxious how your interview will go. It’s actually pretty usual for such feelings to occur but thinking as such will likely make them really happen during the interview. Daniel Levitin, who’s a cognitive psychologist and a neuroscientist, ...
Post a Comment
Read more