Oracle MCQ (Multiple Choice Questions) With Answers, Oracle Online Quiz

1 .

When the Initial release date of ORACLE?

A)

1973

B)

1979

C)

1982

D)

1987

Correct Answer : Option (B) : 1979

Explanation :

Larry Ellison and his two friends and former co-workers, Bob Miner and Ed Oates, started a consultancy called Software Development Laboratories (SDL) in 1977. SDL developed the original version of the Oracle software. The name Oracle comes from the code-name of a CIA-funded project Ellison had worked on while formerly employed by Ampex.

Initial Release Date : Oracle v2.3 - 1979

2 .

Oracle database is a ?

A)

End-user Database

B)

Commercial Database

C)

Centralised Database

D)

Relational Database

Correct Answer : Option (D) : Relational Database

Explanation : Oracle Database is a Relational Database Management System. It is known as Oracle Database, OracleDB or simply Oracle.

3 .

What is Oracle?

A)

Oracle is a Database

B)

Oracle is a Sripting Language

C)

Oracle is an Operating System

D)

Oracle is a Programming Language

Correct Answer : Option (A) : Oracle is a Database

4 .

Which of the following database was designed first for enterprise grid computing?

A)

SQL

B)

MongoDB

C)

Oracle database

D)

Google database

Correct Answer : Option (C) : Oracle database

Explanation : Oracle was the first database to be created specifically for enterprise grid computing and data warehousing. The most versatile and cost-effective way to handle information and applications is through enterprise grid computing.

5 .

How many editions of the Oracle database there?

A)

3

B)

4

C)

5

D)

6

Correct Answer : Option (C) : 5

Explanation : There Five editions of the Oracle database :

* Oracle Database Standard Edition One

* Oracle Database Standard Edition

* Oracle Database Enterprise Edition

* Oracle Database Express Edition

* Oracle Database Personal Edition

Source : Oracle

6 .

A ________ is a single field or combination of fields that contains a unique record.

A)

Index

B)

Primary key

C)

Foreign Key

D)

Compound Key

Correct Answer : Option (B) : Primary key

Explanation : A primary key is a single field or combination of fields that contains a unique record. It must be filled. None of the field of primary key can contain a null value. A table can have only one primary key.

7 .

A ________ is created by a query joining one or more tables.

A)

View

B)

Trigger

C)

Procedure

D)

Both (B) and (C)

Correct Answer : Option (A) : View

Explanation : A view is created by a query joining one or more tables.

8 .

Which query is used to add, modify, delete or drop colums of a table?

A)

Drop

B)

Update

C)

Truncate

D)

Alter

Correct Answer : Option (D) : Alter

Explanation : Oracle alter query is used to add, modify, delete or drop colums of a table.

9 .

What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?

A)

Instance Failure

B)

Media Failure

C)

Rollback failure

D)

Application failure

Correct Answer : Option (A) : Instance Failure

10 .

Which statement about sequences is not true?

A)

NextVal and CurrVal are both sequence methods.

B)

Sequences are most often used to provide values for surrogate keys.

C)

Sequences guarantee valid surrogate key values.

D)

A sequence is an object that generates a sequential series of unique numbers.

Correct Answer : Option (C) : Sequences guarantee valid surrogate key values.

11 .

Which prefixes are available to Oracle triggers?

A)

:new only

B)

:old only

C)

Both :new and :old

D)

Neither :new nor :old

Correct Answer : Option (C) : Both :new and :old

12 .

Which of the following is not a Oracle Database feature?

A)

Analytics

B)

Scalability

C)

Availability

D)

None of the above

Correct Answer : Option (D) : None of the above

Explanation :

The features of Oracle Database features are :

i) Availability : Because of the Oracle Data Guard feature, it ensures that databases are always available.

ii) Security : To prevent unwanted access, Oracle has a system for controlling and accessing the database.

iii) Scalability : It has capabilities such as RAC (Real Application Cluster) and Portability, which allow an Oracle database to scale up or down depending on usage.

iv) Performance : Oracle Advanced Compression, Oracle Database In-Memory, Oracle Real Application Testing, and Oracle Times Ten Application-Tier Database Cache are some of the speed enhancement solutions available.

v) Analytics : Oracle has the following solutions in the field of analytics:

a) OLAP (Oracle Analytic Processing)

b) Oracle Advanced Analytics

vi) Management : Oracle Multitenant is a database management system that combines a single container database with a number of pluggable databases in a single unified design.

13 .

Which of the following is an advantage of Oracle database?

