A database administrator wants to grant access to an application that will be reading and writing data to a database. The database is shared by other applications also used by the finance department Which of the following account types Is MOST appropriate for this purpose? A-Service B-Shared C-eneric D-Admin

A database administrator wants to grant access to an application that will be reading and writing data to a database. The database is shared by other applications also used by the finance department Which of the following account types Is MOST appropriate for this purpose? A-Service B-Shared C-eneric D-Admin

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter7: User Creation And Management

Section: Chapter Questions

Problem 3MC

See similar textbooks

Similar questions

Which of the following data dictionary objects should be used to view information about the constraints in a database? USER_TABLES USER_RULES USER_COLUMNS USER_CONSTRAINTS None of the above objects should be used.
Assign privileges to the new account that allow connecting to the database, creating new tables, and altering an existing table.
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 database defination languagee(DDL) statemenent is used to change the name of a table in database? a) Rename b) Select c) Alter d) Drop
You have been hired at Selianord Group (Pty)Ltd as a Junior database developer where you are going to build a desktop application called LusuFlix. This application will be used at a video rental store. We need different levels of permissions for different users in the database. The store manager should be able to add/update/delete the list of movies. They will be in charge of setting the stock for each movie as well as the daily rental rate. Cashiers should have a read-only view of the list of movies. They should be able to manage the list of customers and the movies they rent. At check out, a customer brings one or more movies. The cashier looks up a customer by their phone number. If the customer is a first-time customer, the cashier asks for their full name, email, and phone number, and then registers them in the system. The cashier then scans the movies the customer has brought to check out and records them in the system. Each movie has a 10-digit barcode printed on the cover.…
· Make an Application called “ Student Management System ” that connect with database called university , the database contain 3 Tables o Student Table \ this Table contain all Data About Student in University { 1. Id --- int , primarykey 2. Name --- String 3. Gpa --- Double 4. College --- IT 5. Age --- int } o Course Table \ this Table contain all Data About Courses in University { 1. CourseId ---- String 2. CourseName ---- String 3. TeacherName ---- String 4. college ---- String 5. number Of Student ---- int } o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student { studentID --- int , foreign key from Student Table courseID --- int , foreign key from Course Table }
· Make an Application called “ Student Management System ” that connect with database called university , the database contain 3 Tables o Student Table \ this Table contain all Data About Student in University { 1. Id --- int , primarykey 2. Name --- String 3. Gpa --- Double 4. College --- IT 5. Age --- int } o Course Table \ this Table contain all Data About Courses in University { 1. CourseId ---- String 2. CourseName ---- String 3. TeacherName ---- String 4. college ---- String 5. number Of Student ---- int } o Student-Course Table \ this table contain a foreign key for both table “ Student and Course ” and contain data about the student who takes some courses or a courses that have number of Student { studentID --- int , foreign key from Student Table courseID --- int , foreign key from Course Table } · The Program should connect to the database and do the following operation : o Add Student o Delete Student o…
Describe the procedure when a database is started on a database server. Oracle allocates a memory area called the System Global Area (SGA) with its components.
Q1. Use the DBCA to Create a Database In this exercise, you will create a database listener (if one does not exist already) and then create a database to be called MYDB_<your name> using the DBCA, on either Windows or Linux. There is no significant difference between platforms. The illustrations that follow happen to be from Windows.
Which of the following is a key feature of a transactional database? a.) This type of database is optimized to execute a small number of complex queries. b.) This type of database is often denormalized with a focus on performance. c.) This type of database generally only has data loads with extremely rare updates or deletes to the data. d.) This type of database is used to process day-to-day operations in real time.