I have a database with 5 millions records, i have Person table having 5 million records and its have 13 columns. Forename and surname column is heavily populated as compared to other columns. My question is it appropriate to separate forename and surname column and make separate tables for it and reference it with id in person_detail table. What are the advantages and disadvantages in separating these...

prakash

• Mar 9th, 2019

Advantage: Size of the table will decrease and so the query performance will be improved.
Disadvantage: Join query will be required to get surname and full name of person.

Asiimwe

• Jan 2nd, 2016

Its not good to separate them.

Answer Question  Select Best Answer

How to get nth record from index by table?

vadivelraju

• Feb 17th, 2019

We can get like collection(n).column [Ex. emp(3).empno]

Answer Question  Select Best 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

What is the difference between MS SQL Server and SQL Server? Are both same are not?

Mayank Sanghvi

• Mar 21st, 2018

Both are same. MS SQL Server means Microsoft SQL Server. SQL Server is the database developed by Microsoft. Because of this it is also known as MS SQL Server.

justin

• Dec 26th, 2017

Both are same

Answer Question  Select Best Answer

At what trigger timing does mutating trigger error occur?
Is it before/after or both? And is it for row level/statement level OR both?

Achyuth

• Oct 30th, 2017

When trying update a record by using a trigger which is already in use

anjali

• Mar 8th, 2017

The mutating error comes when we use a column in our trigger and we want to update it at the same time. It occurs in row level triggers irrespective of the fact whether it is before or after trigger.

Answer Question  Select Best Answer

Can Physical and Logical loss in Database can recovered from Full backup?

Consider the following tables which give details of customers, trucks and packets booked by
customers, which are carried by trucks and write SQL commands to do the following:
Tables:
CUSTOMER(c_no, c_name, c_address)
TRUCK(t_no, driver_name)
PACKET(p_no, c_no, t_no, date_of_booking, weight, destination)

Queries:
i) Destinations which have received more...

ZAHID

• Nov 20th, 2016

Three Components:
1. Data Structure (Data organization in the form of table with row and table)
2. Data Manipulation (Operation perform(using SQL) on data stored in relation)
3. Data Integrity (Maintain data stored in relation for long time)

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Jul 6th, 2012

The Relational model contains 3 components 1)set of relations and set of domains ( data structure).
2)Integrity rules (data integrity) and
3)The operation that can be operate on the data (data manipulation).

Answer Question  Select Best Answer

How to Clone MySQL Database?

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

Display 6th & 9th records only from the table using ROWNUM & MINUS & UNION ?

ramesh

• May 26th, 2016

Using Rownum we cannot display records but using set operation like minus and union then we can display the records if conditions is satisfied.

Answer Question  Select Best Answer

1. How can I store data in Redis server database, with key as dynamic changing value and values as list of structure?

2. Where the data store in the system?

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

Why is RowSet implementation is beneficial over ResultSet?

sunil

• Mar 14th, 2016

How to execute the JDBC example using JdbcRowSet instead of Using ResultSet?

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

viswanath

• Aug 23rd, 2015

I did not found any "demobld.sql" in my system, then how can import default tables ?

smartrameshdwh

• Apr 4th, 2007

step1) Search "demobld.sql" file in the directory where you installed Oracle using Search option. step2) Make a copy of it (demobld.sql) in C drive or D drive step3)Execute "@c:demobld....

Answer Question  Select Best Answer

Consider an organization by which you are familiar. If the organization is using file processing system then what are the problems organization will face?Explain with suitable examples.

sunil

• Aug 3rd, 2015

1-Redundancy
2-Consistency
3-Security
4-Automaticity of update
and many more

Answer Question  Select Best Answer

Which of following collection (nested tables, associative arrays, varrays) is better performance wise?

Sharath

• Jun 8th, 2015

Select ename ,count(ename) from emp group by ename

ashbittu

 Profile Answers by ashbittu Questions by ashbittu

• Jun 1st, 2015

Code
 

Answer Question  Select Best Answer