A)

Portability

B)

Performance

C)

Flashback Technology

D)

All of the above

Correct Answer : Option (D) : All of the above

Explanation :

The following are the advantages of an Oracle database :

Performance : Oracle has procedures and principles that help us to get high levels of database performance.

Portability : The Oracle database can be ported on all different platforms than any of its competitors.

Backup and Recovery : Using the Oracle database, it is simple to perform a rapid recovery using RMAN (Recovery Manager) feature.

PL/SQL : One of the greatest benefits of using the Oracle database is to support PL/SQL extension for procedural programming.

Multiple Database : Oracle database allows several database instances management on a single server.

Flashback Technology : It enables user to recover data that has been wrongly deleted or lost due to human errors.

14 .

What is Oracle database used for?

A)

Creating backup for data

B)

Store and retrieve relevant data

C)

Accessing database servers

D)

None of the above

Correct Answer : Option (B) : Store and retrieve relevant data

Explanation : An Oracle database is a collection of data that is viewed as if it were a single entity. A database’s main goal is to store and retrieve relevant data. The key to tackling information management issues is a database server.

15 .

Which of the following is a disadvantage of Oracle database?

A)

Cost

B)

Complexity

C)

Difficult to Manage

D)

All of the above

Correct Answer : Option (D) : All of the above

Explanation :

The disadvantages of the Oracle database are :

Cost : Oracle products are extremely expensive when compared to alternative databases.
Complexity : Oracle is not advised for use by those who are not technically aware and have just rudimentary knowledge of the Oracle Database.
Difficult to manage : Oracle databases are difficult to manage when it comes to specific operations.

16 .

In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

A)

To see the errors, enter SHOW ERRORS in SQL*Plus.

B)

SQL*Plus will automatically show the errors to you.

C)

If there are no syntax errors, you will receive the message "NO ERRORS"

D)

The line numbers reported match the line numbers you see in your text editor.

Correct Answer : Option (A) : To see the errors, enter SHOW ERRORS in SQL*Plus.

17 .

Which of the following is not true about indexes?

A)

Indexes are created to enforce uniqueness on columns.

B)

Indexes are created to enable fast retrieval by column values.

C)

Indexes are created with the ALTER TABLE command.

D)

Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.

Correct Answer : Option (C) : Indexes are created with the ALTER TABLE command.

18 .

In Oracle Database 12c, the RENAME statement is used trename which of the following schema objects?

A)

Table

B)

View

C)

Sequence

D)

All of the above

Correct Answer : Option (D) : All of the above

19 .

Which of the following components comprise an Oracle architecture?

A)

Datafiles

B)

Tablespaces

C)

Database Related Background Processes

D)

All of the above

Correct Answer : Option (D) : All of the above

Explanation : Oracle architecture consists of DB process, Table space, Datafiles.

20 .

Which of the following area of PGA stores binding variables and run-time buffers information?

A)

SQL area

B)

Private SQL area

C)

Stack space

D)

Session area

Correct Answer : Option (B) : Private SQL area

Explanation : PGA (Program Global Area) is a non-shared memory region that contains data and control information exclusively for use by an Oracle process.The PGA is created by Oracle Database when an Oracle process is started.

21 .

Which of the following is the smallest unit of storage in an Oracle database?

A)

Data Block

B)

Extent

C)

Segment

D)

Data File

Correct Answer : Option (A) : Data Block

Explanation : The logical units of database space allocation are data blocks.

22 .

Which clause is used to remove the duplicate records from the result set?

A)

Like

B)

Where

C)

Distinct

D)

Group by

Correct Answer : Option (C) : Distinct

Explanation : Oracle DISTINCT clause is used to remove the duplicate records from the result set. It is only used with SELECT statement.

23 .

How many CREATE TRIGGER statements are there?

A)

4

B)

5

C)

6

D)

7

Correct Answer : Option (C) : 6

Explanation : There are six CREATE TRIGGER statements according to their firing points : BEFORE INSERT TRIGGER, BEFORE UPDATE TRIGGER, BEFORE DELETE TRIGGER, AFTER INSERT TRIGGER, AFTER UPDATE TRIGGER and AFTER DELETE TRIGGER.

24 .

Which is the smallest unit of storage in an Oracle database?

A)

Extent

B)

Segment

C)

Data File

D)

Data Block

Correct Answer : Option (D) : Data Block

Explanation : Data Block is the smallest unit of storage in an Oracle Database.

25 .

Which of the following is another name of Oracle database's design?

A)

Database Instance

