ORACLE十問(wèn)

1. Oracle安裝完成后的初始口令?

internal/oracle

sys/change_on_install

system/manager

scott/tiger

sysman/oem_temp

2. ORACLE9IAS WEB CACHE的初始默認(rèn)用戶(hù)和密碼?

administrator/administrator

3. oracle 8.0.5怎么創(chuàng)建數(shù)據(jù)庫(kù)?

用orainst。如果有motif界面，可以用orainst /m

4. oracle 8.1.7怎么創(chuàng)建數(shù)據(jù)庫(kù)?

dbassist

5. oracle 9i 怎么創(chuàng)建數(shù)據(jù)庫(kù)?

dbca

6. oracle中的裸設(shè)備指的是什么?

裸設(shè)備就是繞過(guò)文件系統(tǒng)直接訪(fǎng)問(wèn)的儲(chǔ)存空間

7. oracle如何區(qū)分 64-bit/32bit 版本???

$ sqlplus ‘/ AS SYSDBA’

SQL*Plus: Release 9.0.1.0.0 – Production on Mon Jul 14 17:01:09 2003

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.0.1.0.0 – Production

With the Partitioning option

JServer Release 9.0.1.0.0 – Production

SQL> select * from v$version;

BANNER

Oracle9i Enterprise Edition Release 9.0.1.0.0 – Production

PL/SQL Release 9.0.1.0.0 – Production

CORE 9.0.1.0.0 Production

TNS for Solaris: Version 9.0.1.0.0 – Production

NLSRTL Version 9.0.1.0.0 – Production

SQL>

8. SVRMGR什么意思?

svrmgrl，Server Manager.

9i下沒(méi)有，已經(jīng)改為用SQLPLUS了

sqlplus /nolog

變?yōu)闅w檔日志型的

9. 請(qǐng)問(wèn)如何分辨某個(gè)用戶(hù)是從哪臺(tái)機(jī)器登陸ORACLE的?

SELECT machine , terminal FROM V$SESSION;

10. 用什么語(yǔ)句查詢(xún)字段呢?

desc table_name 可以查詢(xún)表的結(jié)構(gòu)

select field_name,… from … 可以查詢(xún)字段的值

select * from all_tables where table_name like ‘%’

select * from all_tab_columns where table_name=’??’

11. 怎樣得到觸發(fā)器、過(guò)程、函數(shù)的創(chuàng)建腳本?

desc user_source

user_triggers

12. 怎樣計(jì)算一個(gè)表占用的空間的大小?

select owner,table_name,

NUM_ROWS,

BLOCKS*AAA/1024/1024 “Size M”,

EMPTY_BLOCKS,

LAST_ANALYZED

from dba_tables

where table_name=’XXX’;

Here: AAA is the value of db_block_size ;

XXX is the table name you want to check