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
Question : ____________Offers the ability to query the data and insert, alter and delete tuples.
Question : Directions: If ‘+’ means ‘–’, ‘–’ means ‘×’, ‘×’ means ‘÷’, ‘÷’ means ‘+’, then what will come in place of the question
Question : What are the values of ‘&’ and ‘#’, respectively, if the following number is perfectly divisible by 9? 51&918#0
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
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile