Tag: databases

Questions Related to databases

Maximum number of columns allowed inside an index
technology databases

  1. 12

  2. 256

  3. 128

  4. 32

Show answer
Correct Option: D

Which of the following is DDL Statement
technology databases

  1. Truncate

  2. Merge

  3. Revoke

  4. Grant

Show answer
Correct Option: A

Select the incorrect Oracle Select Statement
technology databases

  1. select distinct * from T1

  2. select C1 from T1 order by C2

  3. select distinct C1 from T1

  4. select 12*14 from T1

  5. select C1 AS 'column1",C1 AS 'column2',C2 AS 'column1' from T1.

Show answer
Correct Option: B

Which of the following is a DML Statement
technology databases

  1. Truncate

  2. Merge

  3. Revoke

  4. Grant

Show answer
Correct Option: B

We can sort by a column without present in the SELECT List
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Select Incorrect Oracle Group Function
technology databases

  1. floor

  2. sum

  3. variance

  4. stddev

Show answer
Correct Option: D

which of the following views identify the status of the view in the database
technology databases

  1. USER_VIEWS

  2. USER_TAB_COLUMNS

  3. USER_TABLES

  4. USER_OBJECTS

Show answer
Correct Option: D

ROWID is a column datatype
technology databases

  1. True

  2. False

Show answer
Correct Option: A

we can select while LOCk is on a rows
technology databases

  1. True

  2. False

Show answer
Correct Option: A

reference to sysdate,nextval,currval is allowed on constraint definition
technology databases

  1. True

  2. False

Show answer
Correct Option: A