Discussion
Home ‣ Interview ‣ Technology See What Others Are Saying!
- Question
What is the difference between mysql_connect and mysql_pconnect?
- Correct Answer
- There is a decent page in the php manual on the subject, in short mysql_pconnect() makes a persevering association with the database which implies a SQL join that don't close when the execution of your script closes mysql_connect()provides just for the database new association while utilizing mysql_pconnect , the capacity would first attempt to locate a (relentless) connection that is as of now open with the same host, username and password On the off chance that one is found, an identifier for it will be returned as opposed to opening another connection the connection with the SQL server won't be terminated when the execution of the script ends Rather, the link will stay open for future use
- 1. Who is responsible for maintaining the Accounts receivable in an organization? Discuss
- 2. What are the components of DataStage? Discuss
- 3. Credit sales are recorded as
Options- A. Accounts Receivable
- B. Accounts Payable
- C. Both A & B
- D. None of the above Discuss
- 4. Which of the following is not a function of a Warehouse?
Options- A. Ensuring Profit
- B. Stabilisation in price
- C. Risk-bearing
- D. Storage Discuss
- 5. What is commercial Bank ? Discuss
- 6. Which of the following are elements of SQL?
Options- A. base-table-identifier ::= user-defined-name
- B. base-table-name ::= base-table-identifier
- C. boolean-primary ::= comparison-predicate
- D. All the above Discuss
- 7. State Bank of India recently launched 'SBI Exclusif'. It is a ____ product.
Options- A. Wealth Management
- B. Loan
- C. Mutual Fund
- D. Insurance Discuss
- 8. Describe the use of PL/SQL table? Discuss
- 9. Name any three PL/SQL exceptions? Discuss
- 10. Which one of the following sorts rows in SQL?
Options- A. ORDER BY
- B. GROUP BY
- C. SORT BY
- D. ALIGN BY Discuss
More questions
Correct Answer: Accountants in big organization there will be a department to maintain AR department
Correct Answer: Datastage has two components -Client Components ? Designer, Director, Manager and Administrator -Server Components ? Server, Repository and Plug-ins
Correct Answer: Accounts Receivable
Correct Answer: Ensuring Profit
Correct Answer: A commercial bank is a type of bank that provides services such as accepting deposits, making business loans, and offering basic investment products Commercial bank can also refer to a bank or a division of a bank that mostly deals with deposits and loans from corporations or large businesses, as opposed to individual members of the public
Correct Answer: All the above
Correct Answer: Wealth Management
Correct Answer: PL/SQL tables are scalar arrays that can be referenced by a binary digit They can be used to store values for later queries and calculations
Correct Answer: Too_many_rows No_Data_Found Zero_Error
Correct Answer: ORDER BY
Comments
There are no comments.More in Interview:
Programming
Copyright ©CuriousTab. All rights reserved.