Oracle Interview questions

Total available count: 35
Subject - Databases
Subsubject - Oracle

What is difference between SQL and SQL*PLUS?

SQL and PL/SQL language interface and reporting tool whereas SQL*PLUS is a command-line tool. SQL*PLUS is a command-line tool that allows users to type SQL commands to be executed directly against an Oracle database. SQL*PLUS commands are used to Set options, Format Query Results, Edit SQL commands, and PL/SQL. SQL is a language used to query Relational Database Management(DML, DCL, DDL). 

Next 5 interview question(s)

What is difference between UNIQUE and PRIMARY KEY constraints?
What are different Oracle database objects?
What is the difference between rename and alias?
How do we create privileges in Oracle?
What are temporal data types in Oracle?