100 Questions that Oracle beginners must know

1. Oracle installation After the completion of the initial password?

Internal/oracle

Sys/change_on_install

System/manager

Scott/tiger

Sysman/oem_temp

2. Oracle9iAS WEB Cache's initial Default user and password?

Administrator/administrator

3. How does Oracle 8.0.5 create a database?

With Orainst. If you have a motif interface, you can use orainst/m.

4. How does Oracle 8.1.7 create a database?

Dbassist

5. How does Oracle 9i create a database?

Dbca

6. What does the naked device in Oracle refer to?

A bare device is a storage space that bypasses direct access to the file system.

7. How does Oracle differentiate 64-bit/32bit versions???

$ Sqlplus '/as SYSDBA '

Sql*plus:release 9.0.1.0.0-production on Mon June 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>