Oracle 1Z0-082 Oracle Database Administration I Exam Practice Test Questions

• Question 1

  Which two statements are true about the PMON background process? (Choose two.)

  • It registers database services with all local and remote listeners known to the database instance
  • It frees resources held by abnormally terminated processes
  • It records checkpoint information in the control file
  • It frees unused temporary segments
  • It kills sessions that exceed idle time

  Show Answer Answer: B,E Next

• Question 2

  You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed. The variables used in your query are never undefined in your session. Which query can be used?

  • SELECT &&col1, &&col2FROM &tableWHERE &&condition = &&cond;
  • SELECT &col1, &col2FROM &&tableWHERE &condition;
  • SELECT &col1, &col2FROM “&table”WHERE &condition;
  • SELECT ‘&&col1’, ‘&&col2’FROM &tableWHERE ‘&&condition’ = ‘&cond’;
  • SELECT &&col1, &&col2FROM &tableWHERE &&condition;

  Show Answer Answer: B Next

• Question 3

  You need to calculate the number of days from 1st January 2019 until today. Dates are stored in the default format of DD-MON-RR. Which two queries give the required output? (Choose two.)

  • SELECT TO_CHAR(SYSDATE,‘DD-MON-YYYY’) – ’01-JAN-2019’ FROM DUAL;
  • SELECT ROUND(SYSDATE – ’01-JAN-2019’) FROM DUAL;
  • SELECT ROUND(SYSDATE – TO_DATE(‘01/JANUARY/2019’)) FROM DUAL;
  • SELECT TO_DATE(SYSDATE, ‘DD/MONTH/YYYY’) – ‘01/JANUARY/2019’ FROM DUAL;
  • SELECT SYSDATE – TO_DATE(’01-JANUARY-2019’) FROM DUAL;

  Show Answer Answer: C,E Next

• Question 4

  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 three types of analyses can be done using the DBMS_PRIVILEGE_CAPTURE package? (Choose three.)

  • analysis of all privileges used by all users including administrative users in the database
  • analysis of all privileges used by all users but excluding administrative users in the database
  • analysis of privileges that a user has on their own schema objects that they did not use
  • analysis of privileges that a user has on their own schema objects that they did use
  • analysis of privileges granted directly to a role that are then used by a user who has been granted that role
  • analysis of privileges granted indirectly to a role that are then used by a user who has been granted that role

  Show Answer Answer: B,E,F Next

• Question 5

  The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations. Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command: CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’; How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

  • as SCOTT in DALLAS_DB
  • as SCOTT in BOSTON_DB
  • as SCOTT in BOSTON_DB and SYS in DALLAS_DB
  • as SYS in both the databases
  • as SCOTT in both the databases

  Show Answer Answer: B Next