Download Oracle.1z0-082.SelfTestEngine.2020-02-27.54q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-082 |
| Exam Name: | Oracle Database Administration I |
| Date: | Feb 27, 2020 |
| File Size: | 929 KB |
| Downloads: | 1 |
Demo Questions
Question 1
You execute this command:
Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBS tablespace? (Choose two.)
- AUTOEXTEND is possible for the datafile
- It must be bigger than the largest SMALLFILE tablespace
- Additional data files may not be added
- It will be a dictionary-managed tablespace by default
- It will always have a 32K blocksize
Correct answer: AB
Question 2
Which statement is true about the INTERSECT operator used in compound queries?
- Multiple INTERSECT operators are not possible in the same SQL statement
- It processes NULLs in the selected columns
- INTERSECT is of lower precedence than UNION or UNION ALL
- It ignores NULLs
Correct answer: B
Question 3
In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:
Which statement is true?
- Dynamic service registration cannot be used for this database instance
- The LREG process registers services dynamically with the LISTENER_1 listener
- LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
- There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
- The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Correct answer: C
Explanation:
Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292 Reference: https://docs.oracle.com/database/121/NETAG/listenercfg.htm#NETAG292
