Oracle (BI_ORAAPPS) Crossword Day-3

123456789
Across
  1. 1. SELECT * FROM emp ORDER BY comm DESC; Check validity of below statements with respect to the given SELECT statement. In the above SELECT statement, records with NULL values in COMM column will be displayed at the top of the entire result set. (Answer is TRUE/FALSE)
  2. 2. Examine the SQL statement that creates SALES table: CREATE TABLE SALES (PURCHASENO NUMBER (9) CONSTRAINT PK PRIMARY KEY, CUSTID NUMBER(9) DEFAULT ‘0’, CUSTNAME VARCHAR2(12)); For which columns would an index be automatically created when you execute the above SQL statement?
  3. 5. See the given set of queries: SQL> delete from emp where 1=1; SQL>delete from emp where 2=1; SQL>delete from emp; SQL>delete emp; Answer whether all these queries will give the same output or not? (Answer is YES/NO)
  4. 8. If any table has more than one candidate key, then after choosing primary key from those candidate key, rests of candidate keys are known as an _______ keys of that table.
  5. 9. Assume we have the given entities and attributes: GUEST, HOTEL and ROOM are the entities. Address, Arrival Date, Family Name, Room Number, Floor Number, Number of Beds, Number of Parking Lots, Price are the attributes. From this list, identify the correct entity whose ‘Number of Parking Lots’ is the attribute.
Down
  1. 1. What degree of relationship best describes the following scenario for the entities: Insurance Agent, Insurance Product and Customer? Insurance Agents provide information about various Insurance Products to potential Customers.
  2. 3. Which of the data dictionary views will provide information about all database objects in database?
  3. 4. In a _____________database model, record can have more than one parent.
  4. 6. Frequent _____ operations on indexed column decrease the query performance.
  5. 7. CASCADE ON _________deletes the dependent rows in the child table when a row in the parent table is deleted.