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 ?
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.