How to pass Oracle 1z0-082 exam with the help of dumps?

Question # 1

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 servertarget
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 databaseserver
E. Enterprise Manager Cloud Control can be used to centrally configure listeners on anymanaged database server
F. Enterprise Manager Cloud Control can be used to centrally configure net service namesfor any database server target 

Show Answer

Question # 2

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 SALESdatabase:ALTER TABLESPACE sales_q1 ADD DATAFILE;Which are two actions, either one of which you could take to ensure that the commandexecutes successfully? (Choose two.)

A. Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specifywith at least 50 Mb of available space.
B. Specify a path in the DATAFILE clause of the command specifying a location with atleast 100M of available space.
C. Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb ofavailable 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 specifylocations with at least 50 Mb of available space. 

Show Answer

Question # 3

In which three situations does a new transaction always start? (Choose three.) 

A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECTstatement was issued in the same session
B. when issuing a TRUNCATE statement after a SELECT statement was issued in thesame session
C. when issuing a CREATE TABLE statement after a SELECT statement was issued in thesame session
D. when issuing the first Data Manipulation Language (DML) statement after a COMMITOR ROLLBACK statement was issued in the same session
E. when issuing a CREATE INDEX statement after a CREATE TABLE statementcompleted successfully in the same session
F. when issuing a DML statement after a DML statement failed in the same session

Show Answer

Question # 4

Which three are types of segments in an Oracle Database? (Choose three.) 

A. undo
B. index
C. stored procedures
D. sequences
E. tables
F. clusters

Show Answer

Question # 5

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database homecontains:Which statement is true? 

A. Dynamic service registration cannot be used for this database instance
B. The LREG process registers services dynamically with the LISTENER_1 listener
C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamicservice registration
D. There are two listeners named LISTENER and LISTENER_1 running simultaneouslyusing port 1521 on the same host as the database instances
E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamicservice registration

Show Answer

Question # 6

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

A. It registers database services with all local and remote listeners known to the databaseinstance
B. It frees resources held by abnormally terminated processes
C. It records checkpoint information in the control file
D. It frees unused temporary segments
E. It kills sessions that exceed idle time

Show Answer

Question # 7

Which three statements are true about table data storage in an Oracle Database? (Choose three.)  

A. Data block headers contain their own Data Block Address (DBA)
B. A table row piece can be chained across several database blocks
C. Multiple row pieces from the same row may be stored in different database blocks
D. Multiple row pieces from the same row may be stored in the same block 
E. Data block free space is always contiguous in the middle of the block 
F. Index block free space is always contiguous in the middle of the block 

Show Answer

Question # 8

Which three statements are true about single-row functions? (Choose three.) 

A. They can be used only in the WHERE clause of a SELECT statement
B. The argument can be a column name, variable, literal or an expression
C. The data type returned can be different from the data type of the argument
D. They can be nested to any level
E. They can accept only one argument
F. They return a single result row per table 

Show Answer

Question # 9

Examine this command:CREATE UNDO TABLESPACE undotbs01DATAFILE ‘undotbs_01.dbf’SIZE 100MAUTOEXTEND ON;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)  

A. Add the SEGMENT SPACE MANAGEMENT AUTO clause
B. Set UNDO_TABLESPACE to UNDOTBS01
C. Add the NOLOGGING clause
D. Make certain that the database operates in automatic undo management mode
E. Add the ONLINE clause

Show Answer

Question # 10

Examine these commands: Which two statements are true about the sqlldr execution? (Choose two.)

A. It overwrites data in EMP with data in EMP.DAT
B. It uses the database buffer cache to load data
C. It generates a log that contains control file entries, which can be used with normalSQL*Loader operations
D. It generates a sql script that it uses to load data from EMP.DAT to EMP
E. It appends data from EMP.DAT to EMP

Show Answer

Question # 11

Evaluate these commands which execute successfully: Which two statements are true about the ORD_ITEMS table and the ORD_SEQ sequence? (Choose two.) 

A. If sequence ORD_SEQ is dropped then the default value for column ORD_NO will beNULL for rows inserted into ORD_ITEMS
B. Any user inserting rows into table ORD_ITEMS must have been granted access tosequence ORD_SEQ
C. Column ORD_NO gets the next number from sequence ORD_SEQ whenever a row isinserted into ORD_ITEMS and no explicit value is given for ORD_NO
D. Sequence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20times
E. Sequence ORD_SEQ is guaranteed not to generate duplicate numbers 

Show Answer

Question # 12

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.) 

A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
B. Source Routing requires the use of a name server
C. Source Routing enables the use of Connection Manager (CMAN) which enablesnetwork traffic to be routed through a firewall
D. Load Balancing can balance the number of connections to dispatchers when using aShared Server configuration
E. Load Balancing requires the use of a name server
F. Connect Time Failover requires the connect string to have two or more listeneraddresses configured 

Show Answer

Question # 13

Which two statements are true about UNDO and REDO? (Choose two.) 

A. The generation of UNDO generates REDO
B. DML modifies Oracle database objects and only generates UNDO
C. The generation of REDO generates UNDO
D. DML modifies Oracle database objects and only generates REDO

Show Answer

Question # 14

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_linit * .15, ‘Not Available’) FROM customers;
B. SELECT NVL2(cust_credit_linit * .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 customeAnswer: B,C rs;

Show Answer

Question # 15

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)

Show Answer

Question # 16

