Question : Identify the correct INSERT queries from the following :
(a) INSERT INTO Persons(‘xxx1’, ‘yyy1’);
(b) INSERT INTO Persons(LastName, FirstName) Values (‘xxx’, ‘yyy’);
(c) INSERT INTO Persons Values(‘xxx1’ , ‘yyy1’);
(d) INSERT INTO Persons Value(‘xxx1’ , ‘yyy1’);
Option 1: (a) & (b)
Option 2: (b) & (c)
Option 3: (a),(c) & (d)
Option 4: (a) & (d)
Correct Answer: (b) & (c)
Solution : Insert is a frequently used command in relational databases SQL Server and Oracle's Structured Query Language (SQL) data manipulation language (DML). The insert command is used to add one or more rows with certain table column values to a database table.
It is possible to write the INSERT INTO statement in two ways: 1. Specify both the column names and the values to be inserted: INSERT INTO table_name (column1, column2, column3, ...)
Hence the Correct answer is option 2.
Question : Consider the following SQL Statement. What type of statement is this ?
INSERT INTO instructor VALUES (10211, ‘SHREYA’ , ‘BIOLOGY’, 69000);
Question : Directions: If A denotes ‘+’, B denotes ‘×’, C denotes ‘−’, and D denotes ‘÷’, then what will come in place of ‘?’ in the following equation?
145 A 27 D 3 B ? = 163
Question : What are the values of ‘&’ and ‘#’, respectively, if the following number is perfectly divisible by 9? 51&918#0
Question : Directions: C @ D means C is the mother of D. C & D means C is the brother of D. C # D means C is the sister of D. C * D means C is the father of D. If V &Y @ G * F, then how is Y related to F?
Question : Direction: Which one of the given responses is the meaningful order of the following?
(A). Substance
(B). Atom
(C). Molecule
(D). Proton
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile