Oracle Dba Interview Question and Answers

16. What are the data types allowed in a table?
 
  • Char
  • Varchar2
  • Number
  • Date
  • Raw
  • Long
  • Long Raw
 
Your Name Your Email-ID
Your Answer
17. What are the types of privileges?
 
    Oracle has two kinds of privileges :
  • System Privileges
  • Object Privileges
 
Your Name Your Email-ID
Your Answer
18. What is a partitioned table?
  A partitioned table is a table where the data is divided into smaller pieces based on the data itself.
 
Your Name Your Email-ID
Your Answer
19. What is an Oracle view?
  A view is a virtual table. Every view has a query attached to it. (The query is a SELECT statement that identifies the columns and rows of the tables the view uses.)
 
Your Name Your Email-ID
Your Answer
20. What is the DEFAULT profile?
  The DEFAULT profile was created by the system when the database was created. By default, all users have unlimited access to the system.
 
Your Name Your Email-ID
Your Answer