File Info
| Exam | Oracle Database Administration I |
| Number | 1z0-082 |
| File Name | Oracle.1z0-082.VCEplus.2019-12-24.90q.tqb |
| Size | 1 MB |
| Posted | Dec 24, 2019 |
| Download | Oracle.1z0-082.VCEplus.2019-12-24.90q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
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
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: BCF
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
