Answered: Which of the following is an object…

Engineering

Computer Science

Which of the following is an object privilege?a. DELETE ANYb. INSERT ANYc. UPDATE ANYd. REFERENCES

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter7: User Creation And Management

Section: Chapter Questions

Problem 20MC

See similar textbooks

Related questions

Q: User.login = (credentials, result) { sql.query( *SELECT * ,(select…

A: Required : flowchart

Q: Which of the following can be used to determine whether an index exists?a. DESCRIBE indexname;b. the…

A: An index’s information can be obtained from the views called “USER_INDEXES” and “USER_IND_COLUMNS”.…

Q: 1. Create a new directory, name it ITGN256 under your directory 2. Create a file, name them…

A: The Linux/Unix operating system supports commands to create, edit, delete, update, change file…

Q: QUESTION 8 Which of the following is used to declare a record? O A. %TYPE B. Both %TYPE and %ROWID…

A: In PL/SQL , %TYPE is a attribute that is used in giving data type of the given variable and column…

Q: Which of the following database encryption techniques makes it difficult to perform database…

A: EXPLANATION: The disadvantage of Application-level Encryption is that it has a limited effect on the…

Q: CREATE TABLE Users( C_Id varchar(8) NOT NULL, astName Varchar(255) NOT NULL, FirstName varchar(255)…

A: Below are the scripts we use for creating the table and procedure and functions create table…

Q: Each tablespace in an Oracle database consists of one or more files called a. Files b. name space c.…

A: The answer is as follows:-

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: 9:\ Deleted text in Word goes to Trash a True O b. False O 10:\ The following option is used to add…

A: We need to choose the right option for the given statements- The questions are as- (1) deleted…

Q: Which of the keys below are not supported by a relational database? a. Foreign keys b.…

A: As per our guidelines we are supposed to answer only one question so please post the other question…

Q: Sign Up It's quick and easy.

A: Develop a Windows Form Application for User Registration (Complete code with database connectivity…

Q: Write the MongoDB Shell code to remove the Title Key Value from the 3rd document from

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: • Create Mini-Password Manager Write a simple code to create hash value of passwords Store the…

A: Please upvote. I am providing you the correct answer below. Please Please. SHA3-512 is…

Q: Create new class DbConn containing a connection string and a single function to insert, update and…

A: Create new class DbConn containing a connection string and a single function to insert,update and…

Q: Apex, Salesforce In which you have two types of Record type on Position Object one is for Technical…

A: Given: In which you have two types of Record type on Position Object one is for Technical and one is…

Q: QUESTION 23 Match the command with its meaning v cat A. creates a new empty file v tail B. shows the…

A: As per bartleby policy i can attend only first part so please check the answer in 2 step

Q: Which of the following attribute of file provide access control information.

A: The question is about file access mechanism and how it depends on its attribute.

Q: 207. File and database contains the frequency component. a. True b. False c. May be d. Can't say

A: Given that, File and database contains the frequency component. a. True b. False c. May be d. Can't…

Q: Which of the following statement is not correct? O none. O A Database is a collection of related…

A: Data Base Management System: DBMS is a software that is used to store, manage and use database…

Q: Which of the following is not a type of folder view? a. tiles b. cascades c. thumbnails d. details

A: Given: Which of the following is not a type of folder view? a. tiles b. cascades c.…

Q: sql oracle commands: 1) Create a backup of your control file using the following methods: a) An…

A: Control file: A control file, which is a tiny binary file that records the physical structure of an…

Q: Create an alias the root user will use for the copy command that includes the recursive, archive,…

A: Lets see the solution.

Q: Implement, using Java, an application to add user's transactions into a binary file, and then…

A: The answer provided below has been developed in a clear step by step manner.

Q: The command . Is used to delete -1 * .selected objects Trim O Move O Erase O Extend O

A: Ans: The command that is used to delete selected objects is: c) Erase

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: Which of the following has no partial dependencies but can contain transitivedependencies?a.…

A: Second Normal Form (2NF): A Relational table R will be in 2NF: First Normal form There must not…

Q: Complete the Python program below to display the name of the most recently added dataset and collect…

A: Assuming you have installed the cssselect and request library using pip install, moving further I…

Q: In order for the public to view Web pages on the Internet that have been placed in a directory, the…

A: Language is one of the most widely used programming language which has been used to create different…

Q: Insert data in file customer.sal into table customer

A: Hey, since there are multiple questions posted, we will answer first question. If you want any…

Q: Write the MongoDB Shell code to completely delete the entire database, including all collections and…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: True or False? An alias is used to execute tasks such as inserting, deleting, and updating records.

A: Ans: False that An alias is used to execute tasks such as Inserting, deleting and updating records.

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: In Windows, the md command must be used to create a folder. a. True b. False

A: In the Windows Operating System, The command named md is used in the command prompt that is also…

Q: How many account records will be created by the given code? Account a = new Account(Name='Acme');…

A: According to the given code: We have to find out how many account records will created by mention…

Q: How many account records will be created by the given code? Account a = new Account(Name='Acme');…

A: The answer is

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: Create a schema user which will be application owner (in other words schema owner)

A: Create a schema user which will be the application owner (in other words schema owner) User name:…

Q: Two separate commands, DELETE and TRUNCATE, exist

A: Commands given DELETE TRUNCATE

Q: Create a new user account with readWrite permission for your database

A: To Create a new user to database, you need to specify username, password and and their role This…

Q: When a user issues the following distinct commands, what happens and why? Assume all files exist. $…

A: The, answer has given below:

Q: Which of a database file’s properties determines if and when the file is copied to the project’s…

A: Copy to output directory: It is a property of the files that which defines the file will be copied…

Q: Which of the following is an organized collection of related information stored in a computer file?…

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 following command is used for inserting records a) INSERT b) ADD c) Both of the above d) None of…

