1. Describe two different ways to secure database during the process of database
ID: 3838558 • Letter: 1
Question
1. Describe two different ways to secure database during the process of database administration.
2. The super global variables $_POST and $_GET are commonly used for HTML input data collection, what is the main difference between them? What is the main measure commonly used to guarantee the security of PHP forms?
3. Load and run the database everest, and then create a view (the name of view is bookView) of the table books, allowing the book unit price between $25.00 and $35.00 being included. You need to test it in MySQL Workbench, and submit the screenshot(s) to show your test is successful, i.e, the query result of the view.
You also need to submit the sql script of your MySQL code.
Explanation / Answer
1. During process the DBA secure the Database in
a.Protect from physical damage ( ie ) accidental or natural dissater for that make a backup in different ways.
b. Controlling user access to the database by assigning different roles to the user for ex read or write etc...
2. Difference between GET and Post method
Appends data into the URL
3.
Creat VIEW bookView As
Select * from books where unit price Between 25 And 35 ;
GET POSTAppends data into the URL
Appends data with in HTTP Request The length is limited to 3000 characters There is no limitation Less secure than POST bcoz data sent is part of the URL safer than GET can be bookmared cannot be bookmark can be cached cannot be cached Useful non sensitive data Its useful sensitive data like passwordRelated Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.