Oracle 1Z0-082 Online Practice Questions and Exam Preparation

Oracle 1Z0-082 Online Questions & Answers

• Question 131:

  You have been tasked to create a table for a banking application.

  One of the columns must meet three requirements:

  Be stored in a format supporting date arithmetic without using conversion functions

  Store a loan period of up to 10 years

  Be used for calculating interest for the number of days the loan remains unpaid Which data type should you use?

  A. INTERVAL YEAR TO MONTH
  B. INTERVAL DAY TO SECOND
  C. TIMESTAMP WITH LOCAL TIMEZONE
  D. TIMESTAMP
  E. TIMESTAMP WITH TIMEZONE
  B. INTERVAL DAY TO SECOND

  ---

  Explanation/Reference:

  Since the third requirement for banking application is

  'Be used for calculating interest for the number of days the loan remains unpaid'

  So, Data Type 'INTERVAL DAY TO SECOND' must be used to calculate duration in number of days.

• Question 132:

  Which two statements are true about views? (Choose two.)

  A. The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.
  B. The WITH CHECK clause prevents certain rows from being displayed when querying the view.
  C. Views can be updated without the need to re-grant privileges on the view.
  D. A view must only refer to tables in its defining query.
  E. Views can be indexed.
  A. The WITH CHECK clause prevents certain rows from being updated or inserted in the underlying table through the view.
  C. Views can be updated without the need to re-grant privileges on the view.

  ---

  Explanation/Reference:

• Question 133:

  Which three actions are ways to apply the principle of least privilege? (Choose three.)

  A. setting the O7_DICTIONARY_ACCESSIBILITY parameter to true
  B. setting the REMOTE_OS_AUTHENT parameter to true
  C. revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the SYSTEM user
  D. enabling Unified Auditing
  E. using Access Control Lists (ACLs)
  F. revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the public user
  D. enabling Unified Auditing
  E. using Access Control Lists (ACLs)
  F. revoking execute privilege on UTL_SMTP, UTL_TCP, UTL_HTTP, and UTL_FILE from the public user

  ---

  Explanation/Reference:

• Question 134:

  You want to use table compression suitable for OLTP that will:

  1.

  2.

  Compress rows for all DML statements on that table

  3.

  Minimize the overheads associated with compression

  Which compression option is best suited for this?

  A. COLUMN STORE COMPRESS FOR QUERY LOW
  B. ROW STORE COMPRESS BASIC
  C. COLUMN STORE COMPRESS FOR ARCHIVE LOW
  D. COLUMN STORE COMPRESS FOR ARCHIVE HIGH
  E. ROW STORE COMPRESS ADVANCED
  E. ROW STORE COMPRESS ADVANCED

  ---

  Explanation/Reference:

  Reference: https://www.oracle.com/technetwork/database/options/compression/advanced-compression-wp-12c-1896128.pdf

• Question 135:

  Which two statements are true about Oracle synonyms?

  A. A synonym has an object number.
  B. A synonym can be created on an object in a package.
  C. A synonym can have a synonym.
  D. All private synonym names must be unique in the database.
  E. Any user can create a PUBLIC synonym.
  A. A synonym has an object number.
  C. A synonym can have a synonym.

• Question 136:

  Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.

  Only the EMPLOYEE_ID column is indexed.

  Rows exist for employees 100 and 200.

  Examine this statement:

  

  Which two statements are true? (Choose two.)

  A. Employee 100 will have SALARY set to the same value as the SALARY of employee
  B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
  C. Employee 200 will have SALARY set to the same value as the SALARY of employee
  D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
  E. Employees 100 and 200 will have the same JOB_ID as before the update command
  F. Employees 100 and 200 will have the same SALARY as before the update command
  A. Employee 100 will have SALARY set to the same value as the SALARY of employee
  D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200

• Question 137:

  Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:

  ALTER DATABASE MOUNT;

  Which two actions are performed? (Choose two.)

  A. The online redo logs are opened
  B. The online data files are opened
  C. The alert log records the execution details
  D. The Oracle background processes are started
  E. The initialization parameter file is read
  F. The control file is read
  C. The alert log records the execution details
  F. The control file is read

  ---

  Explanation/Reference:

  http://facedba.blogspot.com/2014/07/oracle-database-startup-stages-and.html

• Question 138:

  You execute this query:

  SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), `MON'), `dd "Monday for" fmMonth rrrr')

  What is the result?

  A. It executes successfully but does not return any result
  B. It returns the date for the first Monday of the next month
  C. It generates an error
  D. It returns the date for the last Monday of the current month
  B. It returns the date for the first Monday of the next month

  ---

  Explanation/Reference:

  select sysdate from dual; 11-09-20 select TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE),'MON'),'dd "Monday for" fmMonth rrrr') from dual 05 Monday for October 2020

• Question 139:

  Examine the description of the SALES1 table:

  

  SALES2 is a table with the same description as SALES1.

  Some sales data is duplicated in both tables.

  You want to display the rows from the SALES1 table which are not present in the SALES2 table.

  Which set operator generates the required output?

  A. INTERSECT
  B. UNION ALL
  C. UNION
  D. SUBTRACT
  E. MINUS
  B. UNION ALL

  ---

  Explanation/Reference:

• Question 140:

  The CUSTOMERS table has a CUST_CREDIT_LIMIT column of data type NUMBER. Which two queries execute successfully? (Choose two.)

  A. SELECT NVL(cust_credit_limit * .15, `Not Available') FROM customers;
  B. SELECT NVL2(cust_credit_limit * .15, `Not Available') FROM customers;
  C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
  D. SELECT TO_CHAR(NVL(cust_credit_limit * .15, `Not Available')) FROM customers;
  E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
  C. SELECT NVL(TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;
  E. SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), `Not Available') FROM customers;

  ---

  Explanation/Reference:

  A) SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;

  B) SELECT NVL2(cust_credit_limit * .15, 'Not Available') FROM customers;

  C) SELECT NVL(TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;

  D) SELECT TO_CHAR(NVL(cust_credit_limit * .15, 'Not Available')) FROM customers;

  E) SELECT NVL2(cust_credit_limit, TO_CHAR(cust_credit_limit * .15), 'Not Available') FROM customers;