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)

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