Answer Posted / gvmahesh

NOCYCLE keyword is default in sequences.

CYCLE :If we want use cycle keyword first we check the table
having primary key or not.If there is no primary key we
absolutely use the CYCLE keyword.

In hierarchical structure,the descendant act as a
ancestor,is called CYCLE.

For eliminating ancestor descendant problem we use NOCYCLE
KEYWORD.

for example we take the EMP table

In EMP table the MGR column has a NULL managerial number.In
that column we insert some of the empno.Then ancestor
descendant problem occur.

select * from emp;

update emp set mgr=7566 where mgr is null;

Then we write a hierarchical query

select empno,ename,sal,mgr from emp
start with ename='KING'
connect by prior empno=mgr;

we execute this query it shows an error

ERROR:
ORA-01436: CONNECT BY loop in user data.

in this situation also we want to see the data through
NOCYCLE keyword.

select empno,ename,sal,mgr from emp
start with ename='KING'
connect by NOCYCLE prior empno=mgr;

What are the types of join and explain each?

1100

---

What is the difference between numeric and autonumber?

1038

---

How many clustered indexes can you have?

1037

---

Does sql backup shrink transaction log?

1044

---

Can we join more than 2 tables in sql?

1093

---

What is data modelling in sql?

1073

---

List the ways to get the count of records in a table?

942

---

What is the basic structure of an sql?

1155

---

Show how functions and procedures are called in a pl/sql block.

1183

---

how would concatenate strings in mysql? : Sql dba

1139

---

What is the difference between inner join and natural join?

1055

---

What is oracle pl sql developer?

1024

---

discuss about myisam key cache. : Sql dba

1068

---

What is the use of double ampersand (&&) in sql queries? Give an example

1187

---

Why are aggregate functions called so?

1012

---