0

databases Online Quiz - 85

Description: databases Online Quiz - 85
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SELECT [all] FROM Persons

  2. SELECT Persons

  3. SELECT *.Persons

  4. SELECT * FROM Persons


Correct Option: D

Which two are attributes of iSQL*Plus? (Choose two)

  1. iSQL*Plus commands manipulate table definitions in the database.

  2. iSQL*Plus is the Oracle proprietary interface for executing SQL statements.

  3. iSQL*Plus commands cannot be abbreviated.

  4. iSQL*Plus commands are accesses from a browser.


Correct Option: B,D
  1. Use the DESCRIBE command in the EMP_DEPT VU view.

  2. Use the DEFINE VIEW command on the EMP_DEPT VU view.

  3. Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.

  4. Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.


Correct Option: C
  1. insert

  2. update

  3. select

  4. describe


Correct Option: D

union all is faster than union

  1. True

  2. False


Correct Option: A

bitmap index should be created on columns which have high cardinality

  1. True

  2. False


Correct Option: B

what is max length of table name in oracle

  1. 50

  2. 30

  3. 20

  4. 40


Correct Option: B

Oracle is written in which language

  1. sql

  2. java

  3. unix

  4. plsql


Correct Option: B

Answer the below query.. select to_date('01-01-51','DD-MM-YY') from dual ;

  1. 1/1/0051

  2. 1/1/1951

  3. 1/1/2051

  4. 1/1/9951


Correct Option: C

The out put of the below two queries will be same 1.select to_date('01-01-99','DD-MM-YY') from dual 2.select to_date('01-01-99','DD-MM-RR') from dual

  1. True

  2. False


Correct Option: B

The output of the below two queries will be same. 1.select to_date('01-01-00','DD-MM-YY') from dual 2.select to_date('01-01-00','DD-MM-RR') from dual

  1. True

  2. False


Correct Option: A

Output of the below query will be.. select '#' from dual;

  1. Error: invalid identifier

  2. Error : Invalid Character

  3. NULL

  4. #


Correct Option: D

Output of the below query.. select # from dual;

  1. Error : Invalid Character

  2. Error : Invalid identifier

  3. #

  4. NULL


Correct Option: A

Output of the below two queries would be same.. 1.select 1 from dual; 2.select '1' from dual;

  1. True

  2. False


Correct Option: A

How many rows records the following query will display.. select * from TEMP where rownum between 0 and 3 ? N.R. Temp table has 30 records

  1. 1 row

  2. NULL

  3. 30 rows

  4. 3 rows

  5. 2 rows


Correct Option: D

How many rows records the following query will display.. select * from TEMP where rownum in (1,3); N.R. Temp table has 30 records

  1. 1 row

  2. NULL

  3. 0 row

  4. 3 rows

  5. 30 rows

  6. 2 rows


Correct Option: A
- Hide questions