What is a parameter query?



What is a parameter query?..

Answer / Alka

A parameterized query is a SQL query that uses placeholders for values that will be supplied at runtime. Parameterized queries are used to prevent SQL injection attacks by ensuring that user-supplied input is sanitized and escaped before being inserted into the query. Parameterized queries also improve performance because they can reuse execution plans across multiple queries with different parameters.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

In a Distributed Database System Can we execute two queries simultaneously ? Justify ?

3 Answers  


Its possible to add more than one primary key for the table

4 Answers  


What is a pdo connection?

1 Answers  


When the mutating error will comes? and how it will be resolved?

2 Answers  


Do foreign keys improve performance?

1 Answers  


how to insert the records in particular position

1 Answers  


What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,


How is pl sql different from sql?

1 Answers  


describe transaction-safe table types in mysql : sql dba

1 Answers  


How subquery works in sql?

1 Answers  


What is prepared statement in sql?

1 Answers  


Can we call procedure in select statement?

1 Answers  


Categories