CppBuzz.com
  
Home C C++ Java Python Perl PHP SQL JavaScript Linux Online Test Forum

Home » Sql Objective Questions

Sql Objective Questions - 57


Question: 1

(A) Depends on no of Columns
(B) Only 2
(C) Only 1
(D) Depends on DBA

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



Question: 2

(A) Primary Key
(B) Not Null
(C) Check
(D) Union

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



Question: 3

(A) IN
(B) LIKE
(C) BETWEEN
(D) IS

Forum
Beginner Like[Posted by: Admin | Chicago, USA]



Question: 4

(A) IN
(B) BETWEEN
(C) %
(D) OR

Forum
Beginner 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

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



Question: 6

(A) '
(B) "
(C) //
(D) --

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



Question: 7

(A) True
(B) False

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



Question: 8

(A) True
(B) False

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



Question: 9

(A) True
(B) False

Forum
Beginner 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

Forum
Practionar 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

Forum
Beginner 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

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



Question: 13

(A) Extract the unique course ids(cid) where student receive the grade C in the course
(B) Extract the course ids(cid) where student receive the grade C in the course
(C) Error
(D) None of the above

Forum
Beginner Select[Posted by: Admin | Chicago, USA]



Question: 14

(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

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



Question: 15

(A) COMMIT
(B) ROLLBACK
(C) SAVEPOINT
(D) All of the these

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



Question: 16

(A) 1, 3 and 4
(B) 2, 3 and 4
(C) 3 and 4
(D) 1 only

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



Question: 17

(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

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



Question: 18

(A)
(B)

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



Question: 19

(A)
(B)

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



Question: 20

(A) Datetimeoffset
(B) Date
(C) Time
(D) All of the Above

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



Question: 21

(A) Text
(B) Image
(C) Blob
(D) None of the Above

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



Question: 22

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

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



Question: 23

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

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



Question: 24

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

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



Question: 25

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

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



Question: 26

(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);

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



Question: 27

(A) Yes
(B) No

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



Question: 28

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

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



Question: 29

(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;

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



Question: 30

(A) Yes
(B) No

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



Question: 31

(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

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



Question: 32

(A) Yes
(B) No

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



Question: 33

(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

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



Question: 34

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

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



Question: 35

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

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



Question: 36

(A) True
(B) Flase

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



Question: 37

(A) Yes
(B) No

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



Question: 38

(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

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



Question: 39

(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

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



Question: 40

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

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



Question: 41

(A) Yes
(B) No

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



Question: 42

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

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



Question: 43

(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

Forum
Practionar Union[Posted by: Admin | Chicago, USA]



Question: 44

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

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



Question: 45

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

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



Question: 46

(A) Yes
(B) No

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



Question: 47

(A) Yes
(B) No

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



Question: 48

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

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



Question: 49

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

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



Question: 50

(A) Yes
(B) No

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



Question: 51

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

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



Question: 52

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

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



Question: 53

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

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



Question: 54

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

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



Question: 55

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

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



Question: 56

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

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



Question: 57

(A) Yes
(B) No

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



[Contribute Here]