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);
Option 1: Procedure
Option 2: DML
Option 3: DCL
Option 4: DDL
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
Option 1: 1
Option 2: 2
Option 3: 3
Option 4: 6
Question : What are the values of ‘&’ and ‘#’, respectively, if the following number is perfectly divisible by 9? 51&918#0
Option 1: 9 and 8
Option 2: 2 and 2
Option 3: 4 and 5
Option 4: 8 and 4
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?
Option 1: Father's mother
Option 2: Sister
Option 3: Father's sister
Option 4: Brother
Question : Directions: If ‘+’ means ‘–’, ‘–’ means ‘×’, ‘×’ means ‘÷’, ‘÷’ means ‘+’, then what will come in place of the question mark (?) in the following equation?
124 × 4 ÷ 13 – 3 + 36 = ?
Option 1: 31
Option 2: 34
Option 3: 45
Option 4: 42
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile