Oracle Updated 1z0-497 Exam Questions and Answers by farah

The SKD user cannot log in to the database instance.

The objects owned by the SKD user are not accessible to any user.

Other users can access objects owned by the SKD user, to which they have access.

The SKD user's password expires and the user is forced to change the password at the next login.

The database stops (shutdown abort).

B) The database Stops (shutdown immediate).

You activate Automatic Shared Memory Management.

You get an error message.

When a role is granted to a user, the privileges in the role are limited to the context of the PDB.

Local roles can be granted only to local users.

Common roles can be granted to both local and common users.

A user can create common roles if the user has the CREATE ROLE privilege, and SET CONTAINER for all PDBs

Common roles can be created in the root and PDBs.

Extend the logical volume by 10 MB where the data files are stored;

# lvextend -L+10M /diskl

Add a data file:

SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

Move a partition to another tablespace:

SQL> CREATE TABLESPACE ADDITIONAL_TBS DATAFILE '/disk1/additional_tbs_1 .dbf' SIZE 10M;

SQL> ALTER TABLE MYTAB MOVE PARTITION P2 TABLESPACE ADDlTIONAL_TBS;

Resize the existing data file:

SQL> ALTER DATABASE DATAFILE '/diskl/mytbs_l .dbf' RESIZE 20M;

E) Remove a data file:

SQL> ALTER TABLESPACE MYTBS DROP DATAFILE '/diskl/mytbs_l - dbf';