Can you tell any two advantages of stored procedures?

592

Which three commands cause a transaction to end?

595

What is database server and how it works?

552

What is database bounce?

587

what is data access layer?

1975

What are the disadvantages of views in a database?

542

If the master device is full, how do I make the master database bigger?

522

what is the role of auditor in auditing data oriented applications?

1925

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

948

What is the Lock Based Protocol used for?

639

how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

1585

How to do Stored procedure testing? Who does this testing (Developer or tester)?

1383

When should you not use firebase?

607

Explain inner and outer joins with examples.

710

What are the types of indexes that are present inside a database?

634