1- Create a new user on either VM (on 60 or 65). Use the following requirements: Create a user called victor Set victor's password to Victor123! (case sensitive). Update victor's PATH variable so that, at each login, it is set to include the bin and data directories used by PostgreSQL. Include the steps you took, including what user you became to do the work, below.

1- Create a new user on either VM (on 60 or 65). Use the following requirements: Create a user called victor Set victor's password to Victor123! (case sensitive). Update victor's PATH variable so that, at each login, it is set to include the bin and data directories used by PostgreSQL. Include the steps you took, including what user you became to do the work, below.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter5: Data Manipulation And Transaction Control

Section: Chapter Questions

Problem 8MC

See similar textbooks

Similar questions

• Exercise 1: Please create a script that print “Hello, your name.” • Exercise 2: Please create a directory call user_bin, and add it to PATH. Then mv script of Exercise 1 to user_bin. Then run it from your root directory.• Exercise 3: Add a new command call ‘l’ which will perform exact same as ‘ls -a’. • Exercise 4: Create a function call sortFile, which will sort all filenames of current directory.• Exercise 5: Please make your own page using shell script, print following as your page. <html><head><title>My System Information</title></head><body><h1>My System Information</h1></body></html> Exercise 6: Could you add one variable in the example, name the variable as greeting, which displays “Hello, my name is xxx xxx” in the body using variable greeting.• Exercise 7: Could you add one variable in the example, name the variable as FILE_LIST, which displays the filenames of current working directory
السؤال What does the following command do? $ chmod ugo -w file01.txt الاجابات remove write permission to users, group and others remove write permission to the user (owner) only assign write permission to group and others assign write permission to users, group and others
write the code for the following triggers in MySQL following the style shown in the text. A: When adding a customer, add the customer balance multiplied by the sales rep's commission rate to the commission for the corresponding sales rep. B: When updating a customer, add the difference between the new balance and the old balance multiplied by the sales rep's commission rate to the commission for the corresponding sales rep. C: When deleting a customer, subtract the balance multiplied by the sales rep's commission rate from the commission for the corresponding sales rep. CREATE TABLE REP(REP_NUM CHAR(2) PRIMARY KEY,LAST_NAME CHAR(15),FIRST_NAME CHAR(15),STREET CHAR(15),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),COMMISSION DECIMAL(7,2),RATE DECIMAL(3,2) );CREATE TABLE CUSTOMER(CUSTOMER_NUM CHAR(3) PRIMARY KEY,CUSTOMER_NAME CHAR(35) NOT NULL,STREET CHAR(20),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),BALANCE DECIMAL(8,2),CREDIT_LIMIT DECIMAL(8,2),REP_NUM CHAR(2) );INSERT INTO…
Write commands to accomplish the following (use the manual or info pages if necessary):a. Create a user with a login name of bsmith, a UID of 733, a GECOS field entry of“accounting manager,” and a password of Gxj234b. Delete the user jdoe, but leave the home directory intactc. Change the properties of the existing user wjones such that the user has a newcomment field of “shipping” and an account expiry of March 23, 2022d. Lock the account of wjenkinse. Change the password of bsmith to We34Rtf. Change the properties of the existing user tbanks such that the user is a member ofthe managers group and has a login name of artbanksg. Create a user with the same UID and primary group as root and a login name ofwjonesh. Create a new user with a login name of jdoe who has a password of he789R andno home directoryi. Change the primary group of the user wsmith to rootj. Add the users tbanks and jdoe to the group acctg
Look the following code and describe the difference between commands "read -p" and "read -s -p" #!/bin/bash# Register 5 users for user_no in {1..5}; do echo "Registering user no: $user_no" read -p "Enter username: " username read -s -p "Enter password: " password # do something here to check password validity # do something here to register the userecho -e "\n" done
In this function, you will try to make a transfer between two user accounts. bank is a dictionary where the key is the username and the value is the user's account balance. log_in is a dictionary where the key is the username and the value is the user's log-in status. amount is the amount to be transferred between user accounts (userA and userB). amount is always positive. What you will do: - Deduct the given amount from userA and add it to userB, which makes a transfer. - You should consider some following cases: - userA must be in the bank and his/her log-in status in log_in must be True. - userB must be in log_in, regardless of log-in status. userB can be absent in the bank. - No user can have a negative amount in their account. He/she must have a positive or zero balance. Return True if a transfer is made. For example: - Calling transfer(bank, log_in, "BrandonK", "Jack", 100) will return False - Calling transfer(bank, log_in,…
''' In this function, you will try to make a transfer between two user accounts. bank is a dictionary where the key is the username and the value is the user's account balance. log_in is a dictionary where the key is the username and the value is the user's log-in status. amount is the amount to be transferred between user accounts (userA and userB). amount is always positive. What you will do: - Deduct the given amount from userA and add it to userB, which makes a transfer. - You should consider some following cases: - userA must be in the bank and his/her log-in status in log_in must be True. - userB must be in log_in, regardless of log-in status. userB can be absent in the bank. - No user can have a negative amount in their account. He/she must have a positive or zero balance. Return True if a transfer is made. For example: - Calling transfer(bank, log_in, "BrandonK", "Jack", 100) will return False - Calling transfer(bank, log_in,…
Which of the following statements represents a correctly structured transaction? BEGINUPDATE trackset media_type_id = 1where album_id = 3DELETE FROM playlistWHERE playlist_id = 1INSERT INTO genre (genre_id, name)VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock')COMMIT UPDATE trackset media_type_id = 1where album_id = 3;DELETE FROM playlistWHERE playlist_id = 1;INSERT INTO genre (genre_id, name)VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');COMMIT; BEGIN;UPDATE trackset media_type_id = 1where album_id = 3;DELETE FROM playlistWHERE playlist_id = 1;INSERT INTO genre (genre_id, name)VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');COMMIT; BEGIN;COMMIT;UPDATE trackset media_type_id = 1where album_id = 3;DELETE FROM playlistWHERE playlist_id = 1;INSERT INTO genre (genre_id, name)VALUES (30, 'Funk' ),(31,'Classical'),(32,'Pop Rock');
Suppose x = 6 and y = 11. What will be stored in d after the following sequence of commands is executed: push 2, push x, sub, push y, push 9, add, add, pop d. Group of answer choices 14 15 16 17 None of the above
Which of the following statements represents a correctly structured transaction? a.) BEGIN;COMMIT;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11; b.) BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip');UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11;COMMIT; c.) BEGINinsert into album (artist_id, title, album_id) values (1, 'My Album', 348)insert into playlist (playlist_id, name) values (30, 'New Age Playlist'), (31, 'Oldies'), (32, 'Road Trip')UPDATE albumSET title = 'Out of Exile [Disc 1]'WHERE album_id = 11COMMIT d.) BEGIN;insert into album (artist_id, title, album_id) values (1, 'My Album', 348);insert…
Complete the .htaccess code below to tell Apache Web Server what document to display for visitors who fail to authenticate with HTTP error 401. ___ ____ /pmwd/chapter16/secret/rejection.html Use SQL to give the SELECT privilege on all auth database tables to the MySQL user webauth. Modify the following code to perform simple password verification in PHP. if (___($password, $hash)) { // OK passwords match }
Exercise 1: Please create a script that print “Hello, your name.” • Exercise 2: Please create a directory call user_bin, and add it to PATH. Then mv script of Exercise 1 to user_bin. Then run it from your root directory.• Exercise 3: Add a new command call ‘l’ which will perform exact same as ‘ls -a’. • Exercise 4: Create a function call sortFile, which will sort all filenames of current directory. Exercise 6: Could you add one variable in the example, name the variable as greeting, which displays “Hello, my name is xxx xxx” in the body using variable greeting