Shahuraj Yevate

  Short Question RDBMS Short Questions on RDBMS (a) What is difference between DBMS and RDBMS ? (b) Define Transaction. (c) Define lock. State types of lock. (d) What is timestamp ? (e) List states of transaction. (f) Explain advantages of concurrent execution. (g) List the failure types. (h) Write the syntax for trigger. (a) Give any two differences between DBMS and RDBMS. (b) What is trigger ? List types of trigger. (c) What is transaction ? List properties of transaction. (d) Define : (i) growing phase (ii) shrinking phase. (e) List different types of failures. (f) Define cascadeless schedule. (g) Give Lock-compatibility matrix. (h) Write syntax of nested if statement in PL/SQL with example (a) What is PL/SQL ? List the sections of a PL/SQL block. (b) What is RDBMS ? List any four characteristics of RDBMS. (d) What is Schedule ? List the types of Schedule. (e) What is procedure in PL/SQL ? Give syntax of procedure. (a) What is RDBMS ? List the different products of RDBMS. (c) Wh...

  Short Questions C Short Questions on C Programming (a) What are various datatypes used in C ? (b) Define keyword. (c) State any four types of statements in C. (d) Define recursion and give its advantage. (e) What do you mean by scope of a variable ? (f) What is structure ? (g) Write down what do you mean by command line argument. (h) Define string with example. (i) What are limitations of Array ? (j) Define file. State types of file. (k) What is the difference between malloc( ) and calloc( ) ? (l) What is generic pointer in C ? (1) ‘C’ is middle level language. Comment. (2) Give syntax and example of : (1) scanf( ) (2) putchar( ) (3) Give example of nested for loop statement. (4) Give use of break and continue statement. (5) What is an array ? How to represent 2D- arrays in memory. (6) Define a recursion. State advantages of recursion. (7) What is exist function ? Give example. (8) What is formal and actual parameter ? (9) List different types of files. (10) What is escape sequen...

  Web Hosting   Cheap Web Hosting  / Cheap Hosting Hostinger is the best web hosting company when it comes to WordPress hosting. And its hosting plans are cheap too. So a beginner blogger does not have to spend much money. Also Hostinger is a very good web hosting company. This hosting company is the best as its plans are cheap and good. Benefits of Hostinger Web Hosting 1) Best in Uptime Like the rest of the web hosting, Hostinger also claims 99.99% uptime. So your website can stay online 24 hours a day. The benefit of which will be that more visitors will come to the website. 2) Help the website load in seconds To get more visitors to the website, the website should be quick to open. So the one who opens the website will not leave the website. Hosting speed is important when buying web hosting. So Hostinger's hosting speed works well. 3) Hostinger's Customer Support After purchasing any product or service, you need customer support. So that if any information or proble...

  BCA (Bachelor of Computer Application) Recent Trends in IT Unit 4:Network Security INTRODUCTION Computer data often travels from one computer to another, leaving the safety of its  protected physical surroundings. Once the data is out of hand, people with bad intention could  modify or forge your data, either for amusement or for their own benefit. STEGANOGRAPHY A plaintext message may be hidden in any one of the two ways. The methods of steganography conceal the existence of the message, whereas the methods of cryptography render the message unintelligible to outsiders by various transformations of the text. A simple form of steganography, but one that is time consuming to construct is one in which an arrangement of words or letters within an apparently innocuous text spells out the real message. e.g., (i) the sequence of first letters of each word of the overall message spells out the real (Hidden) message. (ii) Subset of the words of the overall message is used to co...

   RDBMS  Practical Slips Solution Slip 1 Q3. Consider the following entities and their relationships.  [40] Client (client_no, client_name, address, birthdate) Policy_info (policy_no, desc, maturity_amt, prem_amt, date) Relation between Client and Policy_info is Many to Many Constraint:  Primary key, prem_amt and maturity_amt should be > Create a RDB in 3NF and write PL/SQL blocks in Oracle for the following: Client (c_no, c_name, c_addr, birth_date) Policy_info (p_no, p_name, maturity_amt, prem_amt, policy_dt) cp_info(c_no,p_no) 1)    Write a function which will return total maturity amount of policies of a particular client. create or replace function f1(cno IN number) return number is tot number(15); begin select sum(policy_info maturity_amt) into tot from policy_info,cp_info,client where policy_info.p_no=cp_info.p_no and client.c_no= cp_info.c_no and client.c_no=cno ; return tot; end; calling function begin     dbms_output....