 Related Questions Latest Answer : View: A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables.Types of Views: a)
DataBase View b) Help View c) Projection View d) Maintenance ... Read Answers (6) | Asked by : chim What is the difference between a stored procedure and a view? why do we use views from SQL Server point of view? What are mutating triggers? How is the structure of a bit map index, clustered, Non clustered and B Tree What re mutating triggers? Can a stored procedure a record set? Can we use DTS on a client machine to schedule jobs and consolidate data to a sql tables? Can we have an update trigger within another update trigger? You are writing a report that needs to format data being extracted from the database on the screen. All data relates to a specific object, but there are a variable amount of tables, and each table has a variable amount of columns and a variable amount of rows. The goal is to produce a display which is user friendly from a typical browser screen. For example, consider a system for a gift wishlist. The main object is a person and different categories of items are stored in separate tables (movies View Question | Asked by : Ming Latest Answer : user_tab_partitions,all_tab_partitions,dba_tab_partitions ... Read Answers (1) | Asked by : Tarandeep What is mutating error ? When did it occur and give one example?What is ref cursor give me example?What is plsql table and diff between table?Is it possible to use commit in execption handler section ? Provide VBScript code that that outputs the contents of a SQL table into a CSV formatted file called Output.csv. Your code must include the connection string and must use the following SQL criteria: List the rules used to enforce table level integrity. What is an intersection table and why is it important? Latest Answer : A table added to the database to break down a many-to-many relationship to form two one-to-many relationships ... You have been asked to design the following database diagram:“We would like to store a list of user’s in the database with their corresponding network of friends, groups, as well as any messages
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
