1Z0-497 Online Practice Questions and Answers

Which is the default port number for Database Express?

A. 7801

B. 5500

C. 2243

D. 1521

E. 22

Your database is open and the listener is running. The DBA stops the listener by using the command:

LSNRCTL> STOP

What happens to the sessions that are currently connected to the database instance?

A. They can perform only queries.

B. They are not affected and continue to function normally.

C. They are terminated and the active transactions are rolled back.

D. They are not allowed to perform any operations till the listener is started.

Examine the statements:

SQL> CREATE TABLESPACE MYTBS DATAFILE '/disk1/mytbs_l.dbf ' SIZE 10M;

SQL> CREATE TABLE mytab (id NUMBER, descr VARCHAR2 (100) ) PARTITION BY RANGE(id) (

partition pi values loss than (100000) tablespacemytbs storage (initial lm), partition p2 values less than

(MAXVALUE) tablespacemytbs storage (initial 1m) );

When inserting data, you get the error:

ORA-01688: unable to extend table SYS.MYTAB partition P2 by 128 in tablespace MYTBS

Which three operations would allow you to insert data without getting the error message?

A. Extend the logical volume by 10 MB where the data files are stored; # lvextend -L+10M /diskl

B. Add a data file: SQL>ALTER TABLESPACE MYTBS ADD DATAFILE ' /disk1/mytbs_2 .dbf SIZE 10M;

C. 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;

D. 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';

Examine the commands:

SQL> CONNECT sys@CDBl AS SYSDBA

$QL>STARTUP MOUNT

SQL> ALTER DATABASE cdbl MOUNT;

Which four options represent what happens when these commands are executed?

A. The instance is started.

B. The CDB control files are opened for the instance.

C. The root is mounted.

D. The root is opened.

E. The PDBs are mounted.

F. The PDBs are mounted, and the seed is opened in READ ONLY mode.

G. The PDBs are mounted, and opened in READ WRITE mode, while the seed is opened In READ ONLY mode.

Identify three types of important statistics collection that you can disable in Oracle Database 12c by setting the STATISTIS_LEVEL parameter to BASIC.

A. Oracle Database alert.log file

B. object-level statistics

C. Automatic SGA Memory Management

D. Oracle Database Trace files

E. all server-generated alerts

Which two statements are true when you execute an invoker's rights procedure?

A. The owner must have the INHERIT PRIVILEGES object privilege on the invoking user, or the INHERIT ANY PRIVILEGES privilege.

B. Invoking users can control who can access their privileges when they run an invoker's rights procedure.

C. The calling user must be granted the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

D. The calling user must grant the INHERIT PRIVILEGES object privilege on the user owner of the procedure.

For which use case would you use a rolling upgrade with the Oracle Active Data Guard feature?

A. when upgrading from Oracle Database 12c to the first patch set of Oracle Database 12c

B. when upgrading from Oracle Database 10g to Oracle Database 12c

C. when upgrading from Oracle Database 11g to Oracle Database 12c

D. when upgrading from any previous version of Oracle Database to Oracle Database 12c

Which three statements about common and local roles are true?

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

B. Local roles can be granted only to local users.

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

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

E. Common roles can be created in the root and PDBs.

Which four statements about users in Oracle Database 12c are correct?

A. A common user cannot have the same name as any local user across all PDBs.

B. A common user can be created only in the root container.

C. A local user with the proper privileges can also create a common user.

D. If a PDB is closed, the common and local users of the PDB are not visible.

E. A common user with the proper privileges can create a common user by using the CONTAINER=CURRENT clause.

F. A common user is one that has the same username and authentication credentials across multiple PDBs.

Which two statements about Global Data Services (GDS) are correct?

A. GDS allows scaling replication-aware application workloads beyond the cluster (that is, across replicated clusters).

B. GDS helps in performing data replication.

C. GDS works seamlessly with any combination of Oracle RAC databases, single-instance databases, Oracle Data Guard, Oracle Active Data Guard, and Oracle Golden Gate.

D. GDS helps to perform database failovers, and does not require Data Guard Broker.

E. The GDSMGRL utility is a command-line interface for configuring and managing the Global Data Services framework.