Amit

• Aug 28th, 2016

Adding 2 cents 1) DELETE is DML command because it does not change data dictionary (Every command which changes data dictionary tables is called DDL command ) TRUNCATE is DDL command is changes stor...

Ashakant Kendre

• May 9th, 2016

1>TRUNCATE is a DDL command whereas DELETE is a DML command. 2>TRUNCATE is much faster than DELETE. Reason: When you type DELETE. All the data get copied into the Rollback Tablespace first, then del...

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

letsconverse  

 Profile Answers by letsconverse Questions by letsconverse

• Member Since Sep-2009 | Sep 21st, 2009

---

This one is better I guess:

query:

SELECT ((count(DECODE(to_char(hire_date,'YYYY'), 1995, 'c1')) )+(count(DECODE(to_char(hire_date,'YYYY'), 1996, 'c2')))+(count(DECODE(to_char(hire_date,'YYYY'), 1997, 'c3')))+(count(DECODE(to_char(hire_date,'YYYY'), 1998, 'c4')))) as TOTAL,
count(DECODE(to_char(hire_date,'YYYY'), 1995, 'c1')) "1995",
count(DECODE(to_char(hire_date,'YYYY'), 1996, 'c2')) "1996",
count(DECODE(to_char(hire_date,'YYYY'), 1997, 'c3')) "1997",
count(DECODE(to_char(hire_date,'YYYY'), 1998, 'c4')) "1998"
FROM employees;

Results for the above query is like:

     TOTAL       1995       1996       1997       1998
  ----------   ----------   ----------  ----------  ----------
          65             4            10           28           23

Revert if you have a question. I'll try.
NOTE: You may want to change the spl characters and the years based on your requiremnet.

Thanks

serine

• Aug 26th, 2016

Why did we use c1?

ashwini

• Jun 22nd, 2015

Can anybody tell me how to get the count of the test cases that was run by a person?

Improve Answer

Read Best Answer

Editorial / Best Answer

Answered by: Karanjeet

• Nov 22nd, 2005

---

Following are the tier types in a client server application:

a. 1 tier application:All the processing is done on one machines and number of clients are attached to this machine (mainframe applications)

b. 2 tier application: Clients and data base on different machines.Clients are thick clients i.e.? processing is done at client side.Application layer is on Clients.

c. 3 tier application.Client are partially thick.Apart from that there are two more layers application layer and database layer.

d. 4 tier application: Some clients may be totally non thick clients some clients may be partially thick and further there are 3 layers web layer, application layer and database layer.

Avinash

• Nov 24th, 2012

If I am not wrong

Class variables are variables which we create inside a class.

&

Class member are the variables & function declared inside class.

Manoj Kumar Chagantipati

• Jun 12th, 2012

In Two tier there will be Presentation layer and Data base layer
Where as in Three tire there will be Presentation layer,Data access layer and Data base layer

Improve Answer

Lavanish Chaudhary

• Jul 1st, 2018

A database view is a searchable object in a database that is defined by a query. Types of view in a database management system:
A. Simple view
B. Complex view
C. Readable view
D. Force view
E. Materialized view
F. Inline view

Nagaraj

• Nov 13th, 2017

1. Updatable view & Non-updatable view
2. Simple view & complex view
3. Read only view
4. Force view
5. Meterialized view
6. Inline View

Answer Question  Select Best Answer

amir ali

• Nov 23rd, 2015

Views are dependent on data tables.

PADMINI M

• Nov 16th, 2015

Correct answer is it depends.
Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table
Only we can update a view in one base table.

Answer Question  Select Best Answer

raman sharma

• Mar 2nd, 2012

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

Pradeep

• Feb 21st, 2012

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

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: NITIN TOMER

• Sep 6th, 2011

---

sql is a structured query language........and t-sql is implementing on sql server........and t-sql having some more queries than sql .

kandriga murali

• Dec 8th, 2013

1) .SQL is non-procedural language since it deals with what data to be extracted.Whereas T-SQL is procedure language since it deals with what data to be executed and how it should be displayed.
2) . SQL can executed only single command whereas T-SQL can executed multiple statement at time.

Syed Umar Abbas

• Mar 28th, 2012

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

Improve Answer

nishant s mevawala

• Aug 30th, 2011

1.Information Rule
2.Guaranteed Access Rule
3.Systematic Treatment of Nulls Rule
4.Active On-line catalog based on the relational model
5.Comprehensive Data Sub-language Rule

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 14th, 2007

Dr. E.F. Codd, an IBM researcher, first developed the relational data model in 1970. In 1985, Dr. Codd published a list of 12 rules that concisely define an ideal relational database, which have provi...

Answer Question  Select Best Answer

qptopm

 Profile Answers by qptopm Questions by qptopm

• Apr 26th, 2016

Database Server - Database server will have your one or more database hosted such as Oracle, Sql Server, MySql, etc.A database is a collection of information that is organized so that it can easily b...

HARENDRA KUMAR SINGH

• Mar 5th, 2016

Database is used to store collection of data.
Database Server is collection of database stored separately.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

opbang  

 Profile Answers by opbang Questions by opbang

• Member Since Mar-2006 | Sep 24th, 2006

---

Transaction Database Vs DataWarehouse Database-

1. Transaction Database is Relational Database with the normalised table, whereas DataWarehouse is with denormalised Table.

2. Transaction Database is highly volatile... Designed to maintain transaction of the business Where DataWarehouse is non volatile.. with periodic updates.

