TCS Technical Interview Questions [ Part 2]
Want Previous 5 Questions ? [ Part 1]
Want Previous 5 Questions ? [ Part 2]
11) Explain about Joins, Views, Normalization, Triggers?
The JOIN keyword is used in an SQL statement to query data from two or more tables, based on a relationship between specific columns in these tables.
Tables in a database are often related to each other with keys.
A view is a virtual table. A look contains rows and columns, just like a real table. The fields in a picture are fields from one or more real tables in the database.
You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.
12) List different advantages of DBMS
Improved data sharing.
The list of several advantages of Database Management System:
o Improved data security.
o Better data integration.
o Minimized data inconsistency.
o Improved data access.
o Improved decision making.
o Increased end-user productivity.
13) What is Database Management System?
A DataBase Management System is a software system used for creating and managing databases. DBMS makes it possible for the end-user to build and maintain databases. DBMS provides an interface between the end-user/application and the databases.
====================================================================
14) What is database Schema?
The formal definition of the database schema is a set of formulas (sentences) called integrity constraints imposed on a database.
15) What are the conditional statements?
The conditional statements can alternatively be called a conditional expression also. Conditional comments are the set of rules which were executed if a particular condition is true. It is often referred to as an if-then statement because if the state is true, then the statement is executed.
