Select Category 
 

Oracle Interview Questions Answers

Oracle Interview Question - 241 : -

An open form can not be execute the call_form procedure if you chain of called forms has been initiated by another open form?

Oracle Interview Answer - 241 : -

True
 

Oracle Interview Question - 242 : -

What is lexical reference? How can it be created?

Oracle Interview Answer - 242 : -

Lexical reference is place_holder for text that can be embedded in a sql statements. A lexical reference can be created using & before the column or parameter name.
 

Oracle Interview Question - 243 : -

What are the components of logical database structure of Oracle database?

Oracle Interview Answer - 243 : -

There are tablespaces and database's schema objects.
 

Oracle Interview Question - 244 : -

Why are OPS$ accounts a security risk in a client/server environment? (for DBA)

Oracle Interview Answer - 244 : -

If you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be sure who they really are. With terminals, you can rely on operating system passwords, with Windows, you cannot.
If you set REMOTE_OS_AUTHENT=TRUE in your init.ora file, Oracle assumes that the remote OS has authenticated the user. If REMOTE_OS_AUTHENT is set to FALSE (recommended), remote users will be unable to connect without a password. IDENTIFIED EXTERNALLY will only be in effect from the local host. Also, if you are using "OPS$" as your prefix, you will be able to log on locally with or without a password, regardless of whether you have identified your ID with a password or defined it to be IDENTIFIED EXTERNALLY.
 

Oracle Interview Question - 245 : -

Is it possible to link two groups inside a cross products after the cross products group has been created?

Oracle Interview Answer - 245 : -

no
 

Oracle Interview Question - 246 : -

How is link tool operation different bet. reports 2 & 2.5?

Oracle Interview Answer - 246 : -

In Reports 2.0 the link tool has to be selected and then two fields to be linked are selected and the link is automatically created. In 2.5 the first field is selected and the link tool is then used to link the first field to the second field.
 

Oracle Interview Question - 247 : -

What are the advantages of views?

Oracle Interview Answer - 247 : -

- Provide an additional level of table security, by restricting access to a predetermined set of rows and columns of a table.
- Hide data complexity.
- Simplify commands for the user.
- Present the data in a different perspective from that of the base table.
- Store complex queries.
 

Oracle Interview Question - 248 : -

Can objects of the same Schema reside in different tablespace ?

Oracle Interview Answer - 248 : -

Yes.
 

Oracle Interview Question - 249 : -

Which of the two views should objects according to possession?

Oracle Interview Answer - 249 : -

view by structure.
 

Oracle Interview Question - 250 : -

What is Privilege Auditing ?

Oracle Interview Answer - 250 : -

Privilege auditing is the auditing of the use of powerful system privileges without regard to specifically named objects.
 

Oracle Interview Question - 251 : -

How does one do off-line database backups?

Oracle Interview Answer - 251 : -

Shut down the database from sqlplus or server manager. Backup all files to secondary storage (eg. tapes). Ensure that you backup all data files, all control files and all log files. When completed, restart your database.
Do the following queries to get a list of all files that needs to be backed up:
select name from sys.v_$datafile;
select member from sys.v_$logfile;
select name from sys.v_$controlfile;
Sometimes Oracle takes forever to shutdown with the "immediate" option. As workaround to this problem, shutdown using these commands:
alter system checkpoint;
shutdown abort
startup restrict
shutdown immediate
Note that if you database is in ARCHIVELOG mode, one can still use archived log files to roll forward from an off-line backup. If you cannot take your database down for a cold (off-line) backup at a convenient time, switch your database into ARCHIVELOG mode and perform hot (on-line) backups.
 

Oracle Interview Question - 252 : -

What is Distributed database ?

Oracle Interview Answer - 252 : -

A distributed database is a network of databases managed by multiple database servers that appears to a user as single logical database. The data of all databases in the distributed database can be simultaneously accessed and modified.