3. Transaction Database is OLTP...   Datawarehouse ... is for analysis... 

4. Transaction Database is functional data...  DataWarehouse database Data is subject oriented.

kalai

• Jan 29th, 2014

Transactional database means current data in database.
data warehouse means historical data.i.e old data that are flushed out.

sreenivas

• Nov 25th, 2012

A transactional database is defined for day-to-day operations like insert, delete and update and in a Datawarehouse databases (OLAP databases) are designed for Analytical purpose. So they require historical data for analysis. These databases are huge databases to store historical data.

Improve Answer

shibraj

 Profile Answers by shibraj Questions by shibraj

• Jan 23rd, 2008

find the rowid for the duplicate row and delete the max id no keeping the min id. thats it...

sowmya

• Nov 19th, 2007

Here != works bcoz the inner query returns only a single value. NOT IN is used when multiples values are returned by the inner query

Answer Question  Select Best Answer

Oracle stores information regarding the names of all the constraints on which table? A)USER_CONSTRAINTS B)DUAL C)USER D)None of these

Naresh kumar

• Oct 3rd, 2012

Constraints divided into 3 types those are: 1. domain integrity constraints:- not null,check 2. entity integrity constraints:- unique,Primary key 3. referential integrity constraints:- foreign key In...

sukrampal

 Profile Answers by sukrampal Questions by sukrampal

• Jul 12th, 2012

User-constraints and all_constraints

Answer Question  Select Best Answer

rubin2008

 Profile Answers by rubin2008 Questions by rubin2008

• Jan 31st, 2010

Yes it is possible to have primary key and foreign key in one table.For e.g the schema for table category is as followsCategory_id: int primary keyCategory_title: varchar(30)parent_id: int(3)In the ab...

Shri

• Nov 1st, 2007

Dear Vivek,If I understand your question well, you mean to say that "is there any possibility to have both?primary & foreign keys in the same table".Well, the answer is No. The foreign key (by defini...

Answer Question  Select Best Answer

anbum

• Oct 17th, 2007

Normalization is based on the functional dependency and primary key.1NF- Attribute should be atomic value and there must be?no composite attribute, no multivalued attribute and no relation with in re...

bhawesh

• Jul 19th, 2007

First NF---Attribute should be atomic an no redundant row. (functional dependancy) Second Normal Form : All Non-Key attribute should be fully functionally dependent on primary?key.(removes partial dependancy)Third normal Form : There is no transitivity dependency between attribute.

Answer Question  Select Best Answer

NOTNULL

 Profile Answers by NOTNULL Questions by NOTNULL

• May 18th, 2009

View is mainly created to provide security for the data and data definitions. Mainly used to retrieve the data in a secure manner.View cannot use space in the physical memory means virtually it w...

rajakumar_na

 Profile Answers by rajakumar_na Questions by rajakumar_na

• Nov 14th, 2007

One more point isView is a Schema ObjectJoin is not a schema object

Answer Question  Select Best Answer

anand.managoli

 Profile Answers by anand.managoli Questions by anand.managoli

• Nov 26th, 2010

As per my knowledge we cannot use Regular Expressions with drop stmt. You can delete multiple tables in a single statement by separating them with a comma.Ex:mysql> show tables;+--------------...

dinu_26

 Profile Answers by dinu_26 Questions by dinu_26

• Nov 12th, 2008

There is no way to delete multiple table at a time.You can just drop a single table at a time.Syntax: table name.

Answer Question  Select Best Answer

Login Screen

User ID -> textbox
Password -> textbox

Sign in-> button..

Can someone send me how to write test cases for the above requirement?

Haritha

• Apr 17th, 2015

Enter Blank details and click on sign in button
Enter valid user name,Invalid password and click on sign in button
Enter Invalid user name ,valid password and click on sign in button
Enter Both invalid details and click on sign in button
Enter Valid User name& password click on sign in button

msrajeshreddy

• Oct 25th, 2013

1.enter valid username and valid password.
2.enter invalid username and valid password.
3.enter invalid username and invalid password.
4.enter blank username and valid password.
5.enter valid username and blank password.
6.enter blank username and blank password.

Answer Question  Select Best Answer

vibha_kant

 Profile Answers by vibha_kant Questions by vibha_kant

• May 15th, 2007

Clustered Index:A clustered index reorders the way data is physically stored in a disc. Thats why there can be only one clustered index on the table. The leaf nodes of the index contains the data page...

vibha_kant

 Profile Answers by vibha_kant Questions by vibha_kant

• May 14th, 2007

Mutating triggers :I am not aware of mutating triggers in SQL Server.  Per my knowledge only MySQL and Oracle throws this error. Coming back to the point, mutating trigger occurs when the table w...

Answer Question  Select Best Answer

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Mar 18th, 2010

Simultaneously modification of same table by two or more users cause Oracle server to go into hang state, to avoid such a state first user who used dml statement should issue commit or rollback comand...

Gajanan

• Jul 13th, 2007

There are two ways of changing the rows in particular table.One to delete the rowSecond to modify/Change the data of row in table.In every case we opt for exclusive locks So when one user has exclusiv...

Answer Question  Select Best Answer

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

Value set is a collection of values.A value set associated with a report parameters, provides a list of values to the end user to accept one of the values as report parameter value.

kashyap_aseem

 Profile Answers by kashyap_aseem Questions by kashyap_aseem

• Feb 14th, 2008

I thhink it is simmilar to enum in c/c++

Answer Question  Select Best Answer