OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 1

The following SQL statement will allow user regina to perform which operations on sequence oe.orders_seq?
GRANT ALL ON oe.orders_seq TO regina;


Options are :

  • Change the number of sequence numbers that will be cached in memory.
  • Alter sequence oe.orders_seq to change the next value.
  • Both A and C.
  • Select the next value from oe.orders_seq..

Answer : Both A and C.

1Z0-520 Oracle EBS R12.1 Purchasing Essentials Practice Test Set 2

Which of the following activities can be audited?


Options are :

  • Unsuccessful selects from the employee_salary table
  • Unsuccessful deletions from the audit_trail table
  • All GRANT and REVOKE statements on procedures executed by user system
  • All of the above

Answer : All of the above

Which of the following statements gives user desmond the ability to alter table gl.accounts as well as give this ability to other accounts?


Options are :

  • grant alter any table to desmond with grant option;
  • 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;

Which of the following types of statements can use a temporary tablespace?


Options are :

  • SQL statements with a GROUP BY clause
  • An index creation
  • All of the above
  • A hash join operation

Answer : All of the above

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

How do you manage fine-grained auditing?


Options are :

  • With the GRANT and REVOKE statements
  • With the DBMS_FGA package
  • With the AUDIT and NOAUDIT statements
  • With the CREATE, ALTER, and DROP statements

Answer : With the DBMS_FGA package

Which of the following system privileges can allow the grantee to masquerade as another user and therefore should be granted judiciously?


Options are :

  • CREATE ANY JOB
  • All of the above
  • CREATE ANY PROCEDURE
  • ALTER USER

Answer : All of the above

Which of the following SQL statements limit attempts to guess passwords by locking an account after three failed logon attempts?


Options are :

  • alter user set failed_login_attempts = 3;
  • alter profile default limit failed_login_attempts 3;
  • alter system set max_logon_failures = 3 scope=both;
  • alter system set failed_login_attempts = 3 scope=both;

Answer : alter profile default limit failed_login_attempts 3;

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

Which of the following SQL statements allows user augustin to use the privileges associated with the password-protected role info_czar, which has been granted to him?


Options are :

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

Answer : alter user augustin default role all;

By default, how much tablespace can any account use for a new table?


Options are :

  • Up to the current free space in the tablespace
  • None
  • Unlimited space, including autoextends
  • Up to the default quota established at tablespace creation time

Answer : None

With which parameters do you specify unlimited datafile growth?


Options are :

  • UNLIMITED GROWTH
  • MAXEXTENTS UNLIMITED
  • MAXSIZE UNLIMITED
  • Datafile size cannot change.

Answer : MAXSIZE UNLIMITED

1Z0-409 Oracle Linux Fundamentals Practice Exam Set 2

Which of the following is not an object privilege on a table?


Options are :

  • DEBUG
  • SELECT
  • REFERENCES
  • READ

Answer : READ

Which of the following statements creates an Oracle account, but lets the operating system authenticate logons?


Options are :

  • create user ops$admin identified by os;
  • create user ops$admin identified externally;
  • None of the Above
  • create user ops$admin nopassword;
  • create user ops$admin authenticated by os;

Answer : create user ops$admin identified externally;

Which is not a type of segment that is stored in a tablespace?


Options are :

  • Redo
  • Temporary
  • Permanent
  • Undo

Answer : Redo

Oracle 12c SQL Certified Associate 1Z0-071 Real Exam 2019 Set 1

User system granted SELECT ANY TABLE to user ian using WITH ADMIN OPTION. Ian then granted SELECT ANY TABLE to user stuart. Ian has left the company, and his account is dropped. What happens to Stuart's privileges?


Options are :

  • Stuart retains his privileges if Ian was dropped with the NOCASCADE REVOKE option.
  • Stuart retains his privileges.
  • Stuart loses his privileges.
  • Stuart loses his privileges if Ian was dropped with the CASCADE REVOKE option.

Answer : Stuart retains his privileges.

Which of the following prevents a user from reusing a password when they change their password?


Options are :

  • Altering that user's profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_ REUSE_MAX
  • Altering that user's profile to UNLIMITED for both PASSWORD_REUSE_TIME and PASSWORD_ REUSE_MAX
  • Setting the initialization parameter NO_PASSWORD_REUSE to TRUE
  • Using a password verify function to record the new password and compare the new passwords to those recorded previously

