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.

« 1 2 3 »

Question: 41

How full-txt indexes are created?

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

Level: Expert Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 42

What does UNION operator do in a SQL statement?

(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
[Posted by: Admin | Chicago, USA]

Question: 43

Which one of the following is also known as INNER JOIN?

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

Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 44

Which of the following SQL function is used to insert a string into another string?

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

Level: Expert Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 45

 Index rebuild and index reorganize is one and the same thing in sql?

(A) Yes
(B) No

Level: Expert Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 46

Does delete statement maintains any lock on table?

(A) Yes
(B) No

Level: Expert Category: Delete
[Posted by: Admin | Chicago, USA]

Question: 47

Current syntax for Delete Query

(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
[Posted by: Admin | Chicago, USA]

Question: 48

Which of the following operator is used with NOT EXISTS functions to simulate Outer Join operation

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

Level: Expert Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 49

Is it possible to join Null values?

(A) Yes
(B) No

Level: Expert Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 50

In case of full outer join Nulls are added to the unmatched rows on the following

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

Level: Practionar Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 51

Which of the following join uses maximum resources if there are large tables?

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

Level: Practionar Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 52

 Inner Joins are the default join type, so which of the following operator can be used for inner join?

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

Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 53

SQL Server can automatically provide values for followings

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

Level: Practionar Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 54

INSERT statement can be used insert data into following

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

Level: Practionar Category: InsertInto
[Posted by: Admin | Chicago, USA]

Question: 55

How may clustered index are allowed per table?

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

Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 56

Can we create Spatial Index without Primary Key?

(A) Yes
(B) No

Level: Expert Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 57

Is Candidate key always a super key

(A) Yes
(B) No

Level: Expert Category: Syntax
[Posted by: Admin | Chicago, USA]

Question: 58

Is SuperKey always a candidate key?

(A) Yes
(B) No

Level: Expert Category: Syntax
[Posted by: Admin | Chicago, USA]

« 1 2 3 »

SQL Online Test

Home » Sql Objective Questions

Sql Objective Questions - 58

MCQs

Problems

Projects

Compiler

Online Test