Blog

MCQs

Disclaimer:

Educational Use Only:

The website links provided are to be used strictly for educational and knowledge-gaining purposes only.

No Misuse:

Do not misuse the links or the information contained therein for any commercial, illegal, or unethical activities.

Respect for Websites and Businesses:

Respect the intellectual property and business interests of the websites and their owners. Do not attempt to alter, copy, or redistribute content without proper authorization.

Acknowledge Value of Knowledge:

Recognize and value the knowledge and resources shared by these websites. Use the information responsibly and ethically.

No Endorsement:

The provision of these links does not imply endorsement of the linked sites, their content, or their products and services. Users are responsible for evaluating the suitability and accuracy of the information.

User Responsibility:

By accessing these links, you agree to use the information at your own risk and to comply with all applicable laws and website terms of use.


  1. What is SQL*Net primarily used for in Oracle databases?
    a. To design database tables
    b. To communicate between client and Oracle server
    c. To create backup files
    d. To optimize SQL queries
    Answer: b. To communicate between client and Oracle serverrelationaldbdesign
  2. Which protocol is most commonly used by SQL*Net on UNIX systems?
    a. HTTP
    b. TCP/IP
    c. FTP
    d. UDP
    Answer: b. TCP/IPrelationaldbdesign
  3. What file in SQL*Net configuration defines network service names and their connect descriptors?
    a. listener.ora
    b. sqlnet.ora
    c. tnsnames.ora
    d. init.ora
    Answer: c. tnsnames.orasanfoundry+1
  4. Which Oracle Net configuration file contains parameters for client-side network environment settings?
    a. tnsnames.ora
    b. listener.ora
    c. sqlnet.ora
    d. oranet.conf
    Answer: c. sqlnet.oraplacementpreparation
  5. The Oracle Net Listener process primarily listens for:
    a. Backup requests
    b. SQL query executions
    c. Incoming client connection requests
    d. Database shutdown signals
    Answer: c. Incoming client connection requestsrelationaldbdesign
  6. What port does the default Oracle Net Listener usually listen on?
    a. 8080
    b. 1521
    c. 3306
    d. 1433
    Answer: b. 1521placementpreparation
  7. Which Oracle Net file controls the behavior of the listener, such as what services it listens for?
    a. listener.ora
    b. sqlnet.ora
    c. tnsnames.ora
    d. oranet.conf
    Answer: a. listener.oraplacementpreparation
  8. What does the acronym TNS stand for in Oracle networking?
    a. Table Network Service
    b. Transparent Network Substrate
    c. Transaction Network Server
    d. Timed Network Service
    Answer: b. Transparent Network Substraterelationaldbdesign
  9. Which Oracle Net component establishes the session between client and server?
    a. Oracle Net Listener
    b. SQLNet
    c. Oracle Instance
    d. Network Interface Card
    Answer: b. SQL
    Netrelationaldbdesign
  10. In SQL*Net architecture, the ‘listener’ runs on:
    a. Client machines only
    b. Server machines only
    c. Both client and server machines
    d. Network routers
    Answer: b. Server machines onlyplacementpreparation
  11. What is the function of the sqlnet.ora parameter named NAMES.DIRECTORY_PATH?
    a. Specifies the order of naming methods for connecting
    b. Defines the encryption level for Oracle Net
    c. Sets the port number for listener
    d. Configures backup settings
    Answer: a. Specifies the order of naming methods for connectingplacementpreparation
  12. Which naming method uses a local file to resolve service names to connect descriptors?
    a. LDAP
    b. TNSNAMES
    c. HOSTNAME
    d. ONAMES
    Answer: b. TNSNAMESplacementpreparation
  13. What is the use of the Oracle Net feature called ‘connect time failover’?
    a. To retry failed SQL queries
    b. To connect to secondary listeners if primary fails
    c. To backup database automatically
    d. To disconnect idle users
    Answer: b. To connect to secondary listeners if primary failsplacementpreparation
  14. Which parameter in sqlnet.ora enables encryption of the data sent over Oracle Net?
    a. SQLNET.ENCRYPTION_SERVER
    b. SQLNET.ENCRYPTION_CLIENT
    c. SQLNET.ENCRYPTION_TYPES
    d. All of the above
    Answer: d. All of the aboveplacementpreparation
  15. What is the maximum number of concurrent client connections a default Oracle Net Listener can handle?
    a. 100
    b. It depends on server capacity and configuration
    c. 500
    d. 50
    Answer: b. It depends on server capacity and configurationplacementpreparation
  16. Which Oracle Net naming method allows central management of service names and addresses via a directory?
    a. TNSNAMES
    b. LDAP
    c. HOSTNAME
    d. LOCAL
    Answer: b. LDAPplacementpreparation
  17. What does the Oracle Listener log file record?
    a. SQL query results
    b. User login passwords
    c. Connection requests and listener activities
    d. Database backup status
    Answer: c. Connection requests and listener activitiesplacementpreparation
  18. For Oracle Net, what is the function of “Dynamic Registration” (also called Service Registration)?
    a. To allow clients automatic discovery of listener port
    b. To automatically register database service with the listener on startup
    c. To schedule backups dynamically
    d. To create dynamic SQL queries
    Answer: b. To automatically register database service with the listener on startupplacementpreparation
  19. Which file can be used to manually configure the services that the Oracle Net Listener will listen for?
    a. tnsnames.ora
    b. sqlnet.ora
    c. listener.ora
    d. init.ora
    Answer: c. listener.oraplacementpreparation
  20. What Oracle Net component handles the network session between client and server once connected?
    a. Oracle Net Listener
    b. Oracle Net Layer (SQLNet)
    c. Database Instance
    d. Network Hardware
    Answer: b. Oracle Net Layer (SQL
    Net)relationaldbdesign
  21. What command is used to start the Oracle Net Listener?
    a. lsnrctl start
    b. sqlplus start
    c. service listener start
    d. netctl start
    Answer: a. lsnrctl startplacementpreparation
  22. If a client wants to connect to an Oracle database, what basic information must be provided in the connect string?
    a. Hostname, service name, and port number
    b. Username and password only
    c. Operating system details
    d. SQL query
    Answer: a. Hostname, service name, and port numberrelationaldbdesign
  23. What is the default protocol used by Oracle Net Listener?
    a. TCP
    b. UDP
    c. IPX/SPX
    d. HTTP
    Answer: a. TCPrelationaldbdesign
  24. Which Oracle Net component is responsible for authenticating user access during a connection request?
    a. Oracle Net Listener
    b. Database Instance
    c. SQL*Net
    d. Oracle Net Service
    Answer: b. Database Instancerelationaldbdesign
  25. What parameter in sqlnet.ora controls the timeout period for connection requests?
    a. SQLNET.INBOUND_CONNECT_TIMEOUT
    b. SQLNET.RETRY_COUNT
    c. SQLNET.DEBUG
    d. SQLNET.TIMEOUT
    Answer: a. SQLNET.INBOUND_CONNECT_TIMEOUTplacementpreparation
  26. Which SQL*Net naming method allows direct use of hostnames and port numbers without requiring a tnsnames.ora file?
    a. HOSTNAME
    b. TNSNAMES
    c. ONAMES
    d. LDAP
    Answer: a. HOSTNAMEplacementpreparation
  27. What purpose does the Oracle Net Manage tool serve?
    a. To create backups of Oracle databases
    b. To configure Oracle network environment including listener and naming methods
    c. To execute SQL queries remotely
    d. To monitor database performance
    Answer: b. To configure Oracle network environment including listener and naming methodsplacementpreparation
  28. What does the setting SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora configure?
    a. The method of user authentication such as Kerberos or Radius
    b. The encryption level on Oracle Net traffic
    c. The maximum number of clients
    d. The number of database users
    Answer: a. The method of user authentication such as Kerberos or Radiusplacementpreparation
  29. What is the significance of the Oracle Net phrase “Transparent Network Substrate”?
    a. It is a type of physical network cable
    b. It is a protocol that allows heterogeneous network communication
    c. It is a database query optimization technique
    d. It is a backup utility
    Answer: b. It is a protocol that allows heterogeneous network communicationrelationaldbdesign
  30. How does Oracle Net ensure secure communication between client and server?
    a. By using encryption and authentication parameters in sqlnet.ora
    b. By restricting all connections
    c. By using only private IP addresses
    d. By limiting connection times
    Answer: a. By using encryption and authentication parameters in sqlnet.oraplacementpreparation
  31. What does the Listener status command “lsnrctl status” display?
    a. Listener configuration files
    b. Current status of the listener including services it handles and client connections
    c. Database content
    d. Network topology
    Answer: b. Current status of the listener including services it handles and client connectionsplacementpreparation
  32. Which Oracle Net feature supports load balancing between database instances?
    a. Transparent Network Substrate
    b. Oracle RAC and listener load balancing
    c. Dynamic Service Registration
    d. Oracle GoldenGate
    Answer: b. Oracle RAC and listener load balancingplacementpreparation
  33. What does the connection string “userid=scott/tiger@orcl” specify?
    a. The user and the service name to connect to Oracle database
    b. The backup file name and location
    c. The network protocol used
    d. The storage configuration
    Answer: a. The user and the service name to connect to Oracle databaserelationaldbdesign
  34. How is failover configured in Oracle Net?
    a. By defining multiple connect descriptors or using Transparent Application Failover (TAF)
    b. By restarting the listener
    c. By reducing connection timeout
    d. By increasing RAM
    Answer: a. By defining multiple connect descriptors or using Transparent Application Failover (TAF)placementpreparation
  35. Which Oracle Net file can be edited to disable SSL or enable SSL encryption?
    a. sqlnet.ora
    b. tnsnames.ora
    c. listener.ora
    d. oranet.ini
    Answer: a. sqlnet.oraplacementpreparation
  36. What is the function of the alias in Oracle tnsnames.ora?
    a. To provide a short name for connecting to a database service
    b. To store passwords
    c. To set IP addresses dynamically
    d. To monitor network traffic
    Answer: a. To provide a short name for connecting to a database servicesanfoundry
  37. Which TNS protocol handles connection between Oracle Net and the underlying network protocols?
    a. TCP/IP
    b. SPC
    c. TNS
    d. IPX/SPX
    Answer: c. TNS (Transparent Network Substrate)relationaldbdesign
  38. The sqlnet.ora parameter TRACE_LEVEL controls:
    a. The amount of tracing information logged for debugging
    b. The number of client connections
    c. The encryption method
    d. The network speed
    Answer: a. The amount of tracing information logged for debuggingplacementpreparation
  39. What is the role of Oracle Net Services in Oracle architecture?
    a. To provide network connectivity and communication between clients and Oracle databases
    b. To schedule backups
    c. To run SQL queries
    d. To store data
    Answer: a. To provide network connectivity and communication between clients and Oracle databasesrelationaldbdesign
  40. Which Oracle Net component manages address resolution and communication over different network protocols?
    a. Transparent Network Substrate (TNS)
    b. SQL*Plus
    c. Oracle Enterprise Manager
    d. Oracle Data Guard
    Answer: a. Transparent Network Substrate (TNS)relationaldbdesign
  41. Oracle Net Services support which of the following network protocols?
    a. TCP/IP
    b. Named Pipes
    c. SDP
    d. All of the above
    Answer: d. All of the aboveplacementpreparation
  42. How do you verify the Oracle listener configuration?
    a. Using lsnrctl status command
    b. Using netstat -a command
    c. Querying v$session view
    d. Checking tnsnames.ora file only
    Answer: a. Using lsnrctl status commandplacementpreparation
  43. What does the setting SQLNET.EXPIRE_TIME in sqlnet.ora do?
    a. Specifies time interval to send a probe to check if client is alive
    b. Sets time to expire passwords
    c. Specifies time to expire listener
    d. Controls encryption timeouts
    Answer: a. Specifies time interval to send a probe to check if client is aliveplacementpreparation
  44. In Oracle Net, what does the term ‘connect descriptor’ refer to?
    a. A string that describes how to connect to a database
    b. The user’s connection statistics
    c. Network hardware specifications
    d. SQL query optimizer
    Answer: a. A string that describes how to connect to a databaseplacementpreparation
  45. Which Oracle Net listener mode allows for multiple protocols on the same port?
    a. Dedicated server mode
    b. Shared server mode
    c. Protocol Adapter interface
    d. TCP/IP Multiprotocol mode
    Answer: d. TCP/IP Multiprotocol modeplacementpreparation
  46. What is the default Oracle Net Service name for a database instance named orcl?
    a. orcl
    b. orclservice
    c. default_orcl
    d. SID
    Answer: a. orclrelationaldbdesign
  47. Which file stores the password for encrypted Oracle Net wallet authentication?
    a. ewallet.p12
    b. sqlnet.ora
    c. listener.ora
    d. tnsnames.ora
    Answer: a. ewallet.p12placementpreparation
  48. How does Oracle Net handle multi-homed client machines with multiple network interfaces?
    a. It tries interfaces in order as specified by the naming method
    b. It connects to all interfaces simultaneously
    c. It fails to connect
    d. It only uses the default interface
    Answer: a. It tries interfaces in order as specified by the naming methodplacementpreparation
  49. Which Oracle Net utility is used to diagnose connectivity issues?
    a. tnsping
    b. sqlplus
    c. lsnrctl
    d. netca
    Answer: a. tnspingplacementpreparation
  50. What is Transparent Application Failover (TAF) in Oracle Net?
    a. A feature that reroutes client connections to a surviving instance after failure automatically
    b. A method to schedule backups
    c. A SQL query optimization tool
    d. A configuration for encryption
    Answer: a. A feature that reroutes client connections to a surviving instance after failure automaticallyplacementpreparation

 

  1. https://www.relationaldbdesign.com/network-topology/module3/oracle-network-quiz.php
  2. https://www.sanfoundry.com/1000-oracle-database-questions-answers/
  3. https://www.placementpreparation.io/mcq/oracle-database/
  4. https://www.interviewbit.com/sql-mcq/
  5. https://www.placementpreparation.io/mcq/sql/
  6. https://www.sanfoundry.com/sql-server-mcqs-ado-net/
  7. https://www.interviewbit.com/computer-network-mcq/
  8. https://www.youtube.com/watch?v=GlaFb8olt6g
  9. https://www.javaguides.net/2023/09/oracle-database-quiz.html
  10. https://www.sanfoundry.com/1000-database-management-system-questions-answers/
  11. https://www.sanfoundry.com/computer-network-questions-answers/
  12. https://www.scribd.com/document/89250596/quiz1
  13. https://www.avatto.com/ugc-net-computer-science/cs-practice-questions/database/sql/
  14. https://www.w3schools.com/sql/sql_quiz.asp
  15. https://www.placementpreparation.io/mcq/computer-network/
  16. https://devgym.oracle.com/pls/apex/dg/competition/sql
  17. https://www.careerride.com/sql-server-multiple-choice-questions.aspx
  18. https://www.uninets.com/blog/computer-networks-mcq
  19. https://www.youtube.com/watch?v=xLbLHdHRzNE
  20. https://www.scribd.com/document/486916425/Computer-Networks-MCQ-4-Oracle-MCQ-1-DBMS-MCQ-3-Computer-Network-MCQ-3-Computer-PDFDrive

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!