Posts

What is RDBMS?

Question 3: What is PL/SQL? Answer 3:  PL/SQL Control Statements in Oracle. Control Statements, Control statements are very important in PL/SQL. Control Statements are elements in a program that control the flow of program execution. The syntax of control statements are similar to regular English and are very similar to choices that we make every day. Branching statements are as follows: If statement If - THEN - ELSE Nested IF Branching with logical connectivity While For Loop If statement Syntax:  Click on the following link to read further. PL/SQL Control Statements in Oracle Question 4: What is the difference between SQL and PL/SQL? Answer:  SQL: It is referred as Structured Query Language. Only simple IF / Else statements. Through SQL you can interact with database through ADO.NET In SQL you can execute a line of code It can run only on windows PL/SQL: It is referred as Procedure Language / Structure Query Language: In PL/SQL you can execute a block of

Most Asked SQL Server Interview Questions and Answers

Image
Question 1: What is a database? Answer 1:  A database is described as an organized way of collection of DATA. It is the collection of schemes, tables, queries, reports, views and other objects.  Syntax:  CREATEDATABASEDatabaseName Example:  CREATEDATABASE Student