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

With SQL, how do you select all the columns from a table named "Persons"?

  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

You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?

  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

Which is an /SQL*Plus command?

  1. insert

  2. update

  3. select

  4. describe


Correct Option: D

Evaluate this SQL statement: SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT_NAME. FROM EMP e, DEPARTMENT d WHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID; In the statement, which capabilities of a SELECT statement are performed?

  1. Selection, projection, join

  2. Difference, projection, join

  3. Selection, intersection, join

  4. Intersection, projection, join


Correct Option: A

:new can be used in stament level trigger

  1. True

  2. False


Correct Option: B

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

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

  1. 1/1/2051

  2. 1/1/1951

  3. 1/1/0051

  4. 1/1/9951


Correct Option: B

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
- Hide questions