Oracle Interview Questions and Answers (32) - Page 2

Latest and authentic Interview questions. You can also post an interview question and win monthly prizes as well as gain community credit points.

32 records found.

Post |

Interview Experiences |

Interview FAQs |

Online Interviews |

Exclusive Questions

Get 650+ Questpond's Interview videos on discount

In Oracle,which command is used to get Table Structure?

NOTE: This is objective type question, Please click question title for correct answer.

What will be the output of SQL> Select 2 Compose('A' || UniStr('\0300')) GraveAccent 3 ,Compose('A' || UniStr('\0301')) AcuteAccent 4 ,Compose('A' || UniStr('\0302')) CircumFlex 5 ,Compose('A' || UniStr('\0303')) Tilde 6 ,Compose('A' || UniStr('\0308')) Umlaut 7 From Dual;

NOTE: This is objective type question, Please click question title for correct answer.

List out from below what can be done for query optimization?

NOTE: This is objective type question, Please click question title for correct answer.

What is BCP? What is its Use?

BCP is BulkCopy.
Its a tool which is used to Copy bulk data from Tables and Views.
BCP doesn't copy the structure from same as source and destinations.

Which of the following query will show you which constraints is mapped to which table?

NOTE: This is objective type question, Please click question title for correct answer.

What is the Cluster Key?

NOTE: This is objective type question, Please click question title for correct answer.

How to see Current User name who using in Oracle?

NOTE: This is objective type question, Please click question title for correct answer.

What is the Maximum Number of triggers can be applied in a Table?

NOTE: This is objective type question, Please click question title for correct answer.

ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed. Which is called as?

NOTE: This is objective type question, Please click question title for correct answer.

What is the value for SIGN(NVL(-16,0))?

NOTE: This is objective type question, Please click question title for correct answer.

Which date components does the CURRENT_TIMESTAMP function display?

NOTE: This is objective type question, Please click question title for correct answer.

Which function implements IF..THEN ELSE logic?

NOTE: This is objective type question, Please click question title for correct answer.

More ORACLE Exclusive Interview Questions & Answers here

Found this useful, bookmark this page to the blog or social networking websites.

Bookmark It

Interview Questions and Answers Categories

Data Structures & Algorithms

Design Pattern & Practices

DotNetFunda.Com

Entity Framework

Error and Solution

Function Points (FPA)

MSBI (SSIS, SSRS, SSAS)

Web Services, Remoting