Oracle Database MCQs (Chapterwise Multiple Choice Questions)

Regarding Oracle, what does DES most commonly mean?

Digital Encryption System

Data Entry Sheet

Dynamic Energy Saver

Data Encryption Standard

Data Extraction Segment

Answer & Explanation

Correct Answer: Data Encryption Standard

Note: This Question is unanswered, help us to find answer for this one

The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? select * from HR

You obtain the results retrieved from the HR table that belongs to your schema.

You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.

You obtain the results retrieved from the public synonym HR created by the database administrator

You get an error message because you cannot retrieve from a table that has the same name as a public synonym

Answer & Explanation

Correct Answer: You obtain the results retrieved from the HR table that belongs to your schema.

Note: This Question is unanswered, help us to find answer for this one

You need to search for text data in a column, but you only remember part of the string. Which of the following SQL operations allows the use of wildcard comparisons?

IN

BETWEEN

LIKE

EXISTS

Answer & Explanation

Correct Answer: LIKE

Note: This Question is unanswered, help us to find answer for this one

How would you display a listing of the sums of employee salaries for those employees not making a commission, for each job type, including only those sums greater than 2500?

none of the above

select job, sum(sal) from emp group by job having sum(sal) > 2500 and comm is not null;

select job, sum(sal) from emp where sum(sal) > 2500 and comm is null group by job;

select job, sum(sal) from emp where sum(sal) > 2500 and comm is null;

select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;

Answer & Explanation

Correct Answer: select job, sum(sal) from emp where comm is null group by job having sum(sal) > 2500;

Note: This Question is unanswered, help us to find answer for this one

Which /SQL*Plus feature can be used to replace values in the WHERE clause?

This feature cannot be implemented through /SQL*Plus.

Substitution variables

Replacementvariables

Instead-of variables

Answer & Explanation

Correct Answer: Substitution variables

Note: This Question is unanswered, help us to find answer for this one

In business, what is the most common definition for ERP?

Electronic Resource Planning

Electronic Resource Pricing

Early Retirement Plan

Employee Referral Program

Enterprise Resource Planning

Answer & Explanation

Correct Answer: Enterprise Resource Planning

Note: This Question is unanswered, help us to find answer for this one

Oracle default optimization follows:

Rule based optimization

Cost based optimiztion

Both Cost and Rule

Answer & Explanation

Correct Answer: Cost based optimiztion

Note: This Question is unanswered, help us to find answer for this one

Which of the following falsely sums up Oracle’s locking policy?

Oracle never locks data just to read it. There are no locks placed on rows of data by simple reads

Oracle locks data at the row level on modification. There is no lock escalation to a block or table level

A writer of data is blocked only when a reader of data has already locked the row it was going after.

A reader of data never blocks a writer of data

Answer & Explanation

Correct Answer: A writer of data is blocked only when a reader of data has already locked the row it was going after.

Note: This Question is unanswered, help us to find answer for this one

Which statement about views are true?

A view must have aliases defined for the column names in the SELECT statement.

A view can be created as a join on two or more tables.

A view cannot have an ORDERBY clause in the SELECT statement.

A view cannot be created with a GROUP BY clause in the SELECT statement.

Answer & Explanation

Correct Answer: A view can be created as a join on two or more tables.

Note: This Question is unanswered, help us to find answer for this one

How does PL/SQL allow programmers to use it on any host environment?

It improves process performance

It processes Oracle errors with exception-handling routines

It modularizes program development

It is portable

Answer & Explanation

Correct Answer: It is portable

Note: This Question is unanswered, help us to find answer for this one

Oracle Database Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.