Differentiate between Controlled and Uncontrolled Redundancy

Azad

• Feb 13th, 2015

Drawback of traditional file system

supriya_pict

 Profile Answers by supriya_pict Questions by supriya_pict

• Sep 11th, 2009

Redundancy is Direct if a value is a copy of another Indirect if the value can be derived from other values: Simplifies retrieval but complicates update Conversely integration makes...

Answer Question  Select Best Answer

What is the relationship between a company's databases and its data warehouse?

Hirru

• Feb 10th, 2012

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...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 20th, 2011

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...

Answer Question  Select Best Answer

Explain a one-to-many strong vs. one-to-many weak entity relationship.

raman sharma

• Mar 2nd, 2012

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

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Nov 20th, 2011

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.

Answer Question  Select Best Answer

Been given this question from my son and he has told me that he googled the question but got no satisfactory answer. Would much appreciate an answer.

raman sharma

• Mar 2nd, 2012

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

suji

 Profile Answers by suji Questions by suji

• Dec 21st, 2011

DBMS - Its 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...

Answer Question  Select Best Answer

Hi, I recently tried to get employee names and their dept names without a join condition, this query, although succeeds, I can't figure how it works. please help.

select ename,(select dname from dept where deptno=e.deptno) from emp e;

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Apr 11th, 2012

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...

Blaster_Ayub_Khan

• Apr 10th, 2012

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...

Answer Question  Select Best Answer

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

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

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 19th, 2006

These answers are probably all correct---if it's SQLServer or Sybase. I don't think the DBMS was identified and for sure the data dictionary/relational catalog/system tables are not standard in naming...

rajnarayan yadav

• Jan 16th, 2006

 Index information in : user_indexes Constraint information in : user_constraints and user_cons_columns

Answer Question  Select Best Answer

prathap

• Sep 14th, 2012

We can use "parallel" in the query and in the 11g we can use dynamic sampling.

dhivyavetriselvan

• Jul 26th, 2007

Select query can be made faster by using indexes.

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

Fakruddin Khan

• Mar 30th, 2012

The top-down method starts from the general and moves to the specific. Basically, you start with a general idea of what is needed for the system and then ask the end-users what data they need to stor...

chaitra murthy

 Profile Answers by chaitra murthy Questions by chaitra murthy

• Jan 28th, 2009

Top Down approach:- ER ModellingBottom Up approach:- Normalization

Answer Question  Select Best Answer

Kanhucharan

 Profile Answers by Kanhucharan Questions by Kanhucharan

• Apr 25th, 2008

 As trigger is implicitly fired, u can not commit.Here I m giving one example. Let u wrote a trigger for inserting 100 records,And after that U wrote commit,When the particular event occures...

harsh

• Jan 20th, 2007

since we know -triggers r statement that r executed automatically as sideeffect of data modification.therefore we can not write commit in triggers..but we write for data security.. 

Answer Question  Select Best Answer

sreyaskvmce&it

 Profile Answers by sreyaskvmce&it Questions by sreyaskvmce&it

• Mar 31st, 2006

Drop user username cascade

ram vara prasad

• Mar 9th, 2006

tx paa,         drop user user_name cascade;           This command really works..

Answer Question  Select Best Answer

23kannan

 Profile Answers by 23kannan Questions by 23kannan

• May 8th, 2008

Null interfaces act as markers. They just tell the compiler that the objects of this class need to be treated differently. some marker interfaces are : Serializable, Remote, Cloneable

srinivas

• Dec 24th, 2006

Null interface is a markup interface

Answer Question  Select Best Answer

sachin s

• Apr 4th, 2007

IS Predicate comes with Create and AS comes with replace.

shailendra_suman

• Feb 19th, 2007

I don't think there is any difference.  I tried both and worked fineSQL> SQL> create procedure testing is  2    3  begin  4    5  dbms_output.put...

Answer Question  Select Best Answer

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

soumya.rampalli

 Profile Answers by soumya.rampalli Questions by soumya.rampalli

• Mar 7th, 2007

Yes what is the different between schema and database

yuvaraj.r

• Mar 6th, 2007

Normally we are reteriving datas internally in the tables of the database

Answer Question  Select Best Answer

How does Export/Import feature differ from that of SQL Loader?

Sheraz Baig

• Nov 21st, 2013

Totally different Export/Import are oracle utilities to export data in the oracle format and to import the data which is been exported so the format will be the oracle one. While SQL Loader is the u...

dhiren21

 Profile Answers by dhiren21 Questions by dhiren21

• Sep 20th, 2009

Its Different.. For Export we are exporing the data from the Database to a Dump file..i.e EXP from user datafile buffer rows compress etcfor Imprting we are importing the data from a dump file to a da...

Answer Question  Select Best Answer

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 25th, 2007

In varchar u can store upto 2000 bytesIn varchar2 u can store upto 4000 bytesIn Oracle  even if u declare a variable with varchar it takes varchar2 into consideration and creates that variable with varchar2

yuvarajan2000

 Profile Answers by yuvarajan2000 Questions by yuvarajan2000

• Apr 24th, 2007

Varchar and Varchar2 is different.Varchar and varchar2 store is 2000 char. varchar2 size is automatically reduce. It will take on using char size based.

Answer Question  Select Best Answer