Answered: Which of the following commands is used…

Which of the following commands is used to assign a privilege to a role?(refer to the JustLee Books database).a. CREATE ROLEb. CREATE PRIVILEGEc. GRANTd. ALTER PRIVILEGE

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter7: User Creation And Management

Section: Chapter Questions

Problem 9MC

See similar textbooks

Related questions

Q: Oracle Database 18c XE comes with a sample database user named HR. This user owns several database…

A: SQL*PLUS is an batch query tool .It is a command-line user interface, a Windows Graphical User…

Q: Which statement is true regarding external tables? a. The default REJECT LIMIT for external tables…

A: Explanation:- true stаtement regаrding externаl tаbles is: The СREАTE TАBLE АS SELEСT…

Q: ?Which of the following is an example of an update anomaly A new student cannot be assigned to a…

A: Lets see the solution.

Q: in sql If you have not yet used the COMMIT command to store the changes permanently in the…

A: Answer: a. True

Q: In this exercise, you will create tablespaces and change their characteristics. 1. Connect to the…

A: 1. 2. 3.

Q: Which of the following releases a lock currently held by a user on the HOMEWORK10 table?a. A COMMIT…

A: Releasing a lock held by a user on the HOMEWORK10 table: Issuing of COMMIT command as well as…

Q: Which of the following is used to grant all object privileges for an object to a specified user?…

A: Privileges: - It enables a < AuthorizationID > to perform particular action on a specific…

Q: Which of the following SQL command can be used to modify existing data in a database table? a.…

A: UPDATE sql command is used to modify existing data in a database table

Q: The “find” command is running in the background. Write the command that will kill that process.

A: Since you have not mentioned the Operating System. We will be answering this in context of Linux.

Q: Which of the following commands can be used to change a password for a user account? (refer to the…

A: To change a password for a user account, “ALTER USER” command is used. The example for “ALTER USER”…

Q: write a DBA command(s) that checks the database owner of the DBMS database , that exists in the…

A: Question 1- Write a DBA command(s) that checks the database owner of the DBMS database, that exists…

Q: Which of the below items are the application areas of the database?

A: Answer;

Q: sql User_123 has successfully logged on to the database in the past, but today he receives an error…

A: in sql User_123 has successfully logged on to the database in the past, but today he receives an…

Q: Refer to the below exhibit. Which one of the following commands is used to delete the staff…

A: Answer: b. rm -r staff

Q: Which of the following will select the Id and Status fields for records whose Status field contains…

A: The correct answer to this question is option a) SELECT Id, Status FROM Employ WHERE Status = 'F'

Q: Create two different forms of the INSERT command to add a student with a student ID of 65798 and…

A: note, we can only solve three subparts in one question. There are two types of INSERT INTO…

Q: Which of the following is an object privilege? (refer to the JustLee Books database).a. CREATE…

A: object privilege is option (d) UPDATE

Q: Which of the following LINQ statements selects all of the records in the tblStates table?a. Dim…

A: LINQ: LINQ stands for language integrated query which is used in various languages such as C#,…

Q: Which of the below items are the application areas of the database? Answers All of them Finance…

A: A database is a collection of related data which represents some aspect of the real world.

Q: Which of the following creates a new table in a database and also copies the records into the new…

A: Required: Which of the following creates a new table in a database and also copies the records into…

Q: Q7:- Choose the correct statement:- Prints the database_information connection = getDbConnection()…

A: Note: In the question, the numbering given for the statement is wrong. The same number “1” is given…

Q: EMPDET is an external table containing the columns EMPNO and ENAME. Which command would work in…

A: MPDET is an external table containing the columns EMPNO and ENAME. Which command would work in…

Q: z help with the follwong: in sql Oracle issued the following error: user user_123 lacks CREAT

A: plz help with the follwong: in sql Oracle issued the following error: user user_123 lacks CREATE…

Q: • Open MS Access, Select New, type Northwind on the search field, double click to open Northwind…

