Create the following SQL script (Save as w6_firstname_lastname. sql) .Create a simple Database with the following1) Create insert script (10 inserts)2) Create update script (10 updates)3) Create the following insertsa) Select all recordsb) Select all records sorted descending , ascendingc) Select all records with condition (where)d) Count all recordse) Count all record with conditionCreate 3 delete scripts

Auser is given read permission to a file stored on an ntfs-formatted volume. the file is then copied to a folder on the same ntfs-formatted volume where the user has been given full control permission for that folder. when the user logs on to the computer holding the file and accesses its new location via a drive letter, what is the user's effective permission to the file? a. read b. full control c. no access d. modify e. none of the above