Topic : Architecture

What tool is used to modify the state of the system?


Answer :

The system state can be modified via the ALTER SYSTEM command.

Show Answer Discuss

What are the types of oracle segments?


Answer :

An Oracle database can use four types of segments :
Data segment
Index segment
Rollback segment
Temporary segment

Show Answer Discuss

How to define tuble variables?


Answer :

Tuble variables are defined in the from clause by the way of as clause.

Show Answer Discuss

What two accounts are created by default when a database is created?


Answer :

When a database is created; the SYS and SYSTEM accounts are automatically created.

Show Answer Discuss

What are some duties of the DBA?


Answer :

Installing software
Creating databases
Tablespaces
Tables
Views
Indexes and accounts
Monitoring space and performance
Maintaining the integrity of the data in the database are all duties of the DBA.

Show Answer Discuss