Interview Questions

Q:

Describe the foreign key columns in fact table and dimension table.

Answer

The primary keys of entity tables are the foreign keys of dimension tables.


The Primary keys of fact dimensional table are the foreign keys of fact tablels.

Report Error

View answer Workspace Report Error Discuss

1 3158
Q:

How does the PeopleSoft database interact with the Oracle?

Answer

A Peoplesoft database is expression which point out a database containing Peoplesoft objects. For Oracle and only for Oracle, Peoplesoft consists in 3 schemas namely:


- PS (PSDBOWNER table owner),


- PEOPLE (for connection checking) and


- SYSADM (by default), the last one contains all the objects/data.


One of the database objects is connected with single Oracle schema, and all processes that connect to the database use the standard PSFT login procedure. PSFT login is used because to refer to the collection of tables in the administrative schema within an Oracle database. Every process that makes a 2-tier connection to the database identifies itself with a PSFT user or operator ID. Hence the interaction goes.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 3157
Q:

Where SQL server user names and passwords are stored in SQL server?

Answer

They get stored in System Catalog Views sys.server_principals and sys.sql_logins.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL

0 3156
Q:

What is purpose of VSAM?

Answer

VSAM acts as an interface between Application program & Operating System.

Report Error

View answer Workspace Report Error Discuss

0 3154
Q:

Which JavaScript objects are not accessible to web worker?

Answer

Following JavaScript objects are not accessible to web worker: 


- The window object


- The document object


- The parent object

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology

0 3153
Q:

What is a REPL in context of Node.js?

Answer

Read - Reads users input, parse the input into JavaScript data-structure and stores in memory


Eval - Evaluates the data structure


Print - Prints the result


Loop - Loops the above command until user press ctrl-c twice

Report Error

View answer Workspace Report Error Discuss

Subject: Web Technology
Job Role: Software Architect

0 3151
Q:

Which Bank has tied up with Samsung Pay through which cardholders will be able to pay using smartphones at merchant establishments  ?

A) HDFC Bank B) Yes Bank
C) Kotak Mahindra Bank D) Punjab National Bank
 
Answer & Explanation Answer: C) Kotak Mahindra Bank

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Marketing and Sales
Exam Prep: Bank Exams , CAT
Job Role: Bank Clerk , Bank PO

6 3150
Q:

Why do capital expenditures increase assets (PP&E), while other cash outflows, like paying salary, taxes, etc., do not create any asset, and instead instantly create an expense on the income statement that reduces equity via retained earnings ?

Answer

Capital expenditures are capitalized because of the timing of their estimated benefits – the lemonade stand will benefit the firm for many years. The employees’ work, on the other hand, benefits the period in which the wages are generated only and should be expensed then. This is what differentiates an asset from an expense.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Accounts Receivable Exam Prep: Bank Exams , CAT
Job Role: Bank Clerk , Bank PO

4 3149