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