Technical Interview Questions
There are following types of keys: Primary key: The Primary key is an attribute in a table that can uniquely identify each record in a table. It is compulsory for every table. Candidate key: The Candidate key is an attribute or set of an attribute which can uniquely identify a tuple. The Primary key can … Read more
Shared lock: Shared lock is required for reading a data item. In the shared lock, many transactions may hold a lock on the same data item. When more than one transaction is allowed to read the data items then that is known as the shared lock. Exclusive lock: When any transaction is about to perform … Read more
You have to use Structured Query Language (SQL) to communicate with the RDBMS. Using queries of SQL, we can give the input to the database and then after processing of the queries database will provide us the required output. To communicate with an RDBMS (Relational Database Management System), you typically use Structured Query Language (SQL). … Read more
The 3-Tier architecture contains another layer between the client and server. Introduction of 3-tier architecture is for the ease of the users as it provides the GUI, which, make the system secure and much more accessible. In this architecture, the application on the client-end interacts with an application on the server which further communicates with … Read more
The 2-Tier architecture is the same as basic client-server. In the two-tier architecture, applications on the client end can directly communicate with the database at the server side. In a 2-tier architecture for a database management system (DBMS), there are two layers or tiers involved: the client tier and the server tier. Client Tier: This … Read more