• databases Online Quiz - 220
Back
0

databases Online Quiz - 220

Description: databases Online Quiz - 220
Number of Questions: 20
Created by:
Tags: databases
Start the Quiz
Attempted 0/20 Correct 0 Score 0
‹
›

Order by clause cannot have aliases of columns....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

The default sorting order of SQL statement is ASC....
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Null values in select statement with descending order will apppear at the top of the list....
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Arithmetic functions returns a NULL for a NULL input...

technology databases

  1. True

  2. False

Show answer
Correct Option: A

password files are mandatory Disk components of Oracle....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

To write a query that performs an outer join of tables A and B and returns all rows from B, You need to write

technology databases

  1. any outer join

  2. left outer join

  3. cross join

  4. right outer join

Show answer
Correct Option: D

Which is valid Oracle constraint type ?

technology databases

  1. CASCADE

  2. CONSTANT

  3. CHECK

  4. NONUNIQUE

Show answer
Correct Option: C

Which is an iSQL*Plus command ?

technology databases

  1. DESCRIBE

  2. RENAME

  3. DELETE

  4. INSERT

Show answer
Correct Option: A

Which is a DML Statement ?
technology databases

  1. DROP

  2. MERGE

  3. CREATE

  4. COMMIT

Show answer
Correct Option: B

Which is a character manipulation functions ?

technology databases

  1. CASE

  2. TRUNC

  3. REPLACE

  4. MOD

Show answer
Correct Option: C

The date got from SYSDATE is date according to client machine....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Cast function converts datatypes....
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Months_between will return negative numbers....
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Newfoundland standard time uses daylight saving...
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Dump function takes the backup of Oracle....
technology databases

  1. True

  2. False

Show answer
Correct Option: B

AST,GMT,XST..... can be used as parameters for which function..?
technology databases

  1. next_day()

  2. add_months()

  3. new_time()

  4. old_year()

Show answer
Correct Option: C

To change the display of date information, we have to use....

technology databases

  1. National Language Set

  2. International Language Set

  3. Oracle Language Set

  4. SQL-99 compliant Language Set

Show answer
Correct Option: A

Which one is not Oracle Function...?
technology databases

  1. to_char

  2. to_number

  3. to_string

  4. to_date

Show answer
Correct Option: C

Valid time zone names can be found in ....

technology databases

  1. v$timezone_names

  2. v$timezone

  3. user_timezone_names

  4. dba_timezone_names

Show answer
Correct Option: A

Which function will take input parameter...?
technology databases

  1. tz_offse

  2. sessiontimezone

  3. systemstamp

  4. sysdate

Show answer
Correct Option: A
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3600 Quizzes
119725 Questions
 technology
307 Quizzes
36705 Questions
 sports
962 Quizzes
19148 Questions
 history
1124 Quizzes
12955 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions