Skip to main content

CS403 Current Final term Paper Fall 2013 Shared by Lajjo_honey File 5

Q . how  view can be used for security purpose?
Q discuss the purpose of FROM clause in SQL query?
Q Analyze the statement is it correct or not:-
SQL is a structural language that is ,it allow the user to concentrate on specifying what data is required  rather than concentrating on the how to get ?
Q; describe Dense key index?
Q; analyse the statement
            “isolation “ ensures that the transaction which is in progress may or may not be affected other transactions ?
Q; write SQL command. To display all the columns except CITY and REFERED_BY from the table given below
 patient (P_ID,NAME,ADRESSES,CITY,ZIP,PROVINCE,COUNTRY,DATE_ADMITTED,
DATE_DISTARGE,REFERED_BY)?
Q: write rules you will follow while writing any SQL command ?
Q: analyze the statement
               0)after defining the indexes are not updated in any case .
                1)indexes can only be define when table have atleast 100 rows.
 Q: write SQL statement which display a list of person from the table name PERSON the complete information only those person should be display whose first name is Ali and last name is Ahmad?
Q; analyze the statement
                 “it is a good approach to create an indexes on non_key attribute “
Q: write two primary modes of locks ?describe the difference between shared and updated lock ?             



Comments

Post a Comment

Please give us your feedback & help us to improve this site.

Popular posts from this blog

CS301 Current Finalterm Paper Spring 2014 Shared By M. Waleed

My Tday's Cs301 Paper: Mcq's Are From Moaz And Some Are From Handouts. Subjective Is From Moaz Majority One. 1- The Image Segmentation Define? 2- The Maximum Number Level Of Nodes In Binary Tree 3-The Iteration Array Have To Sort. 4- The Hapified Array Have To Solved 5- The Algorithm Of Binary Seaoh Tree 6-Sara Arrays Wala He Tha Ya Heap Wala. 7-....Wala Wala Wala...
1 comment
Read more

CS614 Quiz No.3 Shared by Students (Solved), Spring 2014

______ index stores first value in each block in the sequential file and a pointer to the block.  Select correct option:   Dense  Sparse  B-Tree  Hash In context of data parallelism, the work done by query processor should be:  Select correct option:  Almost zero  Maximum  Pipelined  Filtered across partitions The optimizer uses a hash join to join two tables if they are joined using an equijoin and  Select correct option:   Outer table has less number of rows  Inner table has less number of rows  Cardinality of tables is equal  Large amount of data needs to be joined Bitmap index is appropriate for:  Select correct option:  Low cardinality data  High cardinality data  Clustered data  Aggregated data If a task takes “T” time units to execute on a single data item, then execution of this task on “N” data items will take __...
Post a Comment
Read more

CS614 Quiz No.4 Shared by MT Khan (Solved)

Question # 1 of 10 ( Start time: 09:04:39 PM ) Total Marks: 1 A typical cycle of implementing the change in DWH comprises of the sequence: Select correct option: Production -> QA -> Development Development-> QA -> Production(CORRECT) Development -> Production -> QA Production -> Development -> QA Question # 2 of 10 ( Start time: 09:05:16 PM ) Total Marks: 1 Vertically wide data means: Select correct option: Dataset has large no. of attributes Dataset has large no. of records(CORRECT) Dataset has attribute skews Dataset has partitioning skews Question # 3 of 10 ( Start time: 09:05:43 PM ) Total Marks: 1 In ___________ phase of kimballs approach, we identify the components needed now and in future. Select correct option: Requirement definition Architectural design Product development Analytical application development Question # 4 of 10 ( Start time: 09:06:56 PM ) Total Marks: 1 Technical architecture design supports the communicat...
2 comments
Read more