Home C C++ Java Python Perl PHP SQL JavaScript Linux Selenium QT Online Test

Home » Sql Objective Questions

Sql Objective Questions - 58

Questions on Index, Insert, Primary key, Inner joines, Outer Joines, Delete, Union, Operators, Update, Having Clause, Truncate, Candiate Key & Constraint etc.


Question: 41

(A) using stored procedures
(B) create fulltext index
(C) create index
(D) both A & B

Level: Expert Category: Syntax


Question: 42

(A) Bring all distinct from the listed tables
(B) Bring all data from the listed tables
(C) Bring data which is not common from the listed tables
(D) Bring common data from the listed tables

Level: Practionar Category: Union


Question: 43

(A) In Join
(B) Equi Join
(C) Out Join
(D) None of these

Level: Beginner Category: Syntax


Question: 44

(A) insert
(B) fill
(C) stuff
(D) merge

Level: Expert Category: Syntax


Question: 45

(A) Yes
(B) No

Level: Expert Category: Syntax


Question: 46

(A) Yes
(B) No

Level: Expert Category: Delete


Question: 47

(A) Delete column1, Column2, column(n) from tablename;
(B) Delete from tablename;
(C) Delete * from tablename;
(D) All of the above

Level: Beginner Category: Syntax


Question: 48

(A) UNION
(B) IN
(C) LIKE
(D) EXISTS

Level: Expert Category: Syntax


Question: 49

(A) Yes
(B) No

Level: Expert Category: Syntax


Question: 50

(A) both sides
(B) left side
(C) righ side
(D) All of these

Level: Practionar Category: Syntax


Question: 51

(A) Left Join
(B) Right Join
(C) Cross Join
(D) Inner Join

Level: Practionar Category: Syntax


Question: 52

(A) Join
(B) Outer
(C) Left
(D) Right

Level: Beginner Category: Syntax


Question: 53

(A) Identity Column
(B) Column with timestamp data type
(C) Column with default value
(D) All of the above

Level: Practionar Category: Syntax


Question: 54

(A) All Columns
(B) Identify Column
(C) Particular Column
(D) All of these

Level: Practionar Category: InsertInto


Question: 55

(A) Only 1
(B) 2
(C) Depend upon number of columns
(D) Depend on foreign keys

Level: Beginner Category: Syntax


Question: 56

(A) Yes
(B) No

Level: Expert Category: Syntax


Question: 57

(A) Yes
(B) No

Level: Expert Category: Syntax


Question: 58

(A) Yes
(B) No

Level: Expert Category: Syntax


SQL Online Test