CppBuzz.com
  
Home C C++ Java Python Perl PHP SQL Javascript Linux Forum

You are here : 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

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



Question: 2

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

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



Question: 3

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

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



Question: 4

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

DiscussOnForum
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

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



Question: 6

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

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



Question: 7

(A) True
(B) False

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



Question: 8

(A) True
(B) False

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



Question: 9

(A) True
(B) False

DiscussOnForum
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

DiscussOnForum
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

DiscussOnForum
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

DiscussOnForum
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

DiscussOnForum
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

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



Question: 15

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

DiscussOnForum
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

DiscussOnForum
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

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



Question: 18

(A)
(B)

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



Question: 19

(A)
(B)

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



Question: 20

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

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



Question: 21

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

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



Question: 22

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

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



Question: 23

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

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



Question: 24

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

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



Question: 25

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

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

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



Question: 27

(A) Yes
(B) No

DiscussOnForum
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

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

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



Question: 30

(A) Yes
(B) No

DiscussOnForum
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

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



Question: 32

(A) Yes
(B) No

DiscussOnForum
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

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



Question: 34

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

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



Question: 35

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

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



Question: 36

(A) True
(B) Flase

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



Question: 37

(A) Yes
(B) No

DiscussOnForum
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

DiscussOnForum
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

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



Question: 40

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

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



Question: 41

(A) Yes
(B) No

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



Question: 42

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

DiscussOnForum
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

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



Question: 44

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

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



Question: 45

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

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



Question: 46

(A) Yes
(B) No

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



Question: 47

(A) Yes
(B) No

DiscussOnForum
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

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



Question: 49

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

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



Question: 50

(A) Yes
(B) No

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



Question: 51

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

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



Question: 52

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

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



Question: 53

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

DiscussOnForum
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

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



Question: 55

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

DiscussOnForum
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

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



Question: 57

(A) Yes
(B) No

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



[Contribute Here]