You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
Which statement is true about the INTERSECT operator used in compound queries?
Which three statements are true about advanced connection options supported by Oracle Net for
connection to Oracle Database instances? (Choose three.)
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 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?
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?
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?
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.
Which three statements are true concerning logical and physical database structures? (Choose
Which two statements are true regarding a SAVEPOINT? (Choose two.)
Which three functions are performed by dispatchers in a shared server configuration? (Choose