Explore topic-wise MCQs in Oracle (MCQ) questions and answers.

This section includes 15 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.

1.

Which feature of database reduces the amount of data transfer required between sites when a transaction retrieves data from remote tables and referenced in a distributed SQL statement?

A. Transparency in a distributed database system
B. Remote procedure calls
C. Distributed query optimization
D. All mentioned above
Answer» D. All mentioned above
Discussion
2.

In Rewriting your query to access the remote database once it is achieved by using collocated inline views, which term is used for defining two or more tables that are located in the same database?

A. Collocated
B. Inline view
C. Collocated inline view
D. None of the above
Answer» B. Inline view
Discussion
3.

Which of the agent is used so that the Generic connectivity enables you to connect to a non-oracle database data stores?

A. A Heterogeneous Services ODBC agent
B. A Heterogeneous Services OLEDB agent
C. Both A & B
D. None of the above
Answer» D. None of the above
Discussion
4.

All users on the local database can access the remote database and all use the same userid/password to make the connection. How can user access the remote database through the link?

A. Link type =Public, Authentication = Yes
B. Link type =Public, Authentication = No
C. Link type =Private, Authentication = No
D. Link type =Private, Authentication = Yes
Answer» B. Link type =Public, Authentication = No
Discussion
5.

If your distributed query contains ___________, then the cost-based optimization is not effective.

A. Aggregates
B. Subqueries
C. Complex SQL
D. All mentioned above
Answer» E.
Discussion
6.

Which of these is used to process information requests in the distributed databases?

A. Homogeneous Distributed Database Systems
B. Heterogeneous Distributed Database Systems
C. Client/Server Database Architecture
D. All mentioned above
Answer» D. All mentioned above
Discussion
7.

If a part of a distributed statement fails, due to an integrity constraint violation then the database returns which error number?

A. ORA-02055
B. ORA-02067
C. Both A & B
D. None of the above
Answer» B. ORA-02067
Discussion
8.

What is site autonomy?

A. Each server participating in a distributed database is administered independently from all other databases.
B. Nodes of the system cannot mirror the logical organization of companies or groups that need to maintain independence.
C. Local administrators cannot control corresponding local data. Therefore, each database administrator s domain of responsibility is smaller and more manageable.
D. Administrators cannot recover from isolated system failures independently from other nodes in the system.
Answer» B. Nodes of the system cannot mirror the logical organization of companies or groups that need to maintain independence.
Discussion
9.

In distributed SQL statements, which of the following retrieves information from two or more nodes?

A. Distributed query
B. Distributed update
C. Both A & B
D. None of the above
Answer» B. Distributed update
Discussion
10.

The REMOTE_OS_AUTHENT parameter operates an externally-authenticated user and it can connect to the remote database using a connected user database link, Select the correct parameter to set.

A. REMOTE_OS_AUTHENT = false
B. REMOTE_OS_AUTHENT = true
C. Both A & B
D. None of the above
Answer» C. Both A & B
Discussion
11.

A set of databases in a distributed system that can appear to applications as a single data source known as ________.

A. Distributed database
B. Distributed processing
C. Both A & B
D. None of the above
Answer» B. Distributed processing
Discussion
12.

To enable cost-based optimization set the OPTIMIZER_MODE initialization parameter to CHOOSE or COST, you can set this parameter by using __________.

A. Modifying the OPTIMIZER_MODE parameter in the initialization parameter file
B. Setting it at session level by issuing an ALTER SESSION statement
C. Both A & B
D. None of the above
Answer» D. None of the above
Discussion
13.

How many types of database links does the oracle database lets you create?

A. 2
B. 3
C. 4
D. 5
Answer» C. 4
Discussion
14.

Which user type in a database link has username/password as part of the link definition?

A. Current user
B. Connected user
C. Fixed user
D. Both A & B
Answer» D. Both A & B
Discussion
15.

Where is the file UTLXPLAN.SQL by default located?

A. $ORACLE_HOME/rdbms/admin directory
B. $ORACLE_HOME/rdbms/admin/network directory
C. $ORACLE_HOME/rdbms/ directory
D. $ORACLE_HOME/rdbms/admin/dbs directory
Answer» B. $ORACLE_HOME/rdbms/admin/network directory
Discussion