Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 61:

  Which two tasks can be performed in the NOMOUNT state? (Choose two.)

  A. Renaming data files
  B. Performing full database recovery
  C. Re-creating control files
  D. Creating a database
  E. Enabling online redo log archiving
  C. Re-creating control files
  D. Creating a database

• Question 62:

  Examine this SQL statement:

  SELECT cust_id, cust_last_name "Last Name" FROM customers WHERE country_id = 10 UNION SELECT cust_id CUST_NO, cust_last_name FROM customers WHERE country_id = 30

  Identify three ORDER BY clauses, any one of which can complete the query successfully. (Choose three.)

  A. ORDER BY "Last Name"
  B. ORDER BY 2, 1
  C. ORDER BY 2, cust_id
  D. ORDER BY CUST_NO
  E. ORDER BY "CUST_NO"
  A. ORDER BY "Last Name"
  B. ORDER BY 2, 1
  C. ORDER BY 2, cust_id

• Question 63:

  Which four account management capabilities can be configured using Oracle profiles? (Choose four.)

  A. the number of hours for which an account is locked after the configured number of login attempts has been reached
  B. the number of days for which an account may be inactive before it is locked
  C. the maximum amount of CPU time allowed for a user's sessions before their account is locked
  D. the ability to prevent a password from ever being reused
  E. the number of password changes required within a period of time before a password can be reused
  F. the number of days for which an account is locked after the configured number of login attempts has been reached
  G. the maximum number of sessions permitted for a user before the account is locked
  B. the number of days for which an account may be inactive before it is locked
  D. the ability to prevent a password from ever being reused
  E. the number of password changes required within a period of time before a password can be reused
  F. the number of days for which an account is locked after the configured number of login attempts has been reached

  ---

  Explanation/Reference:

• Question 64:

  Which two statements are true about Enterprise Manager Database Express? (Choose two.)

  A. It is available only when the database is open
  B. It can be used to perform database recovery when the database is opened
  C. The same port number can be used for Database Express configurations for databases on different hosts
  D. It can be used to switch a database into ARCHIVELOGMODE
  E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
  F. It can be used to perform database recovery when the database is mounted
  A. It is available only when the database is open
  C. The same port number can be used for Database Express configurations for databases on different hosts

  ---

  Explanation/Reference:

  A - Correct -> to startup the enterprise manager database express, the database have to be in open state

  B - Incorrect -> to perform a full recovery, the database has to be in mount state, and EM express not work if database is not in open state C - Correct -> since they are in different hosts, you can use the same port for then (default 5500)

  D - Incorrect -> to switch a database to ARCHIVELOGMODE the database need to be in mount state (like B answer)

  E - Incorrect -> the same port cannot be used in the same time for different services in the same host (here a basic of tcp/ip protocol) If need more reference:

  EM Express (Chapter 3.3)

  https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/2-day-dba.pdf

  ARCHIVELOGMODE (Chapter 12.3.2)

  https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/database-administrators-guide.pdf

• Question 65:

  You want to apply the principle of Least Privilege in all your live databases.

  One of your requirements is to revoke unnecessary privileges from all users who have them using Privilege Analysis.

  Which two are types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose two.)

  A. analysis of privileges that a user has on other schema's objects
  B. analysis of privileges that a user has on their own schema objects
  C. analysis of all privileges used by the sys user.
  D. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
  E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role
  D. analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role
  E. analysis of privileges granted directly to a role that are then used by a user who has been granted that role

  ---

  Explanation/Reference:

• Question 66:

  Which two statements are true about segment types in an Oracle Database?

  A. Table segments always have two or more extents.
  B. Temporary segments are only stored in a temporary tablespace.
  C. Undo segments are only stored in an undo tablespace.
  D. Cluster segments may contain data from multiple tables.
  E. Index segments always have two or more extents.
  B. Temporary segments are only stored in a temporary tablespace.

• Question 67:

  Examine the description of the customers table:

  

  You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit Is below 1000.

  Examine this partial query:

  SELECT cust_last_name, cust_credit_limit FROM customers

  Which two where conditions give the required result?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  A. Option A
  B. Option B

  ---

  Explanation/Reference:

• Question 68:

  Which three statements are true about using SQL*Plus?

  A. It has its own commands that are separate from any SQL statements.
  B. It must be downloaded from the Oracle Technology Network (OTN).
  C. It can run scripts entered at the SQL prompt.
  D. It can run Recovery Manager (RMAN) commands.
  E. It has both command-line and graphical user interfaces (GUI).
  F. It can run scripts passed to it by a shell script.
  A. It has its own commands that are separate from any SQL statements.
  C. It can run scripts entered at the SQL prompt.
  F. It can run scripts passed to it by a shell script.

  ---

  Explanation/Reference:

• Question 69:

  Which two tasks can you perform using DBCA for databases? (Choose two.)

  A. Configure a nonstandard block size for a new database
  B. Register a new database with an available Enterprise Manager Management server
  C. Change the standard block size of an existing database
  D. Configure incremental backups for a new database
  E. Enable flashback database for an existing database
  A. Configure a nonstandard block size for a new database
  B. Register a new database with an available Enterprise Manager Management server

  ---

  Explanation/Reference:

  Reference: https://docs.oracle.com/cd/B16254_01/doc/server.102/b14196/install003.htm

• Question 70:

  You issued this command:

  DROP TABLE hr.employees;

  Which three statements are true? (Choose three.)

  A. All indexes defined on HR.EMPLOYEES are dropped
  B. Synonyms for HR.EMPLOYEES are dropped.
  C. The HR.EMPLOYEES table may be moved to the recycle bin.
  D. Sequences used to populate columns in the HR.EMPLOYEES table are dropped.
  E. All constraints defined on HR.EMPLOYEES are dropped.
  F. Views referencing HR.EMPLOYEES are dropped.
  A. All indexes defined on HR.EMPLOYEES are dropped
  C. The HR.EMPLOYEES table may be moved to the recycle bin.
  E. All constraints defined on HR.EMPLOYEES are dropped.

  ---

  Explanation/Reference: