Q31 Which three statements are true about external tables in Oracle 18c and later releases?
...
Q30 Which three statements are true about inner and outer joins?
...
Q29 Examine this description of the books table containing 100 rows
...
Q28 Which two statements are true about GLOBAL TEMPORARY TABLES?
...
Q27 Which three statements are true about GLOBAL TEMPORARY TABLES?
...
Q26 Which two statements are true regarding the UNION and UNION ALL operators?
...
Q25 Which two tasks can you perform using DBCA for databases?
...
Q24 Which two statements are true about the PMON background process?
...
Q23 Which two statements are true about the PMON background process?
...
Q22 Which two statements are true about the job?
...
Q21 You have been tasked to create a table for a banking application
...
Q20 Which two are true about data type conversions involving these columns in query expressions?
...
Q19 You want to display the first name and due amount as 5% of their credit limit
...
Q18. In one of your databases, the user HR has the password HRMGR
...
Q17. Which two statements are true about the configuration and use of UNDO_RETENTION with no GUATANTEED RETENTION?
...
Q16. Which two statements are true regarding a SAVEPOINT?
...
Q15. Table ORDER_ITEMS contains columns ORDER_ID, UNIT_PRICE and QUANTITY, of data type NUMBER
...
Q14. Which two statements are true about the SET VERIFY ON command?
...
Q13. Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?
...
Q12. Why does the DB01.abc.com service show unknown status?
...
Q11. Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace?
...
Q10. Which three statements are true regarding single row subqueries?
...
Q9. Which three statements are true about connection strings and service names used to connect to an Oracle database instance?
...
Q8. Which query requires explicit data type conversion?
...
Q7. Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?
...
