Database Interview Questions

Truncate is much faster than delete. all same ans like above

Drop : Deletes both Table Structure and the Data
Truncate : Deletes only Data and it performs automatic Commit
Delete : Deletes only Data and Doesn't performs automatic Commit.

hi, when someone asked for test cases then test cases must be fulfill all the conditions, 1. Enter Valid User name and valid password And Click On Submit. 2. Enter Valid User name and valid passwor...

Expected result Actual result Launch the application Application should be launched Ente...

Youre using a Sub-query -- [(select dname from dept where deptno = e.deptno)] -- to get around using a join clause like -- [FROM EMP E INNER JOIN DEPT D ON (D.DEPTNO = E.DEPTNO)] -- however, you are n...

SQL coins the term query as the name for its commands. Basically, all SQL code is written in the form of a query statement and then executed against a database. All SQL queries perform some type of da...

There are 3 rules to enforce table level integrity. 1.Foreign key value can be modified only if we want to match the corresponding primary key value. 2.We cannot delete records either from parent or c...

The Exception section of the PL/SQL block contains the functions for error handling.

Three activities involved in requirement gathering are
1.Eliciting requirement
2.Analyzing requirement
3.Recording requirement

The trigger which can be fired on DDL operator is DDL trigger.

Microsoft SQL Server have some more additions to Database Standard Query Language (SQL) is called T-SQL

SQL is the Structured Query Language. it is developed by IBM.
TSQL is the Transact SQL. it is implementation of the SQL server. it is developed by Microsoft.
TSQL is used in writing the procedure and some advanced concepts are written by this.

Class variables are the variables declared with the static modifier as a field of a class. These variables are created and initialized during the class loading itself and only one copy of such variabl...

Two- tier (client-server) Users access the database from their personal computer(client) over a network and the database sits on a separate computer (server) whereas Three-tier(Client-Application ser...

view is called a temporarily table when we want to create the copy of any table as requirement column then we use the view

syntax-------------
create view (view name) as select (* or column name) from (table name);

A view is a virtual table, which provides access to a subset of columns from one or more tables. It is a query stored as an object in the database, which does not have its own data.

there are two type of join

1)inner join
inner join have a three type
I)equi join
II)nonequi join
III)self join

and outer join have a two type

I)right outer join
II)left outer join

and one is a ANSI join that a advance

Join,
Inner join,
Outer join,
Left join,
Right join,
Full join

database is called when one computer are not connected with each other and only data are stored in one computer that called database and when computer are connected with each other or particular server so we can access the data every computer its called database server

Database is a repository of data and Server is the mediator between client and database to insert, modify and to Retrieve data against a query.

there are different type of constraints

1) primary key
2)unique key
3)foreign key
4)check constraints

User_constraints

entity relationship when attribute are connected to entity there are different different type attribute are available weak entity and strong entity when we are using key that called strong entity and when key are not connected that called weak entity

Weak Entity generally don't possess key attributes of their own whereas a Strong Entity possess its own key attributes that are independent of other entities. Weak entity is usually existence-dependent on another entity type and does not have enough attributes to form its own primary key.

DBMS is a when data are not stored in table and RDBMS is used to all data are stored in table and distributed database when more than one table are connected with each other so its is called a distributed database

DBMS - It’s a software package combination of various computer programs which can be used to control, administer, maintain and use of the database. RDBMS - Its a database management system (DBMS) b...

normal are of five type 1) 1 normal form 2) 2 normal form 3) 3 normal form 4) 4 normal form 5) 5 normal form all normal are created to connected a table with each other and data are retrieve very ea...

Database is a structured collection of relational data. Database is used to store the relational, network or hierarchical data. It contains some sort of data and it is being used by the organization...

In simple words, a database is used to store information, and a data warehouse is used to query and analyse the stored data in several ways. Data warehouse helps business management to take important...

Data Abstraction means suppression of information / details of data organization and storage. Data Abstraction gives importance to mainly essential aspects in order to help better understanding of th...