Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
What are the Advantages of PL/SQL?
- Correct Answer
- - Because of the block nature, multiple statements are processed at once thereby improving performance - PL/SQL handles exceptions on catching which, action can be taken - PL/SQL is highly portable as it works with all procedural languages and is highly secured because of privileges
- 1. Write SQL Query to display current date? Discuss
- 2. Which is more effective while calling the functions?
Options- A. call by value
- B. call by reference
- C. call by pointer
- D. none Discuss
- 3. Which of the following is not the member of class?
Options- A. Virtual function
- B. Static function
- C. Friend function
- D. Const function Discuss
- 4. Which of the following gives the memory address of the first element in array?
Options- A. array[0];
- B. array[1];
- C. array(2);
- D. array; Discuss
- 5. Write an SQL Query to check whether date passed to Query is date of given format or not. Discuss
- 6. What is the scope resolution operator? Discuss
- 7. What are the support tickets given in SAP fico module? please give some examples. Discuss
- 8. Which of the following attribute can hold the JavaScript version?
Options- A. script
- B. version
- C. language
- D. none of the above Discuss
- 9. What is recovery/error testing? Discuss
- 10. Which design patterns benefit from the multiple inheritance?
Options- A. Adapter and observer pattern
- B. Code pattern
- C. Glue pattern
- D. None of these Discuss
More questions
Correct Answer: The built in function called GetDate() returns the time stamp
Correct Answer: call by reference
Explanation:
In the call by reference, it will just copy the address of the variable to access it, so it will reduce the memory in accessing it.
Correct Answer: Friend function
Correct Answer: array;
Correct Answer: SQL has IsDate() function which is used to check passed value is date or not of specified format ,it returns 1(true) or 0(false) accordingly SELECT ISDATE('1/08/13') AS "MM/DD/YY"; It will return 0 because passed date is not in correct format
Correct Answer: Scope resolution operator allows a program to reference an identifier in the global scope that is hidden by another identifier with the same name in the local scope
Correct Answer: Support tickets are basically the problems that arise in day to day usage of SAP So any sap fico consultant who is resolving the day to day production issues is actually supporting the tickets
Correct Answer: language
Explanation:
Language attribute contains the javascript versions.
Correct Answer: Recovery/error testing is testing how well a system recovers from crashes, hardware failures, or other catastrophic problems
Correct Answer: Adapter and observer pattern
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.