databases Online Quiz - 209
|Description: databases Online Quiz - 209|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
what is the maximum length of all Oracle Objects?
In Oracle can we do any DMLs in a function which is called from a select statement?
In Oracle, is the following Anonymous block is valid? Declare Begin End;
In an Outer Join, what happens to columns that are not matched?
User_Source table contains code for which all Objects?
For which of these constraints, an unique index is automatically created while creating constraints?
Which of the following clause enables to drop the foreign key constraints of the child table while dropping the parent table?
What is the difference between varchar and varchar2 data types?
How many columns are presented after executing this query:SELECT address1||','||address2||','||address2 "Adress" FROM employee;
Which Oracle access method is the fastest way for Oracle to retrieve a single row?
To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
Which character is used to continue a statement in SQL*Plus?
When a user creates an object without a TABLESPACE clause, where will Oracle store the segment?
The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?
Which character function can be used to return a specified portion of a character string
Which command will delete all data from a table and will not write to the rollback segment?
Which of the following can be a valid column name
Teradata has been called a __________ architecture.
A column of a table is declared as NUMBER(10,2).For which of the following values oracle returns an error