Download Oracle.1z0-082.NewDumps.2020-12-29.97q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-082 |
| Exam Name: | Oracle Database Administration I |
| Date: | Dec 29, 2020 |
| File Size: | 692 KB |
| Downloads: | 2 |
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: AC
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
Explanation:
Question 3
Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)
- Connect Time Failover requires the use of Transparent Application Failover (TAF)
- Source Routing requires the use of a name server
- Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
- Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
- Load Balancing requires the use of a name server
- Connect Time Failover requires the connect string to have two or more listener addresses configured
Correct answer: CDF
Explanation:
Reference: https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013 Reference: https://docs.oracle.com/cd/E11882_01/network.112/e41945/advcfg.htm#NETAG013