Answer : Altering that user's profile to UNLIMITED for PASSWORD_REUSE_TIME and 1 for PASSWORD_ REUSE_MAX

How can you prevent someone from using an all-numeric password?


Options are :

  • Alter that user's profile setting PASSWORD_COMPLEXITY to ALPHNANUM.
  • Set the initialization parameter PASSWORD_COMPLEXITY to ALPHANUM.
  • Alter that user's profile setting PASSWORD_COMPLEXITY to ALPHNANUM.
  • There is no mechanism that lets you prevent an all-numeric password.

Answer : Alter that user's profile setting PASSWORD_COMPLEXITY to ALPHNANUM.

1Z0-521 Oracle E-Business Suite R12 Oracle Order Managment Set 1

Automatic segment space management on the tablespace causes which of the following table attributes in that tablespace to be ignored?


Options are :

  • PCTFREE and PCTUSED
  • BUFFERPOOL and FREEPOOL
  • The whole storage clause
  • NEXT and PCTINCREASE

Answer : PCTFREE and PCTUSED

Where can the database write audit_trail records?


Options are :

  • In a database table
  • Both in the database and in an operating system file
  • In a file outside the database
  • Either in the database or in an operating system file

Answer : Either in the database or in an operating system file

Which objects share the same namespace and therefore cannot have the same name?


Options are :

  • Tables and procedures
  • Tables and indexes
  • Tables and constraints
  • Tables and triggers

Answer : Tables and procedures

1Z1-574 Oracle IT Architecture Essentials Practice Exam Set 8

Which of the following statements about user administration and security is the most true? 


Options are :

  • Password-protected roles require a password before they can become enabled.
  • You can limit a table to a maximum size on disk.
  • You can disable any role that you find in your session_roles view.
  • If you execute alter profile student limit idle_time 10; and then execute alter user scott profile student;, then user scott will be disconnected from future sessions after 10 minutes of idle time.

Answer : You can limit a table to a maximum size on disk.

Which of the following SQL statements results in a disconnection after a session is idle for 30 minutes?


Options are :

  • alter session set idle_timeout=30;
  • alter session set idle_timeout=1800;
  • alter profile limit idle_time 30;
  • alter profile set idle_timout 30;

Answer : alter profile limit idle_time 30;

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


Options are :

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

Answer : grant alter on gl.accounts to desmond;

OCP Oracle Database 11g Administrator Certified Professional Set 4

Which of the following statements about tablespaces is true?


Options are :

  • The SYSAUX tablespace is an optional tablespace only created if you install certain database options.
  • A tablespace can hold the objects of only one schema.
  • A tablespace is the physical implementation of logical structure called a namespace.
  • A bigfile tablespace can have only one datafile.

Answer : A bigfile tablespace can have only one datafile.

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


Options are :

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

Answer : set role user_admin;

User system granted SELECT 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 is dropped. What happens to Stuart's privileges on sh.products?


Options are :

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

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

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

What backup capability is not supported with RMAN?


Options are :

  • Open database backups
  • Closed database backups
  • Password file backups
  • Control file backups

Answer : Password file backups

Oracle 1Z0-976 Cloud Service Implementation Essentials Exam Set 2

What command displays the settings for automatic channel setup?


Options are :

  • SHOW ALL
  • SHOW DEVICE
  • SHOW CHANNEL
  • SHOW CONFIGURATION

Answer : SHOW ALL

Which credentials are needed to perform a recovery with EM?


Options are :

  • Database account with SYSDBA privilege
  • Administrator account in Windows
  • all of the above
  • Oracle account in Unix

Answer : all of the above

What are the two cases defined in the backup control file? 


Options are :

  • ALTER DATABASE OPEN
  • None of the above
  • ALTER DATABASE OPEN NORESET
  • ALTER DATABASE OPEN RESETLOGS

Answer : ALTER DATABASE OPEN RESETLOGS

1Z0-520 Oracle EBS R12 Purchasing Essentials Practice Exam Set 6

Which command is not a valid RMAN incomplete recovery run block?


Options are :

  • run { set until SCN 7563633; restore database; recover database; }
  • run { set until change 7563633; restore database; recover database; }
  • run { set until sequence 3 thread 1; restore database; recover database; }
  • run { set until time '06-SEP-2004 11:25:00'; restore database; recover database; }

Answer : run { set until change 7563633; restore database; recover database; }

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions