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
Correct Answer: DML
Solution : The term "Data Manipulation Language" is an acronym. represents a group of computer languages that are specifically used to alter databases. Examples include CRUD operations, which create, read, update, and remove data. use the verbs INSERT, SELECT, UPDATE, and DELETE.
Hence the correct answer is option 2.
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)
Question : ____________Offers the ability to query the data and insert, alter and delete tuples.
Option 1: Transaction control Language (TCL)
Option 2: Data Control Language (DCL)
Option 3: Data Definition Language (DDL)
Option 4: Data Manipulation Language (DML)
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
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: 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
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile