Wednesday, 11 February 2015

Most Frequently Asked Data Warehousing Interview Questions and Answers (Page 6)

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?

59. Can a Table space hold objects from different Schemes?

60. Can a View based on another View?
More Questions & Answers :-

No comments:

Post a Comment