Online Access Free 1z0-497 Practice Test

You execute the following command:
SQL> ALTER USER skd ACCOUNT LOCK;
Which two statements are correct?

• A.The SKD user cannot log in to the database instance.
• B.Other users can access objects owned by the SKD user, to which they have access.
• C.The objects owned by the SKD user are not accessible to any user.
• D.The SKD user's password expires and the user is forced to change the password at the next login.

Which two statements are true about this common user?

• A.SQL> conn c##usr/pwd@pdb2
  You are unable to create a connection. You need to create the common user c# #usr explicitly in
  PDB2 by executing:
  SQL>conn system/pwd@pdb2
  SQL> CREATE USER c##usrIDENTIFIED BYpwd CONTAINER=CURRENT;
  Now you are able to connect as common user c##usr to PDB2.
• B.SQL> conn c##usr/pwd@pdb1
  You are connected to PDB1 successfully.
• C.SQL> conn c##usr/pwd@pdb2
  You are unable to create a connection. You first need to sync PDB2 by executing:
  SQL> conn / as sysdba
  SQL>exec DBMS_PDB.SYNC_PDB;
• D.SQL> conn c##usr/pwd@pdb2
  You are connected to PDB2 successfully.

In which situation would you use static database registration for a listener?

• A.when multiple databases are to be registered with the listener
• B.when users need to connect the database instance by using the host naming method
• C.when the database instance to be registered with the listener is configured in shared server mode
• D.when DBAs need to connect remotely to start up the database instance

A DBA informs you that an Oracle instance has started. What does this imply?

• A.Only background and user processes are running.
• B.Users can access the data in the database.
• C.Only SGA has been allocated for the database.
• D.Memory areas have been allocated and background processes have been started.

Identify two solutions that Oracle provides for patch conflict.

• A.overlay patch
• B.merge patch
• C.dual patch
• D.combine patch
• E.super patch