What is schema?
Answer Posted / manmeet singh
schema is like a object of ur database
like
tables,view,procedures,function..
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
How to import one table back from a dump file?
How to convert character types to numeric types?
What happens if the update subquery returns multiple rows?
What is the fastest query method to fetch data from the table?
What are the differences between char and nchar in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Please explain joins in oracle?
Name the three major set of files on disk that compose a database in Oracle?
What happens to the current transaction if a ddl statement is executed?
How to view the tablespaces in the current database?
Give the various rollback segment states.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to define a variable to match a table column data type?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.