Below are some important Data Warehouse interview questions which are asked in most MNC company interviews for beginners or professionals.
51. Explain the relationship among Database, Table space and Data file?
Each databases logically divided into one or more table spaces one or more data files are explicitly created for each table space.
52. What is an Index Segment?
Each Index has an Index segment that stores all of its data.
53. What is a Redo Log?
The set of Redo Log files YSDATE, UID, USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
54. What are the types of Synonyms?
There are two types of Synonyms Private and Public
55. What are the Referential actions supported by FOREIGN KEY integrity constraint?
Update And Delete Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted
all associated dependent rows are deleted.
56. Do you View contain Data?
Views do not contain or store data.
57. What is the use of Control File?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to
proceed. It is also used in database recovery.
58. Can objects of the same Schema reside in different table spaces?
Yes
59. Can a Table space hold objects from different Schemes?
Yes
60. Can a View based on another View?
Yes
51. Explain the relationship among Database, Table space and Data file?
Each databases logically divided into one or more table spaces one or more data files are explicitly created for each table space.
52. What is an Index Segment?
Each Index has an Index segment that stores all of its data.
53. What is a Redo Log?
The set of Redo Log files YSDATE, UID, USER or USERENV SQL functions, or the pseudo columns LEVEL or ROWNUM.
54. What are the types of Synonyms?
There are two types of Synonyms Private and Public
55. What are the Referential actions supported by FOREIGN KEY integrity constraint?
Update And Delete Restrict - A referential integrity rule that disallows the update or deletion of referenced data. DELETE Cascade - When a referenced row is deleted
all associated dependent rows are deleted.
56. Do you View contain Data?
Views do not contain or store data.
57. What is the use of Control File?
When an instance of an ORACLE database is started, its control file is used to identify the database and redo log files that must be opened for database operation to
proceed. It is also used in database recovery.
58. Can objects of the same Schema reside in different table spaces?
Yes
59. Can a Table space hold objects from different Schemes?
Yes
60. Can a View based on another View?
Yes
No comments:
Post a Comment