Innovative Creation

        SQL Concept Questions &Answers

1.____________command sets the top title for each page of a report

1. Ttitle
2. Btitle
3. Title
4. Nothing

Ans:a

2.___________command sets the bottom title for each page of a report

1. Ttitle
2. Btitle
3. Title
4. Nothing

Ans:b

3. ________command give4s SQLPlus a variety of instruction on the heading format and treatment of a column.

1. Column
2. Row
3. Break
4. Not the above

Ans:a

4.__________command tells SQL Plus where to put spaces between sections of a report

1. break on
2. break
3. Space
4. Brk

Ans:a

5.__________ makes SQL Plus calculate the sub totals

1. Compute sum
2. Compute total
3. Compute
4. Calculate

Ans:a

6. ___________sets the maximum  number of character allowed on any line of the report

1. Set break
2. Set linesize
3. Set pagesize
4. Nothing

Ans:b

7.___________ sets the maximum  number of lines per page

1. Set break
2. Set linesize
3. Set pagesize
4. Nothing

Ans:c

8.__________ sets the number of blank lines between pages

1. Set break
2. Set linesize
3. Set pagesize
4. Set newpage

Ans:d

9.SPOOL means_________________

1. Simultaneous peripheral Operation OnLine
2. Same peripheral Operation On Line
3. Sequence peripheral Operation On Line
4. Not the above

Ans:a

10.                    ___________ moves a report we would normally see displayed on the screen into a file.

1. SPOOL
2. SQL Plus
3. Server
4. Not the Above

Ans: a

11.                    _____________- marks the beginning & ending of a comment

1. /**/
2. /++/
3. /*/
4. /||/

Ans:a

12.                    /**/ is similar to _____________

1. Equal
2. Less
3. Break
4. Remark

Ans:d

13.                    __________ marks the beginning of an inline comment within a SQL Query

1. __
2. /**/
3. /??/
4. /&*/

Ans:a

14.                    ___________ treats everything from the mark to the end of the line as a comment

1. __
2. /**/
3. /??/
4. /&*/

Ans:a

15.                    __________ makes the screen display stop between pages of display

1. Set break
2. Set pause
3. Set stop
4. Not the above

Ans:b

16.                    __________ saves the SQL Query we’re creating into the file of out choice

1. Store
2. Commit
3. Save
4. STT

Ans:c

17.                    ___________ sends any command to the host operating system

1. Host
2. Server
3. Network
4. Nothing

Ans:a

18.                    ___________ tells SQL Plus to follow (execute) the instruction we’ve saved in a file.

1. Start or @
2. Start
3. @
4. Start and @

Ans:a

19.                    ___________ pops out of SQL Plus and into an editor of our choice

1. Ed
2. ED
3. Edit
4. EDT

Ans:c

20.                    _____________ tells SQL Plus the name of the editor of our choice

1. Define
2. Editor
3. Define_editor
4. Defineeditor

Ans:c

21.                    ______________ terminates SQL Plus

1. EXIT
2. QUIT
3. Exit Only
4. Exit or Quit

Ans:d

22.                    To make report header we can use __________________

1. Report header
2. Header
3. Repheader
4. Report_header

Ans:c

23.                    To make report footer we can use __________________

1. Report footer
2. footer
3. Repfooter
4. Report_ footer

Ans:c

24.                    _________ will delete just what is on the current line

1. Del
2. Delete
3. Remove
4. Clear

Ans:a

25.        If we would like to add something to the current line we can use the _____________ command

1. Add
2. New
3. Append
4. AAppend

Ans:c

26.                    To clear the columns we should use __________

1. Remove column
2. Clear columns
3. Delete columns
4. Del columns

Ans:b

27.                    To clear the breaks we should use __________

1. Remove breaks
2. Clear breaks
3. Delete breaks
4. Del breaks

Ans:b

28.                    To clear the computes we should use __________

1. Remove computes
2. Clear computes
3. Delete computes
4. Del computes

Ans:b

29.                    ____________ data type for fixed length characters

1. Char
2. Varchar
3. Varchar2
4. Number

Ans:a

30.                    ____________ data type for variable length characters

1. Char
2. Character
3. Varchar2
4. Number

Ans:c

31.                    _________________ is synonymous to ____________

1. Varchar2, varchar
2. Varchar,varchar2
3. Char, number
4. Nothing

Ans:a

32.        Oracle uses ___________________mark to denote the beginning & end of any literal string

1. ‘’
2. “”
3. :
4. ;

Ans:a

33.        The output of LOWER(ABCD) ____________

1. Abcd
2. AbcD
3. ABCD
4. abcd

Ans:d

34.        The output of UPPER(abcd) ____________

1. Abcd
2. AbcD
3. ABCD
4. abcd

Ans:c

35.        _________ function is used to concatenate two strings

1. ||
2. +
3. ++
4. &&

Ans:a

36.        __________ returns the decimal representation in the database character set of the first character of the string

1. ASCII
2. ANSI
3. EBCD
4. Impossible

Ans:a

37.        ___________  returns the character having  the binary equivalent to the string

1. Binary
2. CHR
3. Chr
4. EQU

Ans:b

38.        ____________ it concatenates two string together

1. CONCAT
2. Concate
3. Concatenate
4. Merge

Ans:a

39.                    __________capitalizes the first character of a word or series of words

1. INITCAP
2. INTCap
3. CAP
4. CAPITAL

Ans: a

40.                    ___________finds the location of a character in a string

1. STRIN
2. String Loc
3. INSTR
4. None of the above

Ans:c

41.                    ___________ tells the number of charcter in a string

1. Size
2. LENGTH
3. Str len
4. Strlength

Ans: b

42.                    ___________ converts the upper case to Lower case

1. LOWER
2. UPPER
3. LOWERCASE
4. UPPERCASE

Ans:a

43.                     ___________ converts the lower case to upper case

1. LOWER
2. UPPER
3. LOWERCASE
4. UPPERCASE

Ans:b

44.                    ___________ makes a string a certain langth by adding a certain set of characters to the left

1. LPAD
2. RPAD
3. LTRIM
4. RTRIM

Ans:a

45.                    ___________ makes a string a certain length by adding a certain set of characters to the right

1. LPAD
2. RPAD
3. LTRIM
4. RTRIM

Ans:b

46.                    _____________ trims all the occurrences of spaces in left side of a string

1. Ltrim
2. Rtrim
3. Trim
4. LRtrim

Ans:a

47.                    _____________ trims all the occurrences of spaces in right side of a string

1. Ltrim
2. Rtrim
3. Trim
4. LRtrim

Ans:b

48.                    _____________ trims all the occurrences of spaces in both side of a string

1. Ltrim
2. Rtrim
3. Trim
4. LRtrim

Ans:c

49.                    ____________ finds words that sound like the example specified.

1. SOUND
2. SOUNDEX
3. SoundExam
4. SUNDEX

Ans:b

50.                    ____________ clips out a piece of a string

1. SUBSttrin
2. SUBSTR
3. STRINGSUB
4. STRING2

Ans:b

51.                    To _______ and __________ string have to use LPAD, RPAD, LTRIM,RTRIM,TRIM,SUBSTR

1. Cut, paste
2. Cut
3. Paste
4. Copy

Ans:a

52.