Question 1

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

technology databases

SELECT [all] FROM Persons
SELECT Persons
SELECT *.Persons
SELECT * FROM Persons

Answer

Correct Option: D

Question 2

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

technology databases

iSQL*Plus commands manipulate table definitions in the database.
iSQL*Plus is the Oracle proprietary interface for executing SQL statements.
iSQL*Plus commands cannot be abbreviated.
iSQL*Plus commands are accesses from a browser.

Answer

Correct Option: B,D

Question 3

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?

technology databases

Use the DESCRIBE command in the EMP_DEPT VU view.
Use the DEFINE VIEW command on the EMP_DEPT VU view.
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.

Answer

Correct Option: C

Question 4

Which is an /SQL*Plus command?

technology databases

insert
update
select
describe

Answer

Correct Option: D

Question 5

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?

technology databases

Selection, projection, join
Difference, projection, join
Selection, intersection, join
Intersection, projection, join

Answer

Correct Option: A

Question 6

:new can be used in stament level trigger

technology databases

True
False

Answer

Correct Option: B

Question 7

Order by cause should be used only at end of query

technology databases

True
False

Answer

Correct Option: A

Question 8

union all is faster than union

technology databases

True
False

Answer

Correct Option: A

Question 9

bitmap index should be created on columns which have high cardinality

technology databases

True
False

Answer

Correct Option: B

Question 10

what is max length of table name in oracle

technology databases

50
30
20
40

Answer

Correct Option: B

Question 11

Oracle is written in which language

technology databases

sql
java
unix
plsql

Answer

Correct Option: B

Question 12

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

technology databases

1/1/0051
1/1/1951
1/1/2051
1/1/9951

Answer

Correct Option: C

Question 13

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

technology databases

1/1/2051
1/1/1951
1/1/0051
1/1/9951

Answer

Correct Option: B

Question 14

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

technology databases

True
False

Answer

Correct Option: B

Question 15

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

technology databases

True
False

Answer

Correct Option: A

Question 16

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

technology databases

Error: invalid identifier
Error : Invalid Character
NULL
#

Answer

Correct Option: D

Question 17

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

technology databases

Error : Invalid Character
Error : Invalid identifier
#
NULL

Answer

Correct Option: A

Question 18

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

technology databases

True
False

Answer

Correct Option: A

Question 19

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

technology databases

1 row
NULL
30 rows
3 rows
2 rows

Answer

Correct Option: D

Question 20

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

technology databases

1 row
NULL
0 row
3 rows
30 rows
2 rows

Answer

Correct Option: A

Description: databases Online Quiz - 85
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 85

Find more quizzes from top tags