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

CS614 Quiz No.4 Shared by Abdul_Mateen (Solved)

Question # 1 of 10 ( Start time: 01:03:34 PM ) Total Marks: 1 The first step of the “12-steps data warehouse implementation approach” of Shaku Atre is: Select correct option: Finding user needs (Page No. 336) Planning system resources Finding system scope Data acquisition and cleansing Question # 2 of 10 ( Start time: 01:04:15 PM ) Total Marks: 1 Users do not care, how advance the front end of your DWH is, what they care is that: Select correct option: Tables should be properly denormalized Proper partitioning technique should be used At least star or snow flake schema should be implemented They should get information in timely manner and the way they want   Question # 3 of 10 ( Start time: 01:04:49 PM ) Total Marks: 1 Which of the following is NOT one of the top-10 mistakes that should be avoided during DWH development? Select correct option: Not interacting directly with end user Not being an accommodating person (Page No. 316) Isolating IT support p...
Post a Comment
Read more

CS504 Quiz No.3 Shared by Angel

Question # 1 of 10 ( Start time: 09:08:01 PM ) Total Marks: 1 Defining the services of an object means: Select correct option: What it does?        ok What it knows? Who knows it? Whome it knows? Question # 2 of 10 ( Start time: 09:08:27 PM ) Total Marks: 1 Which one of these represents the Krutchen’s 4+1 architectural view model? Select correct option: Logical view, Process view, Physical view, Development view, Use case view Logical view, Dynamic view, Physical view, Development view, Use case view Logical view, Process view, Physical view, Development view, Sequence view Dynamic view, Process view, Physical view, Development view, Use case view Question # 3 of 10 ( Start time: 09:09:50 PM ) Total Marks: 1 Return values in Synchronous messages are represented by: Select correct option: A solid line A dotted line with label        ok A solid line with label Double line Question # 4 of 10 ( Start tim...
Post a Comment
Read more

CS614 Quiz No.3 Shared by Sweety (Solved)

Question # 1 of 10 ( Start time: 09:48:28 PM ) Total Marks: 1 Mining multi dimensional databases allow users to: Select correct option: Categorize the data Analyze the data Summarize the data All of the given options   (Correct) Question # 2 of 10 ( Start time: 09:49:23 PM ) Total Marks: 1 As per Bill Inmon, a data warehouse, in contrast with classical applications is: Select correct option: Data driven   (Correct) Resource driven Requirement driven Time sensitive Question # 3 of 10 ( Start time: 09:50:11 PM ) Total Marks: 1 In ________learning you don’t know the number of clusters and no idea about their attributes. Select correct option: Supervised learning Unsupervised learning   (Correct) Multi Dimension modeling None of the given options Question # 4 of 10 ( Start time: 09:51:04 PM ) Total Marks: 1 Identify the TRUE statement: Select correct option: The data value increases as volume decreases   (Correct) The data value decreases ...
Post a Comment
Read more