Where the data file for system Tablespace is located? What
is its name, initial size and maxsize?
- 1 Answers
- 2767 Views
- I also Faced
- E-Mail Answers
Answer Posted / mkumar.it
The datafile for SYSTEM tablespace is located where rest of the default data files are located. The name of the datafile is system.dbf. By default, its initial size is 64 KB and max size of 2 GB.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What restrictions can you apply when you are creating views?
What is the definition of database management system?
What do you mean by entity type extension?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
Is the server accepting tcp ip connections on port 5432?
i have table as source table and flat file as target i need yo perform some logic in loading the data. is it posible? and one more thing the no of fields in source is 200+ and for target is 30+ how i can map them.........
Why do we need foreign key?
What are the limitations of using a model?
What is a deadlock and mention how it can be resolved?
Which parameters are optional in init.ora parameter file?
How index hunting contributes in improving the query performance?
What is rdbms and its types?
Mention the types of join?
What is database optimization?
Explain the Surrogate Key in DBMS.
