×

Loading...
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。
Ad by
  • 最优利率和cashback可以申请特批,好信用好收入offer更好。请点链接扫码加微信咨询,Scotiabank -- Nick Zhang 6478812600。

Answer

1.primary key, unique key 是不是数据库自动建索引 ?
Oracle automatically creates an index for each UNIQUE or PRIMARY KEY declaration.
2. oracle 允许把 foreign key 建在另一个数据库的一张表的primary/unique key 上吗?
of course
I can't answer this question. Basically, I don't think so.
3. A materialized view is a database object that contains the results of a query.They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots.
Report

Replies, comments and Discussions:

  • 工作学习 / 专业技术讨论 / 请教一下oracle数据库的几个问题 (估计面试时也会经常碰到)
    1. primary key, unique key 是不是数据库自动建索引 ?
    2. oracle 允许把 foreign key 建在另一个数据库的一张表的primary/unique key 上吗?
    也就是说parent/child表不在同一数据库中, 怎么enforce referential integerity ?
    3. 什么是materialized view ?
    • Answer
      1.primary key, unique key 是不是数据库自动建索引 ?
      Oracle automatically creates an index for each UNIQUE or PRIMARY KEY declaration.
      2. oracle 允许把 foreign key 建在另一个数据库的一张表的primary/unique key 上吗?
      of course
      I can't answer this question. Basically, I don't think so.
      3. A materialized view is a database object that contains the results of a query.They are local copies of data located remotely, or are used to create summary tables based on aggregations of a table's data. Materialized views, which store data based on remote tables are also, know as snapshots.