Oracle Oracle Certifications 1Z0-082 Questions & Answers

• Question 21:

  The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.

  Segment creation is not deferred.

  You execute this command:

  

  Which three statements must be true so that the SALES user can create tables in SALES_Q1? (Choose three.)

  A. The sales user must have a quota on the TEMP tablespace

  B. The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema

  C. The sales user must have been granted the CREATE SESSION privilege

  D. The sales user must have their quota on the users tablespace removed

  E. The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema

  F. The sales user must have been granted the CREATE TABLE privilege

  Correct Answer: BCF

  https://docs.oracle.com/database/121/DBSEG/users.htm#DBSEG99778 When you create a new user account, you should enable this user to access the database

• Question 22:

  Which three statements are true about the naming methods and their features supported by Oracle database used to resolve connection information?

  A. Local naming can be used if Connect-Time Failover is required.

  B. A client can connect to an Oracle database instance even If no client side network admin has been configured.

  C. Directory Naming requires setting the TNS_ADMIN environment variable on the client side.

  D. Local Naming requires setting the TNS_ADMIN environment variable on the client side.

  E. Directory Naming can be used if Connect-Time Failover is required.

  F. Easy Connect supports TCP/IP and SSL.

  Correct Answer: ABE

• Question 23:

  View the Exhibits and examine the structure of the COSTS and PROMOTIONS tables.

  You want to display PROD_IDS whose promotion cost is less than the highest cost PROD_ID in a promotion time interval.

  Examine this SQL statement:

  

  Exhibit 1.

  

  Exhibit 2.

  

  What will be the result?

  A. It gives an error because the ALL keyword is not valid

  B. It gives an error because the GROUP BY clause is not valid

  C. It executes successfully but does not give the required result

  D. It executes successfully and gives the required result

  Correct Answer: D

• Question 24:

  Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

  A. The Oracle Net Configuration Assistant is only used when running the Oracle installer

  B. Oracle Net Manager can be used to centrally configure listeners on any database server target

  C. The lsnrctl utility requires a listener.ora file to exist before it is started

  D. Oracle Net Manager can be used to locally configure naming methods on a database server

  E. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server

  F. Enterprise Manager Cloud Control can be used to centrally configure net service names for any database server target

  Correct Answer: DEF

  Oracle Net Manager to locally control and Enterprise Manager Cloud Control to centrally control. https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/introducing-oracle-net-services.html#GUID-6B1F0584-887D-4D2A-B982-40ACF15DF985

  1.

  Oracle Enterprise Manager Cloud Control combines configuration functionality across multiple file systems, along with listener administrative control to provide an integrated environment for configuring and managing Oracle Net Services.

  2.

  Oracle Net Manager provides configuration functionality for an Oracle home on a local client or server host.

• Question 25:

  Which two are true about shrinking a segment online? (Choose two.)

  A. It is not possible to shrink either indexes or Index Organized Tables (IOTs)

  B. It always eliminates all migrated rows if any exist in the table

  C. To shrink a table it must have a PRIMARY KEY constraint

  D. To shrink a table it must have a UNIQUE KEY constraint

  E. To shrink a table it must have row movement enabled

  F. It must be in a tablespace that uses Automatic Segment Space Management (ASSM)

  Correct Answer: EF

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_3001.htm

• Question 26:

  Which two statements are true about the rules of precedence for operators? (Choose two.)

  A. The concatenation operator | | is always evaluated before addition and subtraction in an expression

  B. NULLS influence the precedence of operators in an expression

  C. The + binary operator has the highest precedence in an expression in a SQL statement

  D. Arithmetic operators with equal precedence are evaluated from left to right within an expression

  E. Multiple parentheses can be used to override the default precedence of operators in an expression

  Correct Answer: DE

  Reference: https://docs.oracle.com/cd/B19306_01/server.102/b14200/operators001.htm

  https://docs.oracle.com/cd/A87860_01/doc/server.817/a85397/operator.htm

  Precedence is the order in which Oracle evaluates different operators in the same expression. When evaluating an expression containing multiple operators, Oracle evaluates operators with higher precedence before evaluating those with lower precedence. Oracle evaluates operators with equal precedence from left to right within an expression.

• Question 27:

  In your data center, Oracle Managed Files (OMF) is used for all databases.

  All tablespaces are smallfile tablespaces.

  SALES_Q1 is a permanent user-defined tablespace in the SALES database.

  Examine this command which is about to be issued by a DBA logged in to the SALES database:

  ALTER TABLESPACE sales_q1 ADD DATAFILE;

  Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)

  A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.

  B. Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.

  C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.

  D. Add the AUTOEXTEND ON clause with NEXT set to 100M.

  E. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.

  Correct Answer: BC

  https://oracle-base.com/articles/9i/oracle-managed-files

  -Files typically have a default size of 100M

  - if OMF is used you do not need to specify a path for the new created datafile BUT we have to "ensure that the command executes successfully"

• Question 28:

  Examine this command:

  

  Which two statements are true?

  A. Compressed objects in SALES01.DBF will be uncompressed In SALES02.DBF after the move.

  B. DML may be performed on tables with one or more extents in this data file during the execution of this command.

  C. It overwrites any existing file with the name SALES02.DBF.dbf in /u02 by default.

  D. The "to" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

  E. Tables with one or more extents in this data file may be queried during the execution of this command.

  Correct Answer: BE

• Question 29:

  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

  Correct Answer: AC

  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 30:

  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

  Correct Answer: B

  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