B)

Database Schema

C)

Database Abstraction

D)

None of the Above

Correct Answer : Option (B) : Database Schema

Explanation : Oracle database’s design is done on the schema level.

26 .

Which of the following is used to logically group data together?

A)

Object

B)

Datafiles

C)

Database

D)

Tablespace

Correct Answer : Option (D) : Tablespace

Explanation : Oracle database consists of one or more logical storage units called tablespaces.

27 .

Which of the following package procedure is UNRESTRICTED in Oracle?

A)

USER_EXIT

B)

CALL_INPUT

C)

CLEAR_BLOCK

D)

EXECUTE_QUERY

Correct Answer : Option (A) : USER_EXIT

Explanation : A user exit is a C subroutine and called by Oracle Forms to do special-purpose processing.It can display messages on the Oracle Forms status line, get and set field values, do high-speed computations and table look-ups, and manipulate Oracle data.

28 .

Oracle server configuration is dedicated for

A)

Many server processes â€“ One user process

B)

One server process â€“ Many user processes

C)

One server process â€“ One user process

D)

Many server processes â€“ Many user processes

Correct Answer : Option (C) : One server process â€“ One user process

Explanation : Single-process Oracle is a database system in which all Oracle code is executed by one process. Different processes are not used to separate execution of the parts of Oracle and the client application program. Instead, all code of Oracle and the single user’s database application is executed by a single process.

29 .

Which of the following is not true of SQL views?

A)

Oracle views can by queried.

B)

Oracle views are created using the standard SQL-92 CREATE VIEW command.

C)

Oracle views cannot use the ORDER BY clause in view definitions.

D)

The SQL-92 standard does not allow the use of the ORDER BY clause in view definitions.

Correct Answer : Option (C) : Oracle views cannot use the ORDER BY clause in view definitions.

30 .

SQL*Plus will finish the statement and execute it when the user types in this:

A)

A colon ( : ) followed by [Enter].

B)

A semicolon ( ; ) followed by [Enter].

C)

A period ( . ) followed by [Enter].

D)

A left slash ( \ ) followed by [Enter].

Correct Answer : Option (B) : A semicolon ( ; ) followed by [Enter].

31 .

Which of the following is NOT an Oracle-supported trigger?

A)

AFTER

B)

DURING

C)

BEFORE

D)

INSTEAD OF

Correct Answer : Option (B) : DURING

32 .

After a table has been created, its structure can be modified using the SQL command:

A)

CHANGE TABLE [TableName].

B)

MODIFY TABLE [TableName].

C)

UPDATE TABLE [TableName].

D)

ALTER TABLE [TableName].

Correct Answer : Option (D) : ALTER TABLE [TableName].

33 .

Which schema object instructs Oracle to connect to remotely access an object of a database?

A)

Data Link

B)

Sequence

C)

Remote Link

D)

Database Link

Correct Answer : Option (A) : Data Link

Explanation : A DATABASE LINK value references a resource outside the underlying data source through a URL.

34 .

When a transaction modifies the database, Oracle copies the original data before modifying it. What is the original copy of the modified data called?

A)

Redo Data

B)

Archive Data

C)

Undo Data

D)

Undone Data

Correct Answer : Option (C) : Undo Data

Explanation : Before transaction happen the Oracle kept the files in Undo Data to overcome form any failure.

35 .

Which of the following is referred to as the language used application programs to request data from the DBMS?

A)

DDL

B)

DML

C)

Query language

D)

All of the above

Correct Answer : Option (B) : DML

Explanation : The effect of a DML statement is not permanent until you commit the transaction that includes it. A transaction is a sequence of SQL statements that Oracle Database treats as a unit.

36 .

Which of the following RDBMS supports full fledged client server application development?

A)

Ingress

B)

dBase V

C)

Oracle 7.1

D)

FoxPro 2.1

Correct Answer : Option (C) : Oracle 7.1

Explanation : Oracle 7.1 support the all server-client application development.

37 .

Which of the following is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

A)

DDL and DML

B)

Data Definition Language(DDL)

C)

Data Manipulation Language(DML)

D)

None of the above

Correct Answer : Option (B) : Data Definition Language(DDL)

Explanation : The Data Definition Language is used to manage table and index structure.CREATE, ALTER, RENAME, DROP and TRUNCATE statements are the names of few data definition elements.

38 .

Oracle database produced and marketed by?

A)

IBM

B)

Google

C)

Facebook

D)

Oracle Corporation

Correct Answer : Option (D) : Oracle Corporation

