QUESTION 231 Choose two.Which two statements are true regarding indexes?

QUESTION 232 Choose two.Which two are true?

QUESTION 235 Choose three Examine this command. STARTUP PFILE= ' D : \ oracle12c\ oracle\ admin\ orcl\ pfile \ pfileinitorcl. ora ORACLE instance started. Total system Global Area 51 17049968 bytes Fixed Size 90 3 8 9 6 0 bytes Variable Size Database Buffers Redo Buffers Database mounted. Database opened. Now examine these statements.SHOW PARAMETER cursor_sharing; TYPE VALUE NAME --------------------------------cursor_sharing string EXACT ALTER SYSTEM SET Cursor_sharing=FORCE; Which three are true about the result of processing the last statement?

QUESTION 236 You execute this command: Sufficient storage is available in filesystem /u0 1 . Which two statements are true about the BIG_TBS tablespace? (Choose two .)

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

QUESTION 239 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. )

Which three statements are true concerning logical and physical database structures? (Choose three. )

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

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

Which two statements are true about the SET VERIFY ON command? (Choose two. )

Which three statements are true about a self-join? (Choose three. )

Examine this command: Which two statements are true? (Choose two.)

Which three statements are true about dropping and unused columns in an Oracle database? (Choose three. )

Examine the following command: CREATE TABLE ( Prod_id number(4), Prod_ name varchar2 (20), Category_id number(30), Quantity_ on_ hand number (3) INVISIBLE); Which three statements are true about using an invisible column in t he PRODUCTS table?

Choose two: Examine the structure of the DEPARTMENTS table You execute the following command: SQL> ALTER TABLE departments SET UNUSED (country); Which two statements are true?