Oracle FAQs

Truncate is a DDL command.You can not rollback the data once you done truncate command

TRUNCATE is a data definition language (DDL) command.Removes all rows from the table,leaving the table empty and the table structure intact.

We can limit the bulk binding values. It would improve the overall performance. It would not consume more memory.

Best examples of Referential Integrity constants Primary Key And Foreign key. Primary Key constraint allow a particular attribute to be not null and unique. Where as Foreign key will be used when ever there is a need to maintain the same attribute values in the multiple tables.

The login credentials will be requested at the time when you run a form on runtime of developer suit, that particular fmb/fmx is usually known as the login form or the master form from which a menu mo...

1) Try collecting Statistics
2) Spilt your query based on incoming unique values

check for the bottle necks starts from the source and continue till target

the combination of unique key and not null key is called primary key. In a table we use only one primary key.It is unique,it cant allow the null values. UNIQUE key ,in a table we use more than one un...

1.CHAR should be used for storing fix length character strings. String values will be space/blank padded before stored on disk. If this type is used to store varibale length strings, it will waste a l...

1.CHAR should be used for storing fix length character strings. String values will be space/blank padded before stored on disk. If this type is used to store varibale length strings, it will waste a l...

its role .... we can assign a role like manager , etc , collection of privs is known as role

Collecting the access

eg: insert,select,update

in this group the user can apply only the above operation on the tables.

Use ALTER TABLESPACE ADD DATAFILE statement to add one or more
files to the tablespace indicated.

Please Set the Undo Tablespace management auto and scope is memory and then try to do 
Thanks 

SELECT JOB,COUNT(EMPNO) AS NOOFEMP FROM SCOTT.EMP WHERE DEPTNO IN (10,20)
GROUP BY JOB HAVING COUNT(EMPNO) > 1

force view is the process to create a view forcefully without a base table. syntax:

Code
CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW VIEW_NAME
            AS
            SELECT STMT;

for users permissions : user_tab_privs table is used.
for viewing all permissions : all_tab_privs

Data dictionary is nothing but the place holder which contains all information of the object

like name,type,size,owner,permissions etc.

some data dictionaries : user_views,user_mviews, user_tabs, user_sequences, all_objects etc

Open dba_objects in that open column name owner, in that mention user name and it will display the list of tables and views of specific users.

THE BELOW FUNCTIONS ARE OLAP FUNCTIONS...

rank() function skips the continuity but dense_rank() function gives the sequence.It is always advised to use dense_rank for viewing nth highest/lowest value. row_num() gives the serial no in the order how they are inserted in to a table.

log switch ::suppose we have two redo log files LOG A, LOG B. when transaction(DML) are occurred in Database then they are recorded in LOG A. When LOG A is filled up, a log switch occurs, All new tran...

Exceptions are nothing but the errors occurred at the run time. To handle the exception we use exception block in the PLSQL.

Its background processes in oracle, it will write offline redolog group information into archive log files

select table_name from USER_CONSTRAINTS where r_constraint_name= (select CONSTRAINT_NAME from USER_CONSTRAINTS where table_name=INPUT_PARENT_TABLE and CONSTRAINT_TYPE=P) and CONSTRAINT_TYPE=R;

Try this script, Example SELECT child.table_name AS "TABL_NAME_2", 'Is Parent Of' AS ...

Clustered table store data of multiple table based on common columns.

View is virtual table or which has attached select query.Its not actual table.

A cluster is a group of tables which share the same data blocks. Clusters are an optional method of storing table data. Cluster share common columns and are often used together. It is a powerful met...

The Oracle version starting of I. The starting in 1999 with version 6i, 8i and 9i, I signify "Internet" means stands for "Internet" and Oracle added the "I" to the version name to reflect support for ...

Oracle 9i and Oracle 10g....there are more implementation differences. In terms of architecture, 9i is based on Internet technology while 10g is grid computing based one. Many DBA features like Automa...