CREATE SESSION System Privilege - Operation authorized to connect to database - Oracle Schema

Q.  Which User System Privilege used for this operation authorized to connect to the database?
- Published on 27 Jul 15

a. CREATE TABLE
b. CREATE VIEW
c. CREATE SESSION
d. CREATE SEQUENCE

ANSWER: CREATE SESSION

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    1. CREATE TABLE - This statement is used to create a table in the database.

    2. CREATE VIEW - It is a virtual table based on the result-set of an SQL statement.
    - It contains rows and columns, just like a real table.
    - The fields in a view are fields from one or more real tables in the database.
    - You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

    3. CREATE SESSION - A newly created user cannot connect to the database until granted the CREATE SESSION system privilege.

    4. CREATE SEQUENCE - Use the CREATE SEQUENCE statement to create a sequence, which is a database object from which multiple users may generate unique integers.
    - You can use sequences to automatically generate primary key values.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