Interview Questions

Q:

What are the Referential actions supported by FOREIGN KEY integrity constraint?

Answer

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.

Report Error

View answer Workspace Report Error Discuss

0 1449
Q:

Each of the following is a sleep disorder except

A) REM rebound B) Narcolepsy
C) Night terrors D) Insomnia
 
Answer & Explanation Answer: A) REM rebound

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Medical Interview

1 1448
Q:

What are the Softwares which can be useful in manufacturing unit?

Answer



In manufacturing group, software that can be useful for Material Management and Manufacturing ERP. Some of the organizations that provide the manufacturing software solution are Oracle ERP system, sap etc.


 

Report Error

View answer Workspace Report Error Discuss

Subject: Manufacturing

0 1447
Q:

What are the components of SAP scripts?

Answer

SAP scripts is a word processing tool of SAP which has the following components: Standard text. It is like a standard normal documents. Layout sets. - Layout set consists of the following components: Windows and pages, Paragraph formats, Character formats. Creating forms in the R/3 system. Every layout set consists of Header, paragraph, and character string. ABAP/4 program.

Report Error

View answer Workspace Report Error Discuss

Subject: SAP

0 1444
Q:

How would you explain the concept of business intelligence? What is its importance?

Answer

Business intelligence is a concept that covers development of warehousing and business intelligence applications and databases that assist in diagnosing and repairing user issues as well as performance ones. This is an extremely important set of procedures as it engenders quality end-user products and helps company representatives in understanding core issues and resolving them.

Report Error

View answer Workspace Report Error Discuss

0 1442
Q:

Explain an ORA-01555?

Answer

You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

Report Error

View answer Workspace Report Error Discuss

0 1436
Q:

How would you handle conditional formats in BI?

Answer

There are lot of ways are there to use the conditional formatting, most of the Process flow maintains more attention in the loops, alias and contextCheers.

Report Error

View answer Workspace Report Error Discuss

0 1433
Q:

How do you resize a data file?

Answer

ALTER DATABASE DATAFILE <datafile_name> RESIZE <new_size>; 

Report Error

View answer Workspace Report Error Discuss

0 1433