Technical Interview Questions

Display the records between two range
select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum< &Start);
Enter value for upto: 10
Enter value for Start: 7
ROWNUM EMPNO ENAME
——— ——— ———-
1 7782 CLARK
2 [...]

1.To see current user name
Sql> show user;
2.Change SQL prompt name
SQL> set sqlprompt “Manimara > “
Manimara >
Manimara >
3.Switch to DOS prompt
SQL> host
4.How do I eliminate the duplicate rows ?
SQL> delete from table_name where rowid not in (select max(rowid) from table group by duplicate_values_field_name);
or
SQL> delete from table_name ta where rowid >(select min(rowid) from table_name tb where ta.dv=tb.dv [...]

1. What are the components of physical database structure of Oracle database?
Oracle database is comprised of three types of files. One or more datafiles, two are more redo log files, and one or more control files.
2. What are the components of logical database structure of Oracle database?
There are tablespaces and database’s schema objects.
3. What is [...]