Explanation : It is produced and marketed by Oracle Corporation.

39 .

Oracle DB runs on the?

A)

Unix

B)

Linux

C)

Windows

D)

All of the above

Correct Answer : Option (D) : All of the above

Explanation : Oracle DB runs on the most major platforms like Windows, UNIX, Linux and Mac OS.

40 .

In Oracle, total number of columns cannot be more than?

A)

32

B)

64

C)

128

D)

254

Correct Answer : Option (A) : 32

Explanation : In Oracle, total number of columns cannot be more than 32.

41 .

Which tables are defined and scoped to the session in which you created it?

A)

Global Temporary tables

B)

Global Permanent tables

C)

Local Temporary tables

D)

Local Permanent tables

Correct Answer : Option (C) : Local Temporary tables

Explanation : local temporary tables are distinct within modules. These tables are defined and scoped to the session in which you created it.

42 .

Which command is used to fetch records from database?

A)

Get

B)

Select

C)

Use

D)

Fetch

Correct Answer : Option (B) : Select

Explanation :

Oracle select query is used to fetch records from database. For example:

SELECT * from customers;

43 .

Which of the following is done to give a temporary to a column or table?

A)

Union

B)

Having

C)

Aliases

D)

Intersect

Correct Answer : Option (C) : Aliases

Explanation : In Oracle, aliasing can also be done in column name as well as in table name. Aliasing is done to give a temporary to a column or table.

44 .

A ________ is a group of PL/SQL statements that can be called by name.

A)

View

B)

Trigger

C)

Function

D)

Procedure

Correct Answer : Option (D) : Procedure

Explanation : A procedure is a group of PL/SQL statements that can be called by name. The call specification (sometimes called call spec) specifies a java method or a third-generation language routine so that it can be called from SQL and PL/SQL.

45 .

Which processes is an instance made of Oracle?

A)

Data processes

B)

Memory processes

C)

Oracle background processes

D)

All of the above

Correct Answer : Option (D) : All of the above

Explanation : Oracle background processes is an instance made of Oracle.

46 .

The language used application programs to request data from the DBMS is referred to as __________

A)

DDL

B)

DML

C)

TDL

D)

TCL

Correct Answer : Option (A) : DDL

Explanation : Data Manipulation Language (DML) statements are used for managing data in database. DML commands are not auto-committed. It means changes made by DML command are not permanent to database, it can be rolled back.

47 .

The redo log buffer and Shared pool are elements of?

A)

PGA

B)

SGA

C)

Buffer cache

D)

PGA and Buffer cache

Correct Answer : Option (B) : SGA

Explanation : SGA (System Global Area) contains Shared Pool, Database Buffer Cache, Java Pool, redo Log Buffer.

48 .

What is the result of the following 'ORA'NULL'CLE'?

A)

Error

B)

NULL

C)

ORACLE

D)

ORA CLE

Correct Answer : Option (C) : ORACLE

Explanation : In Oracle NULL values represent missing unknown data.

49 .

Which of the following object types below cannot be replicated?

A)

Data

B)

View

C)

Sequence

D)

Trigger

Correct Answer : Option (C) : Sequence

Explanation : Use the CREATE SEQUENCE statement to create a sequence, which is a database object from which multiple users may generate unique integers. You can use sequences to automatically generate primary key values.

50 .

Which of the following is the oldest database model?

A)

Network

B)

Physical

C)

Deductive

D)

Relational

Correct Answer : Option (A) : Network

Explanation : Network Model is the oldest database model.

51 .

Which of the following is not a component of a data warehouse?

A)

Data metadata

B)

Data warehouse data

C)

Data extraction/cleaning/preparation programs

D)

None of the above

Correct Answer : Option (A) : Data metadata

Explanation : Data warehouse is not deal with the Data metadata.

52 .

Which of the following is not a Key in SQL Server?

A)

Foreign

B)

Primary

C)

Alternate

D)

Secondary

Correct Answer : Option (D) : Secondary

Explanation : Except Secondary all are the types of key in SQL server.

53 .

Which of the following is record based logical model?

A)

E-R Model

B)

Network Model

C)

Object oriented model

D)

None of the above

Correct Answer : Option (B) : Network Model

Explanation : The network model is a database model conceived as a flexible way of representing objects and their relationships.

54 .

Which of the following command is used to SELECT only one copy of each set of duplicable rows in SQL?

A)

SELECT DIFFERENT

B)

SELECT UNIQUE

C)

SELECT DISTINCT

D)

