1. Categories >> Software >> Scripts >> VB Script
  2. Suggest New Category

what is inner join?
what is outer join?
what is a constraint?
tell me about rdbms?
tell me about acid properties?

Question Posted / pratap19901990


what is inner join? what is outer join? what is a constraint? tell me about rdbms? tell me about..

Answer / Ashok Kumar Meena

1. Inner Join: Combines rows from two or more tables if there is a match in the specified columns.
2. Outer Join: Returns all rows from one table and matching rows from the other (Left Outer Join) or vice versa (Right Outer Join). If there's no match, it uses a null value for non-matching rows.
3. Constraint: A rule that restricts the data that can be entered into a database table or view. Constraints help maintain data integrity and consistency. Examples include primary keys, foreign keys, unique constraints, and check constraints.
4. RDBMS (Relational Database Management System): A software system designed to manage, retrieve, and manipulate data stored in a relational database. It uses the SQL language for querying and manipulating data.
5. ACID Properties: Four properties that guarantee reliable transactions in a database management system: Atomicity, Consistency, Isolation, and Durability.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More VB Script Interview Questions

create a form to accept username and password validate the username and password with using message box, display the corresponding user message

1 Answers   CSC,

Please Example programms on vbscript 1)writing functions and calling functions

2 Answers   CIL, TCS,

Have any one know about Test Complete 6, please let me know. If any one have good material regarding Test Complete 6, Please send to my mail id: cns.praveen@gmail.com

1 Answers  

I'm new to QTP, i facing a a problem in the script says"Object not found", "Browser("").page("").frame(Name:=fminfo).webtable(). the issue is, QTp is not able to identify the web table in run time.becuase in that fram"fminfo" there are "n"table and the table do not have the names,Html id. 1) i need to count the number webtables available on that page. 2)need to identify the webtable cell values. 3)How Loop the once i get the count and retrive the cell data of each webtable? Can anyone help on this, plz.. Thanks, Suresh

3 Answers  

i have to open a notepad having no. of words in dat file by recording in qtp and then find a particular word and display true or false

0 Answers  

How can I write HTML text to the window in VB Script?

2 Answers  

which is the bset training centre to learn automation tools?

2 Answers  

what do you mean .ota mobile format

1 Answers  

write a vb script to display the number is odd or even and whether it is divisible by 9 or not

2 Answers  

what is the standards used for writing the script in QTP

1 Answers  

I wrote the vbscript code on notepad i was geeting run time error "object required line 1" my code is set usernameobj=Descriptive.Create() usernameobj( "name").value="Username" set passwordobj=Descriptive.Create() passwordobj("name").value="password" set signinobj=Descriptive.Create() signin("name").value="sigin" browser("gmail").page("gmail").WebEdit("usernameobj").set ("enter username") Browser("gmail").Page("gmail").WebEdit("passwordobj").Setsec ure.Crypt.Encrypt("entr password") browser("gmail").page("gmail").WebButton("siginobj").click pls tell me whats wrong

1 Answers  

Why is it recommended to close the database connection every time after the work is completed?

1 Answers  

For more VB Script Interview Questions Click Here
Categories