oracle 1z0-082 online test

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. SELECT * FROM customers WHERE city LIKE ‘D_%’;
• A. AUTOEXTEND is possible for the datafile
• B. SELECT * FROM customers WHERE city = ‘%D_’;
• B. It must be bigger than the largest SMALLFILE tablespace
• C. SELECT * FROM customers WHERE city LIKE ‘D_’;
• C. Additional data files may not be added
• D. SELECT * FROM customers WHERE city = ‘D_%’;
• D. It will be a dictionary-managed tablespace by default
• E. It will always have a 32K blocksize

Answer:

A,C

Question 2

Which statement is true about the INTERSECT operator used in compound queries?

• A. INTERSECT
• A. Multiple INTERSECT operators are not possible in the same SQL statement
• B. UNION ALL
• B. It processes NULLs in the selected columns
• C. UNION
• C. INTERSECT is of lower precedence than UNION or UNION ALL
• D. SUBTRACT
• D. It ignores NULLs
• E. MINUS

Answer:

B

Question 3

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

• A. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
• B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• B. Source Routing requires the use of a name server
• C. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
• D. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
• E. A GLOBAL TEMPORARY TABLE’S definition is available to multiple sessions.
• E. Load Balancing requires the use of a name server
• F. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• F. Connect Time Failover requires the connect string to have two or more listener addresses configured

Answer:

CDF

Explanation:
https://docs.oracle.com/en/database/oracle/oracle-database/12.2/rilin/shared-server-configuration-for-an-oracle-rac-database.html#GUID-2EFBA08D-FEEE-407F-BC42-E548DA946DF9

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. Views can be updated without the need to re-grant privileges on the view
• A. CURRENT_TIMESTAMP returns the same date and time as SYSDATE with additional details of fractional seconds
• B. Tables in the defining query of a view must always exist in order to create the view
• B. SYSDATE can be queried only from the DUAL table
• C. The WITH CHECK clause prevents certain rows from being displayed when querying the view
• C. CURRENT_DATE returns the current date and time as per the session time zone
• D. Data Manipulation Language (DML) can always be used on views
• D. SYSDATE can be used in expressions only if the default date format is DD-MON-RR
• E. Inserting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• E. SYSDATE and CURRENT_DATE return the current date and time set for the operating system of the database server
• F. Deleting one or more rows using a view whose defining query contains a GROUP BY clause will cause an error
• F. CURRENT_TIMESTAMP returns the same date as CURRENT_DATE
• G. The WITH CHECK clause prevents certain rows from being updated or inserted

Answer:

CF

Explanation:
https://www.w3resource.com/oracle/datetime-functions/oracle-current_timestamp-function.php

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

Answer:

E

Explanation:
http://www.dba-oracle.com/t_temp_undo_enabled.htm

Question 6

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. It is available only when the database is open
• A. INTERVAL YEAR TO MONTH
• B. It can be used to perform database recovery
• B. INTERVAL DAY TO SECOND
• C. The same port number can be used for Database Express configurations for databases on different hosts
• C. TIMESTAMP WITH LOCAL TIMEZONE
• D. It can be used to switch a database into ARCHIVELOGMODE
• D. TIMESTAMP
• E. The same port number can be used for multiple Database Express configurations for multiple databases on the same host
• E. TIMESTAMP WITH TIMEZONE

Answer:

B

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. It gives an error because the ALL keyword is not valid
• A. Dynamic service registration cannot be used for this database instance
• B. It gives an error because the GROUP BY clause is not valid
• B. The LREG process registers services dynamically with the LISTENER_1 listener
• C. It executes successfully but does not give the required result
• C. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• D. It executes successfully and gives the required result
• 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

Answer:

B

Explanation:
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
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. External table files can be used for other external tables in a different database
• A. All tablespaces may have one or more data files
• B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• B. The extents of a segment must always reside in the same datafile
• C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
• C. A smallfile tablespace might be bigger than a bigfile tablespace
• D. They cannot be partitioned
• D. A segment can span multiple data files in some tablespaces
• E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• E. A segment’s blocks can be of different sizes
• F. They support UPDATEs but not INSERTs and DELETEs
• F. A segment might have only one extent
• G. Segments can span multiple tablespaces

Answer:

BCF

Question 9

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

• A. It can be used only in SQL*Plus
• A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statement
• B. It displays values for variables used only in the WHERE clause of a query
• B. Rolling back to a SAVEPOINT can undo a TRUNCATE statement
• C. It can be used in SQL Developer and SQL*Plus
• C. Only one SAVEPOINT may be issued in a transaction
• D. It displays values for variables created by the DEFINE command
• D. A SAVEPOINT does not issue a COMMIT
• E. It displays values for variables prefixed with &&
• E. Rolling back to a SAVEPOINT can undo a DELETE statement

Answer:

D,E

Question 10

Which three functions are performed by dispatchers in a shared server configuration? (Choose
three.)

• A. You can no longer monitor it
• A. writing inbound request to the common request queue from all shared server connections
• B. You can reattach to it and monitor it
• B. checking for outbound shared server responses on the common outbound response queue
• C. It is paused and can be resumed
• C. receiving inbound requests from processes using shared server connections
• D. It continues to run in the background
• D. sending each connection input request to the appropriate shared server input queue
• E. It terminates
• 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

Answer:

A,C,F

Explanation:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/manproc001.htm#ADMIN11168