Q1. What are the various constraints that can be applied to a Table? Answer. NULL, NOT NULL, CHECK, DEFAULT, Primary Key & Foreign Key. Q2. What is the purpose of a CLUSTER? Answer. Oracle does not allow a user to specifically locate tables, since that is a part of the function of the RDBMS. However,Continue reading “Tables & External Tables”
Tag Archives: Written Test
Written Test Questions
Q1. From the following SQL Statements which one is the most reliable? Answer. E] is the most reliable statement. Q2. From the following statements which one will you prefer to use & why? Answer. B] as select will consume more time than PL/SQL code. Q3. Which relational operators in where clause results in non-usage ofContinue reading “Written Test Questions”
TechOraFAQ 