Skip to content Oracle
1Z0-082
120 Minutes
142
Oracle Database Administration I
A: CONCAT (qty_sold, invoice_date) : requires explicit conversion
B: invoice_date = '15-march-2019' : uses implicit conversion
C: invoie_date > '01-02-2019' : uses implicit conversion
D: qty_sold BETWEEN '101' AND '110' : uses implicit conversion
E: qty_sold = '0554982' uses implicit conversion
A: All tablespaces may have one or more data files
B: The extents of a segment must always reside in the same datafile
C: A smallfile tablespace might be bigger than a bigfile tablespace
D: A segment can span multiple data files in some tablespaces
E: A segment's blocks can be of different sizes
F: A segment might have only one extent
G: Segments can span multiple tablespaces
A: The online redo logs are opened
B: The online data files are opened
C: The alert log records the execution details
D: The Oracle background processes are started
E: The initialization parameter file is read
F: The control file is read
A: Create a template that can be used to clone the database.
B: Change the server mode from dedicated to shared, and vice versa.
C: Change the character set.
D: Create an additional listener.
E: Create nonstandard block size tablespaces.
A: SELECT NULLIF(NULL, 100) FROM DUAL;
B: SELECT COALESCE (100, 'AM FROM DUAL;
C: SELECT 2TOLLIF(100, 'A') FROM DUAL;
D: SELECT NULLIF(100,100) FROM DUAL;
B: SELECT COALESCE(100, NULL, 200) FROM DUAL;
