Home » Sql Objective Questions
Sql Objective Questions - 56
Questions on Index, Insert, Primary key, Inner joines, Outer Joines, Delete, Union, Operators, Update, Having Clause, Truncate, Candiate Key & Constraint etc.
Question: 1
(A) Depends on no of Columns
(B) Only 2
(C) Only 1
(D) Depends on DBA
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 2
(A) Primary Key
(B) Not Null
(C) Check
(D) Union
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 3
(A) IN
(B) LIKE
(C) BETWEEN
(D) IS
Level: Beginner Category: Like
[Posted by: Admin | Chicago, USA]
Question: 4
(A) IN
(B) BETWEEN
(C) %
(D) OR
Level: Beginner Category: Between
[Posted by: Admin | Chicago, USA]
Question: 5
(A) Return rows when there is at least one match in both tables
(B) Return all rows from the left table, even if there are no matches in the right table
(C) Return all rows from the right table, even if there are no matches in the left table
(D) Return rows when there is a match in one of the tables
Level: Practionar Category: Joins
[Posted by: Admin | Chicago, USA]
Question: 6
(A) '
(B) "
(C) //
(D) --
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 7
(A) True
(B) False
Level: Practionar Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 8
(A) True
(B) False
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 9
(A) True
(B) False
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 10
(A) select, group by, where, having
(B) select, where, having, group byselect, having, where, group by
(C) select, having, where, group by
(D) select, where, group by, having
Level: Practionar Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 11
(A) It can take a value more than once
(B) It can’t take null values
(C) It can take null values
(D) None of these
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 12
(A) Primary key cannot be a date variable whereas unique key can be
(B) Primary key can take null values but unique key cannot null values
(C) You can have only one primary key whereas you can have multiple unique keys
(D) None of the above
Level: Practionar Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 13
(A) It is usually slower than DELETE command
(B) There is no comparison between DELETE & TRUNCATE
(C) It is usually faster than DELETE command
(D) None of these
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 14
(A) COMMIT
(B) ROLLBACK
(C) SAVEPOINT
(D) All of the these
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 15
(A) 1, 3 and 4
(B) 2, 3 and 4
(C) 3 and 4
(D) 1 only
Level: Practionar Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 16
(A) We need to assign a datatype to each column
(B) We have flexibility in SQL. We can assign a datatype to column even after creating a table
(C) It is mandatory to insert atleast a single row while creating a table
(D) None of the above
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 17
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 18
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 19
(A) Datetimeoffset
(B) Date
(C) Time
(D) All of the Above
Level: Beginner Category: Syntax
[Posted by: Admin | Chicago, USA]
Question: 20
(A) Text
(B) Image
(C) Blob
(D) None of the Above
Level: Practionar Category: Syntax
[Posted by: Admin | Chicago, USA]