• databases Online Quiz - 236
Back
0

databases Online Quiz - 236

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

What is the Output ?

technology databases

  1. Returns current date

  2. Generate the access plan

  3. Suggests performance hints that can be implemented

  4. Drop and create the stored procedure

Show answer
Correct Option: D

The table rows and column are also known as?

technology databases

  1. Attributes and Fields

  2. Fields and Records

  3. Records and Fields

  4. Fields and Attributes

Show answer
Correct Option: C

Which of the following SQL functions can operate on any datatype?

technology databases

  1. TO_CHAR

  2. TO_DATE

  3. MAX

  4. LPAD

Show answer
Correct Option: C

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) TO_CHAR - This function is used to convert a numeric or date expression to a character string. It cannot operate on any datatype, as it is specifically designed to convert numeric or date expressions.

Option B) TO_DATE - This function is used to convert a character string to a date value. It cannot operate on any datatype, as it is specifically designed to convert character strings to dates.

Option C) MAX - This function is used to return the maximum value from a set of values. It can operate on any datatype, including numeric, character, and date types. This makes it the correct answer to the question.

Option D) LPAD - This function is used to left pad a string with a specified character. It can operate on character strings only, and not on any other datatype.

The correct answer is Option C) MAX. This option is correct because the MAX function can operate on any datatype, whereas the other options are specific to certain datatypes.

Normalization is…?
technology databases

  1. A special way of selecting data

  2. The process of adding primary key to a table

  3. The process of arranging information stored in a database in a way, which removes redundancy and ambiguity.

  4. A special way of retrieving data

Show answer
Correct Option: C

which is also known as n-dimensional cross-tabulation ?

technology databases

  1. Rollback

  2. Rollup

  3. CUBE

  4. Commit

Show answer
Correct Option: C

Retrieving data end with "abc" which wildcard use with like keyword?

technology databases

  1. abc%

  2. %abc_

  3. %abc

  4. %abc%

Show answer
Correct Option: C

which is also known as "n dimensional cross tabulation"?

technology databases

  1. Rollup

  2. Rollback

  3. CUBE

  4. Commit

Show answer
Correct Option: C

which commands is combination of unions ?

technology databases

  1. Rollup

  2. Rollback

  3. CUBE

  4. I and III both

Show answer
Correct Option: D

On which data type indexes can not be created.

technology databases

  1. NUMBER

  2. LONG

  3. VARCHAR2

  4. RAW

Show answer
Correct Option: B

what are the minimum values that can be assigned to POSITIVE , NATURAL and SIGNTYPE data types respectively.

technology databases

  1. 1 , 1 and 1

  2. 0 , 1 and 0

  3. 1 , 0 and -1

  4. 0 , 0 and -1

Show answer
Correct Option: C

which of the following is TRUE.

technology databases

  1. NUMBER is the subtype of INTEGER data type

  2. PLS_INTEGER is the subtype of BINARY_INTEGER

  3. POSITIVE data type is defined in SYS package.

  4. None of the above.

Show answer
Correct Option: B

which of the following is TRUE about collections.

technology databases

  1. Only nested tables need initilization.

  2. Index-by tables is a persistent collection

  3. nested tables are known as associative arrays.

  4. VARRAYs hold fixed number of elements

Show answer
Correct Option: D

Which of the following is not a subtype of NUMBER data type.

technology databases

  1. NATURAL

  2. NATURALN

  3. POSITIVE

  4. SIGNTYPE

Show answer
Correct Option: B

Select the correct pseudocolumns

technology databases

  1. CURRVAL

  2. LEVEL

  3. ROWNUM

  4. COUNT

Show answer
Correct Option: A,B,C

Can the ORDER BY clause use column index of the select clause to sort the fetched records.

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Choose the functions that can be used with NULL values

technology databases

  1. NVL

  2. NULLIF

  3. DECODE

  4. COALESCE

Show answer
Correct Option: A,B,D

Which clause use CASCADE CONSTRAINTS in the syntax?

technology databases

  1. ALTER TABLE DROP COLUMN

  2. ALTER TABLE DROP CONSTRAINT

  3. ALTER TABLE DISABLE CONSTRAINT

  4. -

Show answer
Correct Option: A

Choose the database objects
technology databases

  1. TABLE

  2. VARCHAR2

  3. SEQUENCE

  4. INDEX

Show answer
Correct Option: A,C,D

The file extension .xlt gets created when you save the file as

technology databases

  1. an XML file

  2. a Web Page

  3. an excel template

  4. a text file

Show answer
Correct Option: C

Which command will cause an automatic commit to occur?

technology databases

  1. CONNECT

  2. RENAME

  3. INSERT

  4. DELETE

Show answer
Correct Option: B
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
963 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
598 Quizzes
13441 Questions
 biology
1160 Quizzes
12174 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
490 Quizzes
9892 Questions
 maths
518 Quizzes
9324 Questions
 softskills
0 Quizzes
7131 Questions