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

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

Answer: Option A

Explanation:

A view is a virtual table always created on a table, that does not hold any data, rather on every select the data is been fetched from the base table.
All operations on view (Only DMLs) will be reflecting on the base table. Only DML operations are allowed on Views.

Workspace

Tags:

Virtusa 

12. SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME
FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;
In the statement, which capabilities of a SELECT statement are performed?

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

Answer: Option A

Explanation:

Here is no explanation for this answer

Workspace

Tags:

Virtusa 

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 E

Explanation:

Here is no explanation for this answer

Workspace

Tags:

Virtusa 

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

Answer: Option C

Explanation:

Here is no explanation for this answer

Workspace

Tags:

Virtusa 

16. The _____ connective tests for set membership, where the set is a collection of values produced by a select clause. The ______ connectivity tests for the absence of set membership.

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

Answer: Option C

Explanation:

In, not in

Workspace

Tags:

Virtusa 

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

Answer: Option B

Explanation:

Query optimization

Workspace

Tags:

Virtusa 

18. The SQL statement to change the table definition

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

Answer: Option A

Explanation:

alter

Workspace

Tags:

Virtusa 

19. The beginning and end of a literal string value in a SQL Server command is denoted by:

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

Answer: Option C

Explanation:

'some string'

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