You execute this command:CREATE SMALLFILE TABLESPACE salesDATAFILE ‘/u01/app/oracle/sales01.dbfSIZE 5GSEGMENT SPACE MANAGEMENT AUTO;Which two actions must you take to ensure UNDOTBS01 is used as the default UNDOtablespace? (Choose two.)

A. It must be smaller than the smallest BIGFILE tablespace
B. Free space is managed using freelists
C. Any data files added to the tablespace must have a size of 5 gigabytes
D. It uses the database default blocksize
E. It is a locally managed tablespace 

Show Answer

Question # 17

A database is configured to use automatic undo management with temporary undoenabled.An UPDATE is executed on a temporary table.Where is the UNDO stored?

A. in the undo tablespace
B. in the SYSAUX tablespace
C. in the SGA
D. in the PGA
E. in the temporary tablespace

Show Answer

Question # 18

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 loginattempts 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 islocked
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 canbe reused
F. the number of days for which an account is locked after the configured number of loginattempts has been reached
G. the maximum number of sessions permitted for a user before the account is locked 

Show Answer

Question # 19

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.) 

A. Tablespace free space can be viewed in VSTABLESPACE
B. VSTABLESPACE displays information that is contained in the controlfile abouttablespaces
C. VSTABLESPACE displays information about tablespaces contained in the datadictionary
D. Tablespace free space can be viewed in DBA_TABLESPACES
E. A datafile can be renamed when the database is in MOUNT state and the new file nameis displayed when querying DBA_DATA_FILES after the database is opened 

Show Answer

Question # 20

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

A. An undo segment may be used by multiple transactions simultaneously
B. Undo segments can wrap around to the first extent when a transaction fills the lastextend of the undo segment
C. Undo segments have a minimum of three extents
D. Undo segments can extend when a transaction fills the last extent of the undo segment
E. A single transaction may use multiple undo segments simultaneously
F. Undo segments must be stored in a BIGFILE tablespace
G. Undo segments must be stored in a SMALLFILE tablespace 

Show Answer

Question # 21

Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)

A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additionaldetails of fractional seconds
B. SYSDATE can be queried only from the DUAL table
C. CURRENT_DATE returns the current date and time as per the session time zone
D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
E. SYSDATE and CURRENT_DATE return the current date and time set for the operatingsystem of the database server
F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE 

Show Answer

Question # 22

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:1. A size of 100 MB2. AUTOEXTEND is off3. UNDO_RETENTION is set to 15 minutes4. It has RETENTION GUARANTEEUNDOTBS1 fills with uncommitted undo 10 minutes after the database opens.What will happen when the next update is attempted by any transaction?

A. It succeeds and the generated undo is stored in SYSTEM.  
B. It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’ “. 
C. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten bythe generated undo.
D. It succeeds and the generated undo is stored in SYSAUX.
E. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by thegenerated undo.

Show Answer

Question # 23

Which two statements are true regarding a SAVEPOINT? (Choose two.) 

A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
C. Only one SAVEPOINT may be issued in a transaction
D. A SAVEPOINT does not issue a COMMIT
E. Rolling back to a SAVEPOINT can undo a DELETE statement 

Show Answer

Question # 24

You execute this command: During the export operation, you detach from the job by using CTRL+C and then executethis command:Export> STOP_JOB=immediateAre you sure you wish to stop the job ([yes]/no): yesWhich two statements are true about the job? (Choose two.)

A. You can no longer monitor it
B. You can reattach to it and monitor it
C. It is paused and can be resumed
D. It continues to run in the background 
E. It terminates  

Show Answer

Question # 25

The ORCL database has RESUMABLE__TIMEOUT = 7200 andDEFERRED_SEGMENT_CREATION = FALSEUser U1 has a 1 MB quota in tablespace DATA.U1 executes this command:SQL> CREATE TABLE t1 AS(SELECT object_name, sharing, createdFROM dba_objects);U1 complains that the command is taking too long to execute.In the alert log, the database administrator (DBA) finds this:2017-03-06T12:15:17.183438+05:30statement in resumable session ‘User U1(136), Session 1, Instance 1’ was suspended dueto ORA-01536: space quota exceeded for tablespace ‘DATA’Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

A. Add a data file to DATA
B. Drop other U1 objects in DATA
C. Increase U1’s quota sufficiently in DATA
D. Set DEFERRED_SEGMENT_CREATION to TRUE
E. Grant UNLIMITED TABLESPACE to U1
F. Set AUTOEXTEND ON for data files in DATA 

Show Answer

Question # 26

What is true about non-equijoin statement performance? (Choose two.) 

A. Table aliases can improve performance
B. The BETWEEN condition always performs better than using the >= and <= conditions
C. The join syntax used makes no difference to performance
D. The BETWEEN condition always performs less well than using the >= and <= conditions
E. The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax 

Show Answer

Question # 27

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is atemporary 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 initialextends 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 tobe inserted into any table in their schema
F. The sales user must have been granted the CREATE TABLE privilege 

Show Answer

Question # 28

Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)

A. The ADR base defaults to $ORACLE_HOME/rdbms/admin ifneitherDIAGNOSTIC_DEST nor ORACLE_BASE is set
B. The ADR base defaults to $ORACLE_HOME/dbs if the DIAGNOSTIC_DEST parameterand the ORACLE_BASE environment variable are not set
C. It supports diagnostics for Automatic Storage Management (ASM)
D. It supports diagnostics for Oracle Clusterware
E. It is held inside an Oracle database schema  

Show Answer