Explore topic-wise InterviewSolutions in .

This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.

1.	__________ is a subject-oriented, integrated, time-variant, nonvolatile collection of data in support of management decisions.
Answer» __________ is a subject oriented, integrated, time variant, NONVOLATILE collection of data in support of management decisions. Choose the CORRECT option from below list (1)Data Mining (2)Data Warehousing (3)WEB Mining (4)Text Mining Answer:-(2)Data Warehousing

2.	What is the data format u prefer for informatica server.
Answer» What is the data format u PREFER for INFORMATICA server. Choose the correct option from below list (1)DECIMAL (2)UNICODE (3)ASCII (4)BINARY Answer:-(3)ASCII Note:- POSSIBLE values are ASCII and UNICODE. The default data movement mode is ASCII, which passes 7-bit ASCII character data.

3.	What defines the structure of the data held in operational databases and used by operational applications ?
Answer» What DEFINES the structure of the data HELD in operational databases and used by operational APPLICATIONS ? Choose the correct option from below LIST (1)User-level metadata (2)Data warehouse metadata (3)Operational metadata (4)Data mining metadata Answer:-(3)Operational metadata

4.	__________describes the data contained in the data warehouse.
Answer» __________describes the data contained in the data warehouse. Choose the CORRECT option from below list (1)RELATIONAL data (2)OPERATIONAL data (3)Metadata (4)INFORMATIONAL data Answer:-(3)Metadata

5.	The data is stored, retrieved & updated in ____________.
Answer» The data is stored, retrieved and updated in ____________. CHOOSE the correct option from below LIST (1)OLAP (2)OLTP (3)SMTP (4)FTP ANSWER:-(2)OLTP

6.	The important aspect of the data warehouse environment is that data found within the data warehouse is___________.
Answer» The important aspect of the DATA warehouse environment is that data FOUND WITHIN the data warehouse is___________. Choose the CORRECT option from below list (1)subject-oriented (2)time-variant (3)INTEGRATED (4)All of the above Answer:-(4)All of the above

7.	________________ is the specialized data warehouse database.
Answer» ________________ is the specialized DATA warehouse database. Choose the correct OPTION from below list (1)Oracle (2)DBZ (3)Informix (4)Redbrick Answer:-(4)Redbrick

8.	IF max no of sessions are 20 then what is the minimum shared memory size
Answer» IF max no of SESSIONS are 20 then what is the MINIMUM SHARED memory size Choose the correct OPTION from below list (1)2000000 (2)1000000 (3)4000000 (4)3000000 Answer:-(3)4000000 Note:- We have at least 2000000 BYTES reserved in LMSharedMem. By default 2000000 bytes for 10 session for 20 we have 4000000bytes

9.	__________ is the heart of the warehouse.
Answer» __________ is the HEART of the warehouse. Choose the correct option from below list (1)Data mining database servers (2)Data warehouse database servers (3)Data mart database servers (4)RELATIONAL data base servers Answer:-(2)Data warehouse database servers

10.	____________predicts future trends & behaviors, allowing business managers to make proactive, knowledge-driven decisions.
Answer» ____________predicts future trends and BEHAVIORS, allowing business managers to make proactive, knowledge driven decisions. Choose the CORRECT option from below list (1)Data WAREHOUSE. (2)Data MINING (3)Datamarts (4)Metadata Answer:-(2)Data mining

11.	HOW MANY TYPES OF DATA EXTRACTION ARE THERE
Answer» HOW MANY TYPES OF DATA EXTRACTION ARE THERE Choose the correct OPTION from below list (1)1 (2)2 (3)3 (4)4 Answer:-(2)2 Note:- There are TWO kinds of LOGICAL extraction these are (1)Full Extraction and (2)Incremental extraction

12.	What type of tool is Informatica?
Answer» What type of tool is INFORMATICA? Choose the CORRECT option from below list (1)ETL (2)OLTP (3)OLAP (4)Data Modeling Answer:-(1)ETL

13.	An informatica variable contains
Answer» An INFORMATICA variable contains Choose the correct OPTION from below list (1)startvalue/end value (2)START value/persistent value (3)start value/current value (4)start value/dynamic value Answer:-(3)start value/current value

14.	Which of the following applied on warehouse?
Answer» Which of the FOLLOWING applied on WAREHOUSE? Choose the correct option from below list (1)write only (2)read only (3)both a & b (4)none of these Answer:-(2)read only

15.	Data can be store , retrive and updated in_______
Answer» DATA can be store , retrive and updated in_______ Choose the CORRECT OPTION from below list (1)SMTOP (2)OLTP (3)FTP (4)OLAP Answer:-(2)OLTP