A: SQL commands are of two types namely, DDL (Data Definition Language) and DML (Data Manipulation…

Q: Which keyword is used to query data from the database? O EXTRACT EXPORT SELECT O INSERT INTO QUERY…

A: In order to read data or query a data from database we need to used SELECT statement. Syntax of…

Q: Please define the primary difference between User rights and File level rights.

A: User rights can be defined as the access given to the user for reading and performing any task. It…

Q: Create a file named view_roster.php that allows the user to view the current roster including all…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

Which of the following is an object privilege?
a. DELETE ANY
b. INSERT ANY
c. UPDATE ANY
d. REFERENCES

Expert Solution

Step 1

Which of the following is an object privilege-

a. DELETE ANY
b. INSERT ANY
c. UPDATE ANY
d. REFERENCES

The correct option is d.

That is ,

REFERENCES IS AN OBJECT PRIVILAGE .

Step by step

Solved in 2 steps

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 object can be used to speed up searches and quires in general? a) Index b) Unique c) Check d) Cascade
a. Load a database applicationb. Create a database labelled as MOVIE_LIBRARY in the created folder with the following fields:MovieID, Movie Name, Date Released, Movie Category, Quantity Delivered (table in image attachment) c. Save the table as tblMovies.d. Fill tblMovies with the given data as shown in 2 (b).e. Create a form for the records and name it frmMoviesf. Query the table to look out for movies released in the year 2014 and name it as qryMovies
Create an application which can access a database. Create a database with an application user, user specific for your application to use, and 1 table of a couple of fields properly indexed. Grant permissions for the user to access the table. (submit .SQL file) Create a simple application, language of your choice, (BE languages only, no JS or Node) which can do the following operations: (submit source code file): Connect using the application user created above. Insert into the table, and select from the table using a WHERE clause, where all fields are parameterized. Display results of the select. Use a simple web server API interface for data input and output, which can be accessed via local browser or curl.
SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the MongoDB Shell code to completely delete the entire database, including all collections and documents
Create a user Nurse. (Screenshot 1) Create a database Hospital. (Screenshot 2) Grant Nurse privileges to Hospital (Screenshot 3) As Nurse, create a table Patients with the following structure. (Screenshot 4) PatientID RoomNo FirstName LastName Admission Temperature double(10,2) int(8) Primary Key and not null int(4) varchar(14) not null varchar(14) not null datetime Use a command to describe the table(Screenshot 5) Insert 2 patients randomly to the above table(Screenshot 6) Show all the contents of the table. (Screenshot 7)
#Fill in comments to spec. import sqlite3from contextlib import closing from Objects import Player, Lineup conn = None def connect():global connif not conn:DB_FILE = "player_db.sqlite"conn = sqlite3.connect(DB_FILE)conn.row_factory = sqlite3.Row def close():if conn:conn.close() def get_players():return None #remove this line when code is added.# SQL statement to select all 7 fields for all players # Use a with statement to execute the query # Create a lineup object# use a loop to populate the lineup object with player objects# return the lineup object def get_player(playerID):return None #remove this line when code is added.# SQL statement to select all 7 fields for a player # Use a with statement to execute the query & return a player object if the player exists def add_player(player):return None #remove this line when code is added.# SQL statement to insert 6 fields for a player added to the table # Use a with statement to execute the query def delete_player(player):return None…
import sqlite3 from sqlite3 import Error # Creates connection to sqlite in-memory database def create_connection(): """ Create a connection to in-memory database :return: Connection object """ try: conn = sqlite3.connect(":memory:") return conn except Error as e: print(e) # YOUR CODE HERE # Use sqlite3.connect(":memory:") to create connection object return conn # query to create the table table_sql = """ CREATE TABLE Horses ( id integer PRIMARY KEY NOT NULL, name text, breed text, height real, birthday text ); """ # query to insert data into the table ins_sql = """INSERT INTO Horses VALUES(1,'Babe','Quarter Horse',15.3,'2015-02-10'); """ # query to fetch all data from the table fetch_sql = """SELECT * FROM Horses;""" # creating db connection conn = create_connection() # fetching a cursor from the connection c = conn.cursor() # executing statement to create table c.execute(table_sql) # executing statement to…
SBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID DBS311 Your Name use the following statement to Write the MongoDB Shell code to remove the Title Key Value from the 3rd document from
• Open MS Access, Select New, type Northwind on the search field, double click to open Northwind database.After the Northwind 2007 is launched as shown below please answer the following questions in a note pad file named “surname student#”.Note: the Northwind sample database in an older version of MS Access is very different from the one in MS Access 2007 or higher )1. What version of Access do you have?2. Choose Object Type on the Navigation Pane. Please list different objects or components available in the Northwind Database window? Describe FIVE of them in simple words in terms of their functions.33. In the TABLE Shippers, how many shippers are there? Please list them.4. In TABLE Orders, which field (i.e. column heading) is identical to the field inTABLE Employees? and TABLE Customers? and TABLE Shippers? Please list all you can find in the format like Orders.field1=Employees.field2, and etc. (Clarification: consider the identity in terms of contents but not the field names, and…
Using C# in Visual Studio. Create a form with a button that will insert new data into a Database, the read button will retrieve data from a database and display it on the form, Update button will update a record into the database using the full name, and the delete button will delete a record into the database using full name.
Create a role and a user. Assign the role to the user. The role must be assignwith all the admin privileges. Then drop the user and the role both in ADBMS
What are the four basic types of operations for a database application? a. Insert, Select, Update, and Delete b. Insert, Update, Delete, and Create c. Insert, Update, Delete, and Render d. Insert, Select, Update, and Render If stringa="Good Morning", what is the value of stringa[1:5]? a. "Good " b. "ood " c. "Good" d. "ood M" The instance that “a survey respondent in service occupation (x) is less likely to report income ” is an example of __________ . a. Missing completely at random. b. Missing at random. c. Missing not at random. d. None of the above.