FAQ's

Questions:

1. How to create duplicate tables.

2. How to copy data from one table to another table.

3. How to enter null values using insert/ update

4. How to re-execute the previous command.

5. What is SQL PLUS

6. How to insert multiple records using a single insert statement.

7. Difference between &, &&

8. Datatypes in Oracle

9. Types of tables in Oracle.

10. SQL Objects present in Oracle.

11. Database Operations present in Oracle.

12. Username, password for oracle.

13. Oracle authentication details.

14. SYS/SYSTEM/ SCOTT accounts are locked.

15.How to connect to Oracle.

16. What user are available with Oracle installation.

17. Create a user in oracle

18. GRANT/ REVOKE premissions for a user.

19. How to change the password for a user in Oracle.

20. How to lock and unlock an account in Oracle.

21. How to Drop an account in Oracle.