What are the different types of keys in database?
Define sub-query.
What is a system concept?
Explain ddl interpreter?
What is foreign key in dbms?
Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
Is it good to save image in database?
What is relational database ? Give me an example !
What is 2nf and 3nf?
Define dbms.
What is etl process in data warehousing? What are the different stages in 'data warehousing'?
What will be the maximum size of an extent of a segment if the tablepac's default storage values are specified as (initial 8K next 16k minextent 4 pctincrease 100).Explain.
What is the use case where we can use stretch database?