Entry-level technical interview question for software engineer.(PART-2)
1.
What are method overriding and method overloading?
Method Overloading- Method to create two or more functions having the
same name but different signatures based on their arguments.
Method Overriding- Method to override the same subclass with the same
signature.
2.
What is DBMS, What is the difference between DBMS
& RDBMS & RDSMS?
DBMS (Data Base Management System) - It is a computer system to store data that stores
data in form of a file.
i.e.
- file system, xml…
RDBMS (Relational Data Base Management System) –
It
is a computer system to store data that stores data in a tabular form and with the
purpose of ACID properties.
i.e.
- MySQL, postgre, oracle…
RDSMS (Relational Data Stream Management System) –
In
RDSMS standard-compliant SQL is used to process structured and unstructured
data.
3.
What is SQL?
(Structured
Query Language) is a language used by a database like RDBMS and RDSMS.
4.
What are ACID properties in DBMS? Or Define Atomicity, Consistency, Isolation,
and Durability properties?
Before
knowing ACID properties, there is a concept called transactions in DBMS to be understood
clearly
A
transaction is a single logical unit of work that accesses and possibly
modifies the contents of a database. (i.e. Read and write the data of database)
Atomicity- Either the entire transaction takes place at once or doesn’t happen at
all.
Consistency-This means that integrity constraints must be
maintained so that the database is consistent before and after the transaction
Isolation-Transactions occur independently without interference (Inspite of
parallel use scheduled way).
Durability- This property ensures that once the transaction has
completed execution, the updates and modifications to the database are stored
in and written to disk and they persist even if a system failure occurs. (stores
in non-volatile memory)
5. What are global and local variables?
A variable is like a box that stores values in a given memory location
Global Variables- The variable whose scope is declared even outside the function or block.
Local Variables- The variable whose scope is declared only inside the function or block.
6. What are constructors, classes, and packages?
Constructors are a special class functions which automatically initiate objects of the class and which have neither an input argument nor a return type.
Classes are entities that collects objects and determine its behavior.
Packages are collection of classes or are similar to various folders on our computer.
7.
What is Normalization? its types?
Technique
to remove or reduce the redundancy (i.e. row & column-based duplicity) of
data from the table
·
First
Normal Form (1 NF)
·
Second
Normal Form (2 NF)
·
Third
Normal Form (3 NF)
·
Fourth
Normal Form (4 NF)
·
Fifth
Normal Form (5 NF)
· Sixth Normal Form (6 NF)
Read more...
--- !!! Happy Reading !!!---
Please do leave your comment below in the comment section
Your feedback is always welcome.
© punchTank
Comments
Post a Comment