QUESTION 196 Choose two.Examine the ORDER_ITEMS table: Name Null? Type ----------------------------------------------------------------------------ORDER_ID PRODUCT_ID QUANTITY NOT NULL NOT NULL NOT NULL NUMBER (38) NUMBER (38) NUMBER (38) Which two queries return rows where QUANTITY is a multiple of ten?

QUESTION 197 Choose two.You have been granted the CREATE ANY INDEX system privilege.You want to create an index, owned by you , on a table in another schema to which you have been granted only the SELECT privilege. Which two are true?

QUESTION 199 Choose two.Which two statements are true regarding non-equijoins?

QUESTION 200 Choose two. Which two object privileges can be restricted to a subset of columns in a table?

QUESTION 201 Choose two.Which two are true about the USING clause when joining tables?

QUESTION 202 Choose three.Which three statements are true about Oracle Managed Files (OMF)?

QUESTION 203 Choose two.Which two statements are true about segment types in an Oracle Database?

QUESTION 204 Choose three. Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?

QUESTION 205 Choose four. Which four statements are true about the Oracle Server architecture?

QUESTION 207 Choose two.Which two Oracle database space management features require the use of locally managed tablespaces?

QUESTION 209 Choose three. Which three statements are true about using SQL∗ Plus?

QUESTION 210 Choose three.Which three activities are recorded in the database alert log?

QUESTION 211 Choose two.You must create a tablespace of non-standard block size in a new file system and plan to use this command: CREATE TABLESPACE ns_tbs DATAFILE '/u02/ oracle/data/ nstbs_f01. dbf ' SIZE 100 G BLOCKSIZE 32K; The standard block size is 8k but other non- standard block sizes will also be used. Which two are requirements for this command to succeed?

QUESTION 212 Choose three. Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

QUESTION 213 Choose two.Examine this command : SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT Which two statements are true?