A: Due to the honor code, I can solve the first 3 questions. Please resubmit the remaining question.

Q: What is the maximum number of records that can be modified with a single UPDATE command?a. 1b. 2c.…

A: UPDATE command: User must use UPDATE command to change the existing data in a table. UPDATE command…

Q: Match each of the following actions according to their designated function used to enforce…

A: database managemnt design function used to enforce Confidentiality , Integrity and Availability.

Q: Which of the following is a valid SQL statement? a.…

A: Valid SQL statement The syntax of Insert statement is INSERT INTO table_name…

Q: 2- write a DBA command to create a differential backup for the database DBMS , in a new folder with…

A: 2- write a DBA command to create a differential backup for the database DBMS , in a new folder with…

Q: Which of the following is/are the primary features of a DBMS? (A) To provide an environment that is…

A: Given: Which of the following is/are the primary features of a DBMS? (A) To provide an environment…

Q: The previous administrator created a table named CONTACTS, which contains outdated data. You want to…

A: DROP TABLE is the answer Because DROP command delete both table and data present in it. Option…

Q: EF Core API will create which table for the following context? In other words, what would be the…

A: Below is the answer with explanation:

Q: For each of the following commands, how many rows are affected (updated, deleted, or inserted)? If…

A: It deletes 1 row from table employee where id is 3.

Q: QUESTION 19 Which of the following statements will NOT result in a NEW transaction being created. O…

A: Changing state of objects is treated as new transaction.

Q: Which SQL Command is used to delete a cable from the database: a) Update 5) Alter =) Drop H) Select

A: Update Command is used to update the value in a table. Alter command is used to change the value in…

Q: 1.Which keyword is used to create a database? 2.The file created by the server to bu

A: 1. CREATE DATABASE is used to to create a database for example CREATE DATABASE Rajnish; Rajnish…

Q: What types of privileges are available in Oracle 12c? Define each type

A: When a database has multiple accesses, then it is important to ensure control of authorized…

Q: Write a cron job that executes the command, sudo mysqldump --all-databases at 11:59 pm on Sunday…

A: You need to use the crontab command to edit/create, install, deinstall or list the cron jobs in…

Q: Write SQL commands for the foilowing: a. Create two different forms of the INSERT command to add a…

A: Create two different forms of the INSERT command to add a student with a student ID of 65798 and…

Q: Match each of the following actions according to their designated function used to enforce…

A: Confidentiality means the encrypted data which kept secret and contains limited access. Integrity…

Q: You have a list of all your contacts details that you would like to store in a database. Your goal…

A: Hi. Triggers are set of statements that runs when a certain event is triggered. A trigger can be…

Q: Database question 2.You created a new user on the database by executing the following command:…

A: Question 2. You created a new user on the database by executing the following command: SQL>…

Q: Which of the following can be used to create a database within PostgreSQL? (Chooseall that apply.)a.…

A: For creating the database in the PostgreSQL will require any kind of Create statement and command…

Q: The Developers team also wants you to ensure that emails are converted to lowercase after an update…

A: We need to create a TRIGGER function which will update the USER_EMAIL to upper case. Hence the…

Q: Which of the following privileges must be granted to a user’s account before the user can connect to…

A: Authorization includes primarily two processes: Permitting only certain users to access, process, or…

Q: 16. Which commands are used to control which users have which privilege over which objects ? a. QUE…

A: please see the next step for solution

Q: Which of the following statements are incorrect regarding SQL injection vulnerabilities? O a. The…

A: SQL injection is a vulnerability that causes data stealing from database.

Q: which key is used Link records of one type with those of another type.

A: Given: which key is used Link records of one type with those of another type.

Q: Which Recordset type allows updating table data through a query? Select an answer: updatetable…

A: The solutions are given in next step with explanation and examples

Q: IN SQL Which of these examples of privileges are CREATE SESSION, CREATE TABLE, CREATE USER? Select…

A: Privilege is a right to execute a particular type of SQL statement. In SQL, Object privileges: It…

Concept explainers

