Which two are true about creating tables in an Oracle database? (Choose two.)
Which two are true about creating tables in an Oracle database? (Choose two.)
To create tables in an Oracle database, a system privilege is required, such as the CREATE TABLE privilege if creating a table in one's own schema, or the CREATE ANY TABLE privilege if creating a table in another user's schema. Additionally, the same table name can be used for tables in different schemas as schemas differentiate the namespaces for database objects.
To create a relational table in your own schema, you must have the CREATE TABLE system privilege. To create a table in another user's schema, you must have the CREATE ANY TABLE system privilege. A) is wrong because external table creates a file only if it's created with 'CREATE AS SELECT' statement
Should be BC
BC cuz google says: 'System privileges allow a user to perform a particular database operation or class of database operations. For example, to create a table, the user needs the create table privilege.' 'Objects have privileges associated with them, such as insert, update and delete a table.'
Should be AC since CREATE TABLE does not require system privilege just object privilege. CREATE ANY TABLE require system privilege
'System privileges allow a user to perform a particular database operation or class of database operations. For example, to create a table, the user needs the create table privilege.' 'Objects have privileges associated with them, such as insert, update and delete a table.'