1.What is an Oracle sequence?
Ans: A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
2.What is a synonym?
Ans: A synonym is an alias for a table, view, sequence or program unit.
3.What are the types of synonyms?
Ans: There are two types of synonyms private and public.
4.What is a private synonym?
Ans: Only its owner can access a private synonym.
5.What is a public synonym?
Ans: Any database user can access a public synonym.
6.What are synonyms used for?
Ans: 1. Mask the real name and owner of an object.
2. Provide public access to an object
3. Provide location transparency for tables, views or program units of a remote database.
4. Simplify the SQL statements for database users.
7.What is an Oracle index?
Ans: An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.
8.How are the index updates?
Ans: Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.
9.What is Rollback Segment ?
Ans: A Database contains one or more Rollback Segments to temporarily store "undo" information.
10.What are the Characteristics of Data Files ?
Ans: 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.
>
Ans: A sequence generates a serial list of unique numbers for numerical columns of a database's tables.
2.What is a synonym?
Ans: A synonym is an alias for a table, view, sequence or program unit.
3.What are the types of synonyms?
Ans: There are two types of synonyms private and public.
4.What is a private synonym?
Ans: Only its owner can access a private synonym.
5.What is a public synonym?
Ans: Any database user can access a public synonym.
6.What are synonyms used for?
Ans: 1. Mask the real name and owner of an object.
2. Provide public access to an object
3. Provide location transparency for tables, views or program units of a remote database.
4. Simplify the SQL statements for database users.
7.What is an Oracle index?
Ans: An index is an optional structure associated with a table to have direct access to rows, which can be created to increase the performance of data retrieval. Index can be created on one or more columns of a table.
8.How are the index updates?
Ans: Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.
9.What is Rollback Segment ?
Ans: A Database contains one or more Rollback Segments to temporarily store "undo" information.
10.What are the Characteristics of Data Files ?
Ans: 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.
>
Posted in: 
0 comments:
Post a Comment