1z0-082 Free Practice Test

Which two statements are true about the rules of precedence for operators? (Choose two.)

1. A. The concatenation operator | | is always evaluated before addition and subtraction in an expression
2. B. NULLS influence the precedence of operators in an expression
3. C. The + binary operator has the highest precedence in an expression in a SQL statement
4. D. Arithmetic operators with equal precedence are evaluated from left to right within an expression
5. E. Multiple parentheses can be used to override the default precedence of operators in an expression

Correct Answer: CE

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

1. A. External table files can be used for other external tables in a different database
2. B. The ORACLE_LOADER access driver can be used to unload data from a database into an external table
3. C. The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
4. D. They cannot be partitioned
5. E. The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
6. F. They support UPDATEs but not INSERTs and DELETEs

Correct Answer: ABF

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

1. A. All tablespaces may have one or more data files
2. B. The extents of a segment must always reside in the same datafile
3. C. A smallfile tablespace might be bigger than a bigfile tablespace
4. D. A segment can span multiple data files in some tablespaces
5. E. A segment’s blocks can be of different sizes
6. F. A segment might have only one extent
7. G. Segments can span multiple tablespsaces

Correct Answer: CFG

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

1. A. Tablespace free space can be viewed in VSTABLESPACE
2. B. VSTABLESPACE displays information that is contained in the controlfile about tablespaces
3. C. VSTABLESPACE displays information about tablespaces contained in the data dictionary
4. D. Tablespace free space can be viewed in DBA_TABLESPACES
5. E. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

Correct Answer: BE

Which two statements are true about single row functions? (Choose two.)

1. A. MOD : returns the quotient of a division operation
2. B. FLOOR : returns the smallest integer greater than or equal to a specified number
3. C. TRUNC : can be used to combine any number of values
4. D. CONCAT : can be used to combine any number of values
5. E. CEIL : can be used for positive and negative numbers

Correct Answer: AC