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.
- 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 - 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 - 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 - 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 - 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 - What port does the default Oracle Net Listener usually listen on?
a. 8080
b. 1521
c. 3306
d. 1433
Answer: b. 1521placementpreparation - 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 - 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 - 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. SQLNetrelationaldbdesign - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 (SQLNet)relationaldbdesign - 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 - 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 - What is the default protocol used by Oracle Net Listener?
a. TCP
b. UDP
c. IPX/SPX
d. HTTP
Answer: a. TCPrelationaldbdesign - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - 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 - Which Oracle Net utility is used to diagnose connectivity issues?
a. tnsping
b. sqlplus
c. lsnrctl
d. netca
Answer: a. tnspingplacementpreparation - 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
- https://www.relationaldbdesign.com/network-topology/module3/oracle-network-quiz.php
- https://www.sanfoundry.com/1000-oracle-database-questions-answers/
- https://www.placementpreparation.io/mcq/oracle-database/
- https://www.interviewbit.com/sql-mcq/
- https://www.placementpreparation.io/mcq/sql/
- https://www.sanfoundry.com/sql-server-mcqs-ado-net/
- https://www.interviewbit.com/computer-network-mcq/
- https://www.youtube.com/watch?v=GlaFb8olt6g
- https://www.javaguides.net/2023/09/oracle-database-quiz.html
- https://www.sanfoundry.com/1000-database-management-system-questions-answers/
- https://www.sanfoundry.com/computer-network-questions-answers/
- https://www.scribd.com/document/89250596/quiz1
- https://www.avatto.com/ugc-net-computer-science/cs-practice-questions/database/sql/
- https://www.w3schools.com/sql/sql_quiz.asp
- https://www.placementpreparation.io/mcq/computer-network/
- https://devgym.oracle.com/pls/apex/dg/competition/sql
- https://www.careerride.com/sql-server-multiple-choice-questions.aspx
- https://www.uninets.com/blog/computer-networks-mcq
- https://www.youtube.com/watch?v=xLbLHdHRzNE
- https://www.scribd.com/document/486916425/Computer-Networks-MCQ-4-Oracle-MCQ-1-DBMS-MCQ-3-Computer-Network-MCQ-3-Computer-PDFDrive