Which of the following is not a function of a Warehouse?

Correct Answer: Data warehouse - It is a decision support database system for the purpose of organizational needs -It is non volatile, integrated and time variant collection of data Operational Data Stage - It is an integrated collection of information -It can contain 90 days of information at maximum -ODS supports dynamic data

Correct Answer: -Daily loading is known as incremental load -When data is selected from source, selected records are loaded between timestamp of last load and the current time -The parameter that are passed to perform are last loaded date and current date -The first parameter is the stored last run date is read through job parameters -The second parameter is the current date

Correct Answer: Sequence numbers can be generated in Datastage using certain routines They are -KeyMgtGetNextVal -KeyMgtGetNextValConn

Correct Answer: Datastage has two components -Client Components ? Designer, Director, Manager and Administrator -Server Components ? Server, Repository and Plug-ins

Correct Answer: - A tool for designing Extraction, Transformation and Loading - An ideal tool for data integration projects system migrations - Importing, extracting and creating metadata are within these jobs - Data stage allows scheduling, monitoring and running the jobs - Allows to administer the development and execution in a single environment

Correct Answer: ActiveX DLL: It is an in process server It runs within the application time ActiveX Exe: It is an out of process server MS-Excel is an activex exe when u call the excel from the vb application u can in the task manager an excel exe will run, whereas for dll u can't see like that

Correct Answer: Yes

Correct Answer: Yes, internally PHP will cast everything to the integer type, so numbers 10 and 11 will be compared

Correct Answer: we can always fetch from one database and rewrite to another Here is a nice solution of it$db1 = mysql_connect("host","user","pwd") mysql_select_db("db1", $db1); $res1 = mysql_query("query",$db1);$db2 = mysql_connect("host","user","pwd") mysql_select_db("db2", $db2); $res2 = mysql_query("query",$db2);At this point you can only fetch records from you previous ResultSet, ie $res1 â?? But you cannot execute new query in $db1, even if you supply the link as because the link was overwritten by the new dbso at this point the following script will fail $res3 = mysql_query("query",$db1); //this will failSo how to solve that? take a look below $db1 = mysql_connect("host","user","pwd") mysql_select_db("db1", $db1); $res1 = mysql_query("query",$db1); $db2 = mysql_connect("host","user","pwd", true) mysql_select_db("db2", $db2); $res2 = mysql_query("query",$db2); So mysql_connect has another optional boolean parameter which indicates whether a link will be created or not, as we connect to the $db2 with this optional parameter set to 'true', so both link will remain live Now the following query will execute successfully $res3 = mysql_query("query",$db1);

Correct Answer: HTTP headers can be used in PHP by redirection which is written as: The headers can be added to HTTP response in PHP using the header() The response headers are sent before any actual response being sent The HTTP headers have to be sent before taking the output of any data The statement above gets included at the top of the script