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

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

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?

Which is an /SQL*Plus command?

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?

:new can be used in stament level trigger

Order by cause should be used only at end of query

union all is faster than union

bitmap index should be created on columns which have high cardinality

what is max length of table name in oracle

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

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

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

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

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

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

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

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

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