How do you ensure database security?
• Use role-based access control (RBAC).
• Encrypt sensitive data using AES or SHA.
• Prevent SQL injection by using prepared statements.
• Enable audit logs for tracking changes.
• Use firewalls and secure authentication methods.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between SQL, DDL, and DML?
7 Answers BeBo Technologies, Wipro,
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
if you ctreate table identity
How to retrieve data from an explicit cursor?
Select the Nth lowest value from a table?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
Explain mutating triggers.
What is truncate oracle?
What is the quickest way to fetch the data from a table?
which institute and which faculty is providing best training for oracle sql, plsql in hyderabad
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi