Question

oracle数据库面试题

懂的请回答一下, 都是很基础的：
1）Programmer A can describe table EMPLOYEE, but b cannot, what is the problem?
2) Table extent is full, what is the problem.
3) Table space is full, what is the problem.
4) Creating a foreign key (steps ?)
5) PCT_INCREASE in USER_TABLES ?
6) IF Lost package's text file in our PC, what should we do ?
7) IF we can connect database at NT Server, But we can not connect the database at PC ? What is the problem?
8)what is the difference of 'CHAR' and 'VARCHAR2'?
9) write down the steps of installation of oracle server on winNT and how to connect PC to server.?

Answer 1

b programer no privilege or add table ownerTable extent is full max extend 设置成 unlimited，Table Space is full datafile autoextend 设置成 on