All of the above

Correct Answer : Option (C) : SELECT DISTINCT

Explanation : The keyword allows us to grab all information from a column (or columns) on a table. This, of course, necessarily means that there will be redundancies. What if we only want to select each distinct element? This is easy way to accomplish in SQL. All we need to do is that to add after The syntax is: SELECT DISTINCT column_name FROM table_name;.

55 .

Which of the following is/are the DDL statements?

A)

Alter

B)

Drop

C)

Create

D)

All of the above

Correct Answer : Option (D) : All of the above

Explanation : All the mentioned commands are the part of DDL statements.

56 .

command to use iscommand is used for removing a table and all its data from the database?

A)

Drop table command

B)

Create command

C)

Alter table command

D)

All of the above

Correct Answer : Option (A) : Drop table command

Explanation : The DROP INDEX statement is used to delete an index in a table.

57 .

Which of the following is not a type of SQL statement?

A)

Data Control Language (DCL)

B)

Data Definition Language (DDL)

C)

Data Manipulation Language (DML)

D)

Data Communication Language (DCL)

Correct Answer : Option (D) : Data Communication Language (DCL)

Explanation : Data Communication Language (DCL) is not a type of SQL statement.

58 .

Which of the following command is used to obtain the structure of an Oracle table?

A)

STRUCTURE [TableName].

B)

DESCRIBE [TableName].

C)

DESC TABLE [TableName].

D)

DESCRIBE STRUCTURE [TableName].

Correct Answer : Option (B) : DESCRIBE [TableName].

Explanation : DESCRIBE command is used to get the structure of the Oracle Table.

59 .

Which of the following is not included in DML (Data Manipulation Language)?

A)

INSERT

B)

UPDATE

C)

CREATE

D)

DELETE

Correct Answer : Option (C) : CREATE

Explanation : The CREATE TABLE statement is used to create a table in a database.Tables are organized into rows and columns; and each table must have a name.

60 .

Which of the following keyword is used with Data Control Language (DCL) statements?

A)

INSERT

B)

GRANT

C)

SELECT

D)

DELETE

Correct Answer : Option (B) : GRANT

Explanation : GRANT is the keyword which is used with Data Control Language statements.

61 .

While creating a database password file in Oracle Database 12c, which of the given administrative privileges are supported. if we set the FORMAT argument tvalue. legacy?

A)

SYSDBA

B)

SYSOPER

C)

SYSBACKUP

D)

Both (A) and (B)

Correct Answer : Option (D) : Both (A) and (B)

62 .

Which of the following statements can be used tenable or disable triggers in Oracle Database 12C?

A)

ALTER TRIGGER trig1 ENABLE;

B)

ALTER TABLE tabâ€˜l DISABLE ALL TRIGGERS;

C)

Both (A) and (B)

D)

ALTER TABLE tab2 ENABLE TRIGGERS;

Correct Answer : Option (C) : Both (A) and (B)

63 .

While working with Oracle Database 12c. which of the following transaction control statements are supported in distributed transaction?

A)

SAVEPOINT

B)

COMMIT

C)

ROLLBACK

D)

Both (B) and (C)

Correct Answer : Option (D) : Both (B) and (C)

64 .

What is the permissible range of values for DDL_LOCK_TIMEOUT parameter tenable blocking DDL statements twait for locks?

A)

t1,000,000 seconds

B)

t100;000 seconds

C)

t10.000 seconds

D)

t1.000 seconds

Correct Answer : Option (A) : t1,000,000 seconds

65 .

Which of the following are the new features in Oracle Database 12c?

A)

Big Table Cache

B)

ln-Memory Column Store

C)

Force Full Database Caching Mode

D)

All of the above

Correct Answer : Option (D) : All of the above

66 .

Which of the following are included in the control fâ€Œile of Oracle Database 12c?

A)

Name of the database

B)

Checkpoint information

C)

Current log sequence number

D)

All of the above

Correct Answer : Option (D) : All of the above

67 .

In Oracle 12c Database. which of the following administrative privileges allow(s) you tdrop the database?

A)

SYSDBA

B)

SYSBACKUP

C)

Both (A) and (B)

D)

SYSDG

Correct Answer : Option (C) : Both (A) and (B)

68 .

In Oracle Database 12c. which of the following indexes are specific tan application/cartridge?

A)

B-tree cluster indexes

B)

Domain indexes

C)

Hash cluster indexes

D)

Global and local indexes

Correct Answer : Option (B) : Domain indexes

69 .

