Topic : Architecture

What are two ways that you can indicate a comment in a SQL command?


Answer :

You can indicate a comment in a SQL command by using /* and */ or by using --.

Show Answer Discuss

What is the difference between DBMS and RDBMS?


Answer :

A database management system (DBMS) consists of a collection of interrelated data and a set of programs to access that data.
A Relational Database Management System(RDBMS) is a DBMS that is relational in name. This means that the internal workings access data in a relational manner. Oracle is an RDBMS.

Show Answer Discuss

What is the most important duty of an Oracle DBA?


Answer :

The most important duty of an Oracle DBA is to maintain the integrity and reliability of the user's data. This means keeping the system running and properly backed up.

Show Answer Discuss

Name three Oracle utilities?


Answer :

Oracle utilities include the SQL*Loader; the Export utility and the Import utility.

Show Answer Discuss

What are the three types of files that make up an Oracle database?


Answer :

The three types of files that make up an Oracle database are :
Datafiles
Control files
Redo log files.

Show Answer Discuss