Note 1

Take Note:

Take a note while surfing.





Note With Ink

Give your Note a Colorful Tag.




Easy to Access

Stay on same information and in Sync wherever you are.

Note 2

Take Note:

Organize your information,It may take Shape.





Think With Ink

Differ your Content by Color.




Easy to Access

Easy to pull up your content from anywhere anytime.

Note 3

Take Note:

Don't Let information to miss,Because it take shape





Note With Ink

Simple an Easy Way to take a note.




Easy to Access

Get the same in next visit.

PL/SQL :: Basic Concepts

Home > PL/SQL > Basic Concepts > General Questions

1. You can add a row using SQL in a database with which of the following?

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option C

Explanation:

Here is no explanation for this answer

Workspace

Tags:

Virtusa 

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option C

Explanation:

DELETE FROM CUSTOMER WHERE ...

Workspace

Tags:

Virtusa 

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option B

Explanation:

limits the row data are returned.

Workspace

Tags:

Virtusa 

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option B

Explanation:

If you actually want to remove the table definitions as well as the data, simply drop the tables.
TRUNCATE TABLE empties it, but leaves its structure for future dat Like TRUNCATE TABLE CUSTOMER.
Removes all rows from a table without logging the individual row deletions

Workspace

Tags:

Virtusa 

5. ON UPDATE CASCADE ensures which of the following?

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option B

Explanation:

ON UPDATE CASCADE is used for checking data in the table after ALTER operation.
Example: Alter table emp add constraint Unique Key (DID) ON UPDATE CASCADE. This will restrict the update operation if any dublicate values exists.

Workspace

Tags:

Virtusa 

6. SQL data definition commands make up a(n) ________ .

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option A

Explanation:

Oracle SQL Do support XML to be inserted into the DB table. The Datatype for XML is XMLType.
We use extract() and existsNode() like functions to access the XML data into DB.

Workspace

Tags:

Virtusa 

7. Which of the following is valid SQL for an Index?

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option A

Explanation:

Index is created to make the searches (select query) faster. But to use the index we need to write the SQL select statement using the column on which we created the Index.
Example: Create index indx1 on emp (empno). To use the benefits, we have to write select * from emp where empno > 0;

Workspace

Tags:

Virtusa 

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option E

Explanation:

Here is no explanation for this answer

Workspace

Tags:

Virtusa 

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option D

Explanation:

All of the above.

Workspace

Tags:

Virtusa 

View Answer | Discuss in Forum | Workspace | Asked In |

Answer: Option B

Explanation:

Wildcards are basically for pattern matching.
Select * from emp where ename like = 'A%'; - Lists all emps with starting
Likewise % (For ignoring any number of characters) and _(Only one character).

Workspace

Tags:

Virtusa