1Z0-082 Dumps Update | Free 1Z0-082 Exam Questions 2023
The Oracle 1Z0-082 exam is a test for you, and to crack it you need the latest 1Z0-082 dumps.
It just so happens that we have updated the 1Z0-082 dumps, you can choose, and in order to make you better believe in our strength, we have prepared free 1Z0-082 exam questions 2023 below, from the PassITDump 1Z0-082 dumps.
Questions and answers from 1Z0-082 free dumps are 100% free and guaranteed. See our full 1Z0-082 dumps if you want to get a further understanding of the materials.
Question 1:
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
A. AUTOEXTEND is possible for the datafile
B. It must be bigger than the largest SMALLFILE tablespace
C. Additional data files may not be added
D. It will be a dictionary-managed tablespace by default
E. It will always have a 32K blocksize
Correct Answer: AC
Question 2:
Which statement is true about the INTERSECT operator used in compound queries?
A. Multiple INTERSECT operators are not possible in the same SQL statement
B. It processes NULLs in the selected columns
C. INTERSECT is of lower precedence than UNION or UNION ALL
D. It ignores NULLs
Correct Answer: B
SET operators all have the same priority in Oracle Database. NULL values are processed with set operators
Question 3:
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 enables network traffic to be routed through a firewall
D. Load Balancing can balance the number of connections to dispatchers when using a Shared 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 listener addresses configured
Correct Answer: CDF
Reference: https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
Question 4:
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 additional details 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 operating system of the database server
F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
Correct Answer: CF
Question 5:
A database is configured to use automatic undo management with temporary undo enabled.
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
Correct Answer: E
Oracle database 12c Release 1 (12.1) introduced the concept of temporary undo, allowing the undo segments for global temporary tables to be stored in the temporary tablespace. This allows global temporary tables to be used in physical standby databases and read-only databases, as well as removing the need to create redo.
16.7 Managing Temporary Undo By default, undo records for temporary tables are stored in the undo tablespace and are logged in the redo, which is the same way undo is managed for persistent tables. However, you can use the TEMP_UNDO_ENABLED initialization parameter to separate undo for temporary tables from undo for persistent tables. When this parameter is set to TRUE, the undo for temporary tables is called temporary undo.
16.7.1 About Managing Temporary Undo Temporary undo records are stored in the database\’s temporary tablespaces and thus are not logged in the redo log. When temporary undo is enabled, some of the segments used by the temporary tablespaces store the temporary undo, and these segments are called temporary undo segments.
Reference: http://www.dba-oracle.com/t_temp_undo_enabled.htm Reference: https://docs.oracle.com/database/121/ADMIN/undo.htm#ADMIN11479
Question 6:
You have been tasked to create a table for a banking application.
One of the columns must meet three requirements:
1.
Be stored in a format supporting date arithmetic without using conversion functions
2.
Store a loan period of up to 10 years
3.
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
Correct Answer: B
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 7:
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 home contains:
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 dynamic service registration
D. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Correct Answer: B
The listener forwards client requests to supported services. These services are dynamically registered with the listener. This dynamic registration feature is called service registration. The registration is performed by the Listener Registration (LREG) process. Dynamic service registration does not require any manual configuration in the listener.ora file.
Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
Question 8:
Which three statements are true concerning logical and physical database structures? (Choose three.)
A. All tablespaces may have one or more data files
B. The extents of a segment must always reside in the same datafile
C. A smallfile tablespace might be bigger than a bigfile tablespace
D. A segment can span multiple data files in some tablespaces
E. A segment\’s blocks can be of different sizes
F. A segment might have only one extent
G. Segments can span multiple tablespaces
Correct Answer: CDF
Question 9:
Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)
A. writing inbound request to the common request queue from all shared server connections
B. checking for outbound shared server responses on the common outbound response queue
C. receiving inbound requests from processes using shared server connections
D. sending each connection input request to the appropriate shared server input queue
E. broadcasting shared server session responses back to requesters on all connections
F. sending shared server session responses back to requesters on the appropriate connection
Correct Answer: ACF
Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168 An ***idle shared server process picks up*** the virtual circuit from the common queue
Question 10:
Which two statements are true about the SET VERIFY ON command? (Choose two.)
A. It can be used only in SQL*Plus
B. It displays values for variables used only in the WHERE clause of a query
C. It can be used in SQL Developer and SQL*Plus
D. It displays values for variables created by the DEFINE command
E. It displays values for variables prefixed with andand
Correct Answer: CD
Question 11:
Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)? (Choose two.)
A. PCTFREE defaults to 10% for all blocks in all segments for all compression methods
B. ASSM assigns blocks to one of four fullness categories based on what percentage of the block is allocated for rows
C. Update operations always attempt to find blocks with free space appropriate to the length of the row being updated
D. Insert operations always attempt to find blocks with free space appropriate to the length of the row being inserted
E. A block will always be eligible for inserts if the row is short enough to fit into the block
Correct Answer: BD
Characteristics of Bitmap Segment Management
Bitmap space management uses four bits inside each data block header to indicate the amount of available space in the data block. Unlike traditional space management with a fixed relink and unlink threshold, bitmap space managements allow Oracle to compare the actual row space for an INSERT with the actual available space on the data block. This enables better reuse of the available free space especially for objects with rows of highly varying size. Here are the values inside the four-bit space:
1.
Value Meaning
2.
0000 Unformatted Block
3.
0001 Block is logically full
4.
0010 <25% free space
5.
0011 >25% but <50% free space
6.
0100 > 50% but <75% free space
7.
0101 >75% free space
Table 1: Bitmap value meanings.
Question 12:
Which three instance situations are possible with the Oracle Database server without multi-tenant? (Choose three.)
A. two or more instances on separate servers all associated with one database
B. one instance on one server associated with one database
C. one instance on one server associated with two or more databases on the same server
D. one instance on one server not associated with any database
E. one instance on one server associated with two or more databases on separate servers
Correct Answer: ABD
A: RAC 2,3 or 4 nodes
B: Single instance (standalone) with database
C: one instance running multiple INDEPENDENT databases!!
D: Single instance (standalone) without database
E: absurd configuration!
Question 13:
Which two statements are true about the ORDER BY clause when used with a SQL statement containing a SET operator such as UNION? (Choose two.)
A. Column positions must be used in the ORDER BY clause
B. Only column names from the first SELECT statement in the compound query are recognized
C. The first column in the first SELECT of the compound query with the UNION operator is used by default to sort output in the absence of an ORDER BY clause
D. Each SELECT statement in the compound query must have its own ORDER BY clause
E. Each SELECT statement in the compound query can have its own ORDER BY clause
Correct Answer: BC
select employee_id,last_name “Last Name” FROM employees where employee_id=101 union select employee_id EMP_NO, last_name from employees where employee_id=113; C is correct.
Question 14:
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
Correct Answer: ABEF
Question 15:
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
Correct Answer: BCD
Reference: https://www.folkstalk.com/2012/01/oracle-single-row-functions-examples.html