Oracle (BI_ORAAPPS) Crossword Day-4

12345678910
Across
  1. 2. This is one of the options of CREATE VIEW syntax which creates a view regardless of whether or not the base tables exist!
  2. 4. Examine the code below: SQL> CREATE TABLE TOTAL_COUNT (ID NUMBER (1) ) ; SQL> insert into TOTAL_COUNT(id) values (1); SQL> insert into TOTAL_COUNT(id) values (2); SQL> insert into TOTAL_COUNT(id) values (null); SQL> insert into TOTAL_COUNT(id) values (null); SQL> commit; What will be the output after executing the below query: SQL>select count(id) from TOTAL_COUNT where id is null; (Spell the answer)
  3. 7. Examine the code below: SQL>create table EMP (id number, a1 varchar2 (25) ); SQL>Create sequence s1 starts with 1 increment by 1; SQL>insert into EMP values (s1.nextval, ‘Hello’); SQL>alter table EMP set unused column id; What will be the output of below query for inserting sequence value into a unused column: SQL>insert into EMP values ( s1.nextval, ‘error’ );
  4. 9. Examine the below code: SQL>create table MERGETAB (x int, y int); SQL>insert into MERGETAB values (1, 1); Identify how many rows will be merged with the execution of below code: SQL>merge into MERGETAB t1 using MERGETAB t2 on (t1.x = t2.x) when matched then update set t1.y = t2.y when not matched then insert values (t2.x, t2.y);
  5. 10. _____Operators complement joins by providing alternative ways of combining data from multiple sources.
Down
  1. 1. You need to perform certain data manipulation operations through a view called EMP_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created). Using which data dictionary, can you obtain the definition of the view?
  2. 3. ____ Command is used to change "SCOTT" into "Nielsen" in the "LastName" column in the Persons table.
  3. 5. The locks acquired by the transaction are release with ____ command.
  4. 6. UNION ALL will perform better than UNION when you're not concerned about eliminating ______ records because you're avoiding an expensive distinct sort operation.
  5. 8. You have owned a table EMP. You want to give all privileges to user SCOTT on that table. So, you need to fire the command as SQL> GRANT ___ on EMP to SCOTT;