Computer's DNS server is a recursive resolver, typically provided by the local ISP. You can mix use DNS servers from different providers, but people are used to not mixing them.
The computer's DNS is usually automatically obtained by default. If you want to make configuration, it is preferred to set both the primary and secondary DNS to ISP's DNS server, because we are closest to ISP's DNS server, and using the DNS of the network service provider can ensure the smoothness of our network to the greatest extent.
If you want to mix different DNS servers, it is also possible. For example, use ISP's DNS as the primary DNS server, and use 114 DNS as the secondary DNS server, but your network speed may be a little bit slower. However, with the development of technology, at present, some large public DNS service providers can use anycast technology to make network services unaffected by distance.