Windows

Windows is an operating system produced by Microsoft Corporation, initially released in the year 1985 and also known as Microsoft Windows. It has been written in JavaScript with visual basics, and C. Windows is the most popular operating system (OS) for personal computers across the globe. Since its inception, there has been a tough competition between Apple and Microsoft, yet one-third of the OS market share has been occupied by Windows. Although in recent years, Android has come up as another considerable competitor for these two organizations, which is leading the smartphone market, yet in desktops and laptops, Windows has the most number of customers.

Question

Which of the following commands is used to assign a privilege to a role?(refer to the JustLee Books database).
a. CREATE ROLE
b. CREATE PRIVILEGE
c. GRANT
d. ALTER PRIVILEGE

Organized collection of structured information, or data, typically stored in a computer system.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Which of the following types of restrictions can be viewed with the DESCRIBE command? NOT NULL FOREIGN KEY UNIQUE CHECK
Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
Which of the following is an object privilege?a. DELETE ANYb. INSERT ANYc. UPDATE ANYd. REFERENCES
Which of the following commands can be used to eliminate the RECEPTIONIST role? (refer to the JustLee Books database).a. DELETE ROLE receptionist;b. DROP receptionist;c. DROP ANY ROLE;d. none of the above
Which of the following will select the Id and Status fields for records whose Status field contains only the letter F? a. SELECT Id, Status FROM tblEmp WHERE Status = 'F' b. SELECT Id, Status FROM tblEmp ORDER BY Status = 'F' c. SELECT Id, Status FROM tblEmp FOR Status = 'F' d. SELECT Id, Status FROM tblEmp SELECT Status = 'F'
In this exercise, you will create tablespaces and change their characteristics.1. Connect to the database as user SYSTEM.2. Create a tablespace (MYTBSP_YourName) in a suitable directory—anydirectory on which the Oracle owner has write permission will do:3. Create a table in the new tablespace, and determine the size of the firstextent:4. Add extents manually, and observe the size of each new extent byrepeatedly executing this command,5. Take the tablespace offline, Try to insert some data in to the table, try todelete data from table, observe the effect, and bring it back online. 6. Drop the tablespace, and use an operating system command to confirmthat the file has indeed gone:
Which of the following statements retrieves data from the Friends database and stores it in the FriendsDataSet?a. Me.FriendsDataSet.Fill(Friends.accdb)b. Me.TblNamesBindingSource.Fill(Me.FriendsDataSet)c. Me.TblNamesBindingNavigator.Fill(Me.FriendsDataSet.tblNames)d. Me.TblNamesTableAdapter.Fill(Me.FriendsDataSet.tblNames)
Which of the following privileges allows a user to truncate tables in a database? (refer to the JustLee Books database).a. DROP ANY TABLEb. TRUNCATE ANY TABLEc. CREATE TABLEd. TRUNC TABLE
Create a view named RESERVATION_CUSTOMER. It consists of the reservation ID, tripID, trip date, customer number, customer last name, customer first name, and phonenumber. Write and execute the command to retrieve the reservation ID, trip ID, trip date, andcustomer last name for every reservation in the RESERVATION_CUSTOMER viewwith a trip date of September 11 , 2016. WHAT AM I MISSING OR HAVE INCORRECT ? SELECT Reservation_ID, Trip_ID, Trip_Date, Last_Name FROM RESERVATION_CUSTOMER WHERE TRIP_DATE = '09-SEP-2016';
Which of the following commands creates a private synonym?a. CREATE PRIVATE SYNONYMb. CREATE NONPUBLIC SYNONYMc. CREATE SYNONYMd. CREATE PUBLIC SYNONYM
Which part of the database application is responsible for application user authentication in the database role-based model? Choose the following options: a. Application b. Database
Which of the following releases a lock currently held by a user on the HOMEWORK10 table?a. A COMMIT command is issued.b. A DDL command is issued to end a transaction.c. The user exits the system.d. A ROLLBACK command is issued.e. all of the abovef. none of the above