While managing jobs, the value of which of the following additional attributes must be set, if you want tcreate an eventâ€”based job in Oracle Database 12C?

A)

queue_spec

B)

event_condition

C)

Both a and b must be set

D)

Neither a nor b is required tbe set

Correct Answer : Option (C) : Both a and b must be set

70 .

In Oracle 12c database, the user session becomes public when you connect with the database as:

A)

SYSOPER administrative privilege

B)

SYSKM administrative privilege

C)

SYSDBA administrative privilege

D)

SYSBACKUP administrative privilege

Correct Answer : Option (A) : SYSOPER administrative privilege

71 .

In Oracle Database 12c, which of the following types of operations are NOT permissible in distributed transactions?

A)

Transaction Control Statements

B)

Data Control Language (DCL) transactions

C)

Data Defâ€Œinition Language (DDL) transactions

D)

Data Manipulation Language (DML) transactions

Correct Answer : Option (B) : Data Control Language (DCL) transactions

72 .

Which of the following statements can be used to change the open mode of a current PDB to mounted?

A)

ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;

B)

ALTER PLUGGABLE DATABASE OPEN READ ONLY;

C)

ALTER PLUGGABLE DATABASE OPEN FORCE:

D)

ALTER PLUGGABLE DATABASE OPEN UPGRADE;

Correct Answer : Option (A) : ALTER PLUGGABLE DATABASE CLOSE IMMEDIATE;

73 .

In Oracle Database 12c, what is the minimum size permitted for a redo log file?

A)

1 GB

B)

512 MB

C)

12 MB

D)

4 MB

Correct Answer : Option (D) : 4 MB

74 .

In Oracle Database 12c, which of the following statements is NOT correct about Temporary tablespaces?

A)

Multiple users can share a single temporary tablespace

B)

Temporary tablespaces can be used to store temporary Lobs

C)

We can explicitly create objects in a temporary tablespace

D)

Temporary tablespaces can be used to store temporary Bâ€”trees

Correct Answer : Option (C) : We can explicitly create objects in a temporary tablespace

75 .

In Oracle Database 12c, which of the following statements can be used to drop redo log group number 3?

A)

DROP LOGFILE GROUP 3;

B)

ALTER DATABASE DROP LOGFILE GROUP 3;

C)

ALTER DATABASE CLEAR LOGFILE GROUP 3;

D)

ALTER DATABASE REMOVE LOGFILE GROUP 3;

Correct Answer : Option (B) : ALTER DATABASE DROP LOGFILE GROUP 3;

76 .

Which of the following SQL commands disables the force full database caching?

A)

ALTER DATABASE NO FORCE FULL CACHING;

B)

ALTER DATABASE DISABLE FORCE FULL CACI-IING;

C)

ALTER DATABASE NO FORCE FULL DATABASE CACHING;

D)

ALTER DATABASE DISABLE FORCE FULL DATABASE CACHING;

Correct Answer : Option (C) : ALTER DATABASE NO FORCE FULL DATABASE CACHING;

77 .

Which of the given SQL statements is equivalent to the following SQL statement?

A)

SELECT c.customer_id. d.order_id, c.customer_name, d.order_price FROM customer c JOIN orders d ON c.order_id = d.order_id;

B)

SELECT customer_id, order_id, customer_name. order_price FROM customer NATURAL JOIN orders;

C)

SELECT c.customer_id, d.order_id, c.customer_name, d.order_price FROM customer c, orders (IWHERE c.order_id = d.order_id;

D)

SELECT customer_id. order_id. customer_name. order_price FROM customer WHERE order_id IN (SELECT order_id FROM orders);

Correct Answer : Option (A) : SELECT c.customer_id. d.order_id, c.customer_name, d.order_price FROM customer c JOIN orders d ON c.order_id = d.order_id;

78 .

For which of the following platforms in Oracle Database 12c, remote operating system authentication over a secure connection is supported?

A)

Mac OS platform

B)

Windows platform

C)

Unix platform

D)

Linux platform

Correct Answer : Option (B) : Windows platform

79 .

In oracle Database 12c, when a server process is started, Oracle Database creates a non-shareMemory that contains data and control information. Which of the following options represents this memory?

A)

System Global Area (SGA)

B)

Program Global Area (PGA)

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Option (B) : Program Global Area (PGA)

80 .

Which of the following is/are the default index(es) provided by Oracle Database 12c?

A)

Domain index

B)

Bitmap index

C)

Global and local

D)

B - tree index

Correct Answer : Option (D) : B - tree index