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: 21

What is the storage size of smallmoney data type in sql?

(A) 2 bytes
(B) 4 bytes
(C) 8 bytes
(D) 16 bytes

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

Question: 22

Select the Range of TinyInt data type in SQL Server

(A) 0-128
(B) 0-255
(C) -325768 - + 325767
(D) 0- 65535

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

Question: 23

Sql data type using for assigning GUID values?

(A) GUID
(B) UNIQUE
(C) UNIQUEIDENTYFIER
(D) TINYINT

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

Question: 24

Default size of n in a column which is defined as VARCHAR(n)?

(A) 0
(B) 1
(C) 256
(D) None of these

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

Question: 25

Which one of the following is correct syntax for Insert Statement?

(A) Insert into table_name (Col1, Col2,Col3) VALUES (Val1,Val2,Val3);
(B) Insert table_name Columns(Col1, Col2,Col3);
(C) Insert Columns(Col1, Col2,Col3) VALUE (Val1, Val2,Val3) Into table_name;
(D) Insert into table_name values (Col1, Col2,Col3) VALUES (Val1,Val2,Val3);

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

Question: 26

Is it possible to user 'where' clause in an insert statement?

(A) Yes
(B) No

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

Question: 27

Insert & Update both changes table's values. Can we use insert in place of update?

(A) Yes
(B) No
(C) Yes but with Joines it is possible
(D) Yes but loss of data

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

Question: 28

Correct syntax for Update Statement?

(A) Update table_name Set Col_name=Value;
(B) Update Table table_name Columns(Col1, Col2,Col3);
(C) Update into table_name (Col1, Col2,Col3) VALUES (Val1,Val2,Val3);
(D) Update table_name column Col_name=Value;

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

Question: 29

Can we use ‘IN’ operator with Where clause?

(A) Yes
(B) No

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

Question: 30

Which of the Order by query is correct one?

(A) SELECT * FROM Table Order By Column;
(B) SELECT * FROM Table Order By Column ASC;
(C) SELECT * FROM Table Order By Column DESC;
(D) All of the above

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

Question: 31

Is there any limitation in adding number of conditions in a where clause?

(A) Yes
(B) No

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

Question: 32

What is true about Descending Order?

(A) It is not possible
(B) DESC is used with Order by clause
(C) DESC is only possible with inbuilt tables
(D) DESC can 't be used in Joines

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

Question: 33

What is default value of any column when it is missing or not known?

(A) NULL
(B) Empty
(C) 0
(D) Garbage Value

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

Question: 34

Maximum number of characters a text data type can hold is?

(A) 1 GB
(B) 2 GB
(C) 4 GB
(D) 8 GB

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

Question: 35

Tinyint data type can hold only positive values?

(A) True
(B) Flase

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

Question: 36

Can we use table, column keyword to name any column?

(A) Yes
(B) No

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

Question: 37

Which one of the following is true when SQL connection is closed?

(A) All Temporary tables are dropped
(B) All Temporary tables are dropped but memory is remain alloted
(C) All Temporary table exist
(D) None of the above

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

Question: 38

What is the location of Temporary table?

(A) On disk and current DB file
(B) On disk and tempdb file
(C) On RAM and tempdb file
(D) On RAM and current DB file

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

Question: 39

A table is in BCNF if it is in 3NF and if every determinant is a following key

(A) candidate
(B) dependent
(C) normal
(D) Primary

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

Question: 40

If any table has duplicate values in any column then that table is in First Normal form?

(A) Yes
(B) No

Level: Practionar 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