Oracle 1Z0-497 Online Practice Questions and Exam Preparation

Oracle 1Z0-497 Online Questions & Answers

• Question 71:

  What new role in Oracle Database 12c encompasses the administrative privileges required for backup and recovery?

  A. SYSBKP
  B. SYSBKPRMAN
  C. SYSRMAN
  D. SYSBACKUP
  D. SYSBACKUP

  ---

  Reference:

  http://docs.oracle.com/cd/E16655_01/backup.121/e17631/release_changes.htm#RCMRF90521 (sys backup privilege)

• Question 72:

  An Oracle instance is a combination of______.

  A. database files and parameter file (initialization parameter file or server parameter file)
  B. System Global Area (SGA) and background processes
  C. a listener process, server processes, and background processes
  D. System Global Area (SGA), server processes, and background processes
  E. database files, System Global Area (SGA), and background processes
  B. System Global Area (SGA) and background processes

  ---

  Reference: http://docs.oracle.com/cd/A57673_01/DOC/server/doc/SCN73/ch9.htm#o instance

• Question 73:

  Which statement regarding Oracle Active Data Guard 12c is false?

  A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.
  B. It provides new support for DML to global temporary tables and the use of sequences in the standby database.
  C. It repairs block corruptions detected in the primary or standby database.
  D. It supports different software patch levels between a primary database and its physical standby database for the purpose of applying and validating Oracle patches in a rolling fashion.
  E. It supports multi master and bidirectional replication architectures where there are multiple databases that all contain the same data, even if they are not synchronized.
  A. Any application compatible with a read-only database can run on an Oracle Active Data Guard standby.

• Question 74:

  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.
  A. When a role is granted to a user, the privileges in the role are limited to the context of the PDB.
  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

• Question 75:

  Which statement about Online Move Data file is true?

  A. Moving a data file online prevents DML operations on segments stored in the data file.
  B. Flashing back a database to a point in time before a data file had been renamed online retains the new name.
  C. Moving a data file online can be performed if the data file is in OFFLINE mode.
  D. Moving a data file online cannot be performed if the data file is under BEGIN BACKUP.
  A. Moving a data file online prevents DML operations on segments stored in the data file.

• Question 76:

  Which two statements are true about Oracle Data Pump?

  A. EXPDP and IMPDP are the client components of Oracle Data Pump.
  B. DBMS_DATAPUMP PL/SQL packages can be used independently of Data Pump clients.
  C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
  D. Oracle Data Pump imports can be done from the export files generated in Original Export Release 9.x.
  E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
  A. EXPDP and IMPDP are the client components of Oracle Data Pump.
  B. DBMS_DATAPUMP PL/SQL packages can be used independently of Data Pump clients.

  ---

  Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm

• Question 77:

  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
  B. object-level statistics
  C. Automatic SGA Memory Management
  E. all server-generated alerts

• Question 78:

  Consider an application in which memory required for each session is 400 KB and memory required for each server process is 4 MB. The pool size is 100 and the number of shared servers used is 100. If there are 5000 client connections, what is the amount of memory used by a dedicated server?

  A. 615 MB
  B. 2.5 GB
  C. 4 GB
  D. 12 GB
  E. 22 GB
  B. 2.5 GB

• Question 79:

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

• Question 80:

  Which two statements correctly distinguish between undo and redo data?

  A. Undo reverses a change, whereas redo re-creates a change.
  B. Redo reverses a change, whereas undo re-creates a change.
  C. Undo protects against inconsistent reads, whereas redo protects against data loss.
  D. Redo protects against inconsistent reads, whereas undo protects against data loss.
  A. Undo reverses a change, whereas redo re-creates a change.
  C. Undo protects against inconsistent reads, whereas redo protects against data loss.