DATAbase

Free

DBMS (E)

DBMS. .

Lessons

What is an integrity constant? – Minakshi Salve

What is an extent? – Minakshi Salve

What are the different types of segments? Explain each in detail. – Minakshi Salve

What are the types of synonyms? Explain each in detail. – Minakshi Salve

What are the referential actions supported by foreign key integrity constant? – Minakshi Salve

What is the use of control file? – Minakshi Salve

What is partial backup and full backup? – Minakshi Salve

What is Oracle table? – Minakshi Salve

What is system table space and when is it created? – Minakshi Salve

Explain the relationship between database table space and data file? – Minakshi Salve

What is SCHEMA and what are the SCHEMA objects? – Minakshi Salve

What is table space? – Minakshi Salve

What are the components of logical database structure of Oracle database? – Minakshi Salve

What is Oracle view? – Minakshi Salve

What is Oracle? – Minakshi Salve

What are the components of physical database structure of Oracle database? – Minakshi Salve

Are there any tools which are used for data warehousing? – Akash Ahuja

Some real life industry examples of data warehouses. – Akash Ahuja

What are the other related fields and technologies that work in integration to a data warehouse? -Akash Ahuja

Which technical skills students should be familiar with to make a career in data warehousing? – Akash Ahuja

Which are the functional skills students should be familiar with to make a carer in data warehousing? – Akash Ahuja

Which Indian and international companies are providing opportunities to make a career in data warehousing? – Akash Ahuja

What is the salary range for a fresher having a career in data warehousing? – Akash Ahuja

What is data warehouse?Why is it needed?And what are its benefits? – Akash Ahuja

What is the high level view of the design process of data warehouse? – Akash Ahuja

Any suggestions or guidance to fresher in database. – Madhu Vyas

What are the advantages of using SQL? – Madhu Vyas

Can SQL servers linked to other servers like oracle? – Madhu Vyas

What is the scope for a database fresher? – Madhu Vyas

How SQL is better than other databases? – Madhu Vyas

What are the advantages of using stored procedures? – Madhu Vyas

What is not null constraint? – Madhu Vyas

What is SQL server agent? – Madhu Vyas

What are the authentication modes in SQL server and how can it be changed? – Madhu Vyas

What is SQL profiler? – Madhu Vyas

What is the difference between delete and truncate commands? – Madhu Vyas

What is the difference between a local and a global temporary table? – Madhu Vyas

What is the difference between a having clause and a where clause? – Madhu Vyas

What is the difference between a primary key and a unique key? – Madhu Vyas

What are the different types of collation sensitivity? – Madhu Vyas

What is the difference between clustered and non-clustered index? – Madhu Vyas

What are the various methods that are used to find performance bottleneck? – Harshit Shah

What are the advantages of Storage Area Network? – Harshit Shah

What is SAN(Storage Area Network)? – Harshit Shah

Will you please explain open SQL v/s native SQL? – Soumyakumar Purwar