Which command is used to create a file that stores the database connection information? O User DSN O System DSN O File DSN
Added by Jose Ignacio S.
Close
Step 1
Step 1: A File DSN is a file that stores the database connection information. Show more…
Show all steps
Your feedback will help us improve your experience
Madhur L and 98 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Which of the following commands should be used to create a database named "student"? CREATE ?I student CREATE DATABASE student DATABASE /student DATABASE student
Madhur L.
Akash M.
Task 1 (3 Marks) (1) Connect to MySQL as a user root either through command line interface mysql or graphical user interface MySQL Workbench and create a new database with a name the same as <prefix of your UOW email account>. (2) While connected as a user root use SQL script A3create.sql to create the relational tables in a database created in the previous step. A script A3create.sql creates the relational tables that can be used to store information about doctors, patients, outpatients, inpatients, drugs and prescriptions. Execute a script A3load.sql to load data into the relational tables that were created by A3create.sql. (Note: You can use a script A3drop.sql to drop the relational tables. Do not drop the relational tables now!) No report is expected from the implementation of the steps listed above. Implement SQL script that performs the following actions as a user root. (1) Create two users with the following user names: <prefix of your UOW email account>_1 <prefix of your UOW email account>_2 For example, if your UOW email prefix is abc123 then the names of users are abc123_1 and abc123_2. Set the password to be the same as the username. For example, if the username is abc123_1, the password should be set to abc123_1. (2) Next, the script grants to the user <prefix of your UOW email account>_1 to create relational tables, to drop relational tables, and to read and write relational tables in a database with the same name as <prefix of your UOW email account>. The privilege must be granted such that a user <prefix of your UOW email account>_1 is NOT allowed to grant the same privilege to another user. (3) Next, the script grants to the user <prefix of your UOW email account>_2 to read data from the relational tables PATIENT, DOCTOR located in a database with the same name as <prefix of your UOW email account>. The privileges must be granted such that the new user is able to grant all privileges listed above to the other users. (4) Next, the script sets the following values of resource limits to a user <prefix of your UOW email account>_1: total number of queries an account owner can issue per hour must be set to 88, total number of updates an account owner can issue per hour must be set to 100, and total number of times an account can connect to the server per hour must be 5. (5) Next, the script expires the password of the account <prefix of your UOW email account>_2. (6) Finally, the script lists the privileges granted to all new users, <prefix of your UOW email account>_1, <prefix of your UOW email account>_2, the values of resource limits set in step (4) and a status of <prefix of your UOW email account>_2 set in a step (5). To do so your script must access appropriate relational tables in a database mysql. Do not list information not related to the actions performed above!
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD