OCA Oracle 12C Administration (1Z0-062) Practice Test Set 3

Which of the following statements create an Oracle account but let the operating system authenticate logons? 


Options are :

  • create user ops$admin identified by os;
  • create user ops$admin nopassword;
  • create user ops$admin authenticated by os;
  • None

Answer : create user ops$admin identified by os;

Which data dictionary view contains information explaining why ADDM made its recommendations?


Options are :

  • DBA_ADVISOR_FINDINGS
  • DBA_ADVISOR_RATIONALE
  • DBA_ADVISOR_RECOMMENDATIONS
  • DBA_ADVISOR_OBJECTS

Answer : DBA_ADVISOR_RATIONALE

Which of the following statements has the correct syntax and gives the ability to grant the privilege to other users?


Options are :

  • grant alter any table to desmond with grant option;/li>
  • grant alter any table to desmond with admin option;
  • grant alter on gl.accounts to desmond with admin option;
  • grant alter any table with grant option to desmond;

Answer : grant alter any table to desmond with admin option;

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 9

Which procedure is used to tell Oracle that the statistics gathered should not be published?


Options are :

  • DBMS_STATS.SET_TABLE_PREFS
  • DBMS_STATS.PENDING_STATS
  • DBMS_STATS.PUBLISH_STATS
  • DBMS_STATS.GATHER_TABLE_STATS

Answer : DBMS_STATS.SET_TABLE_PREFS

If you want to capture the SQL statement and bind variables when performing a standard statement audit, which value should the AUDIT_TRAIL parameter have?


Options are :

  • OS,EXTENDED
  • DB
  • NONE
  • OS
  • DB,EXTENDED

Answer : DB,EXTENDED

Which of the following is not a step in configuring your database to archive redo log files?


Options are :

  • Multiplex the online redo log files.
  • Specify a destination for archived redo log files.
  • Specify a naming convention for your archived redo log files.
  • Place the database in ARCHIVELOG mode.

Answer : Multiplex the online redo log files.

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 10

User system granted the SELECT privilege on sh.products to user ian using WITH GRANT OPTION . Ian then granted SELECT on sh.products to user stuart . Ian has left the company, and his account has been dropped. What happens to Stuartís privileges on sh.products ?


Options are :

  • Stuart retains his SELECT privilege if Ian was dropped with the NOCASCADE REVOKE option.
  • Stuart retains his SELECT privilege on sh.products .
  • Stuart loses his SELECT privilege if Ian was dropped with the CASCADE REVOKE option.
  • Stuart loses his SELECT privilege on sh.products .

Answer : Stuart loses his SELECT privilege on sh.products .

Which of the following statements enables the role user_admin in the current session?


Options are :

  • set role user_admin;
  • alter session enable role user_admin;
  • alter session set role user_admin;
  • alter role user_admin enable;

Answer : set role user_admin;

Which of the following advisors determines if the space allocated to the shared pool, large pool, or buffer cache is adequate?


Options are :

  • Memory Advisor
  • SQL Tuning Advisor
  • Pool Advisor
  • SGA Tuning Advisor

Answer : Memory Advisor

1Z0-207 Oracle Comm Billing & Revenue Mgmt Pricing Exam Set 3

Which is a true statement regarding image copies and backup sets.


Options are :

  • An image copy stores one data file per image copy, and a backup set consists of one file per data file backed up.
  • An image copy stores one data file per image copy, and a backup set can store many data files in a single file
  • Both image copies and backup sets use a single file to store all objects to be backed up.
  • A backup set stores each data file in its own backup file, but an image copy places all data files into a single output file.

Answer : An image copy stores one data file per image copy, and a backup set can store many data files in a single file

Why are online backups known as inconsistent backups?


Options are :

  • Because not all control files are synchronized to the same SCN until the database is shut down
  • Because a database failure while an online backup is in progress can leave the database in an inconsistent state
  • Because both committed and uncommitted transactions are included in a backup when the database is online
  • Because online backups make copies of data files while they are not consistent with the control file

Answer : Because online backups make copies of data files while they are not consistent with the control file

Which of the following SQL statements allows user augustin to use the privileges asso- ciated with the password-protected role info_czar that has been granted to him?


Options are :

  • None
  • alter user augustin default role all;
  • alter session enable info_czar identified by brozo;
  • alter session enable role info_czar;
  • set role all;

Answer : alter user augustin default role all;

1Z0-982 Oracle Enterprise Planning and Budgeting Cloud Test Set 1

Which SGA component cannot be dynamically changed after instance startup?


Options are :

  • None of the above
  • LOG_BUFFER
  • SHARED_POOL
  • JAVA_POOL_SIZE

Answer : LOG_BUFFER

Which of the following statements give user desmond the ability to alter table gl.accounts ?


Options are :

  • allow desmond to alter table gl.accounts;
  • grant alter on gl.accounts to desmond;
  • grant alter table to desmond;
  • grant alter to desmond on gl.accounts;

Answer : grant alter on gl.accounts to desmond;

Among the failure events, which is the most serious and may cause data loss?


Options are :

  • The loss of one member of each redo log-file group
  • A tablespace can hold the objects of only one schema
  • The failure of the LGWR background process
  • The loss of an entire redo log-file group but no loss in any other group

Answer : The loss of an entire redo log-file group but no loss in any other group

Oracle 1Z0-207 Billing & Revenue Mgmt Pricing Practice Exam Set 6

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions