Interested to Buy Any Domain ? << Click Here >> for more details...
What are the Characteristics of Data Files ?
- 3 Answers
- 6754 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rashid ansari
datafile contain actual data and one datafile associate
with only one tablespace.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / nishi
Characterstics of Data File :
- A Data file can be associated with only one database.
- Once created, a data file cannot change is size.
- One or more data files form a logical unit of database storage called a Tablespace.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / orawhiz
A data file can be associated with only one database.Once
created a data file can't change size.
One or more data files form a logical unit of database storage
called a tablespace.
| Is This Answer Correct ? | 2 Yes | 4 No |
How does oracle handle read consistency?
What is the disadvantage of User defind function?
What is a cursor and what are the steps need to be taken?
What are the values that can be specified for OPTIMIZER MODE Parameter ?
Explain overloading. Can functions be overloaded?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
When do we use group by clause in a sql query?
What are the oracle built-in data types?
What is oracle analytical function?
does the query needs a hint to access a materialized view?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
Oracle General 
