Oracle (BI_ORAAPPS) Crossword Day-8

12345678910
Across
  1. 2. Scenario: I have a table DEPT having columns namely: DEPTNO, DNAME and LOC. When I enter the command SQL>SELECT * FROM DEPT; , column DNAME should not be displayed in the output. Which of the SQL*Plus COLUMN commands can help me to meet this requirement?
  2. 3. Consider the scenario: 1) Ram, working in the basement, is editing recently added library catalog entries, and fetches the data for a 2001 edition of Pride and Prejudice. Before he makes any changes, he goes to lunch. 2) Tom, working on the second floor, is working through lunch. He, coincidentally, is going through a list of books whose titles start with PRI. He pulls up the record for the very same book that's on Ram's screen, makes a fix to the author's name, and saves it to the database. 3) Ram, back from lunch, edits the summary of the book and saves it to the database. 4) Ram's change has overwritten Tom's change, and the author's name goes back to the old (wrong) value. Database _____ is solution to avoid these kinds of concurrency issues.
  3. 5. The parameter _____ INDEXES allows SQL*Loader to load data into a table with the indexes in the unusable state, prior to the load operation?
  4. 6. When the input format is invalid, say for example, data type is mismatched from within control file and data file, then that rejected record will be written to ____ file.
  5. 8. Exception ______ will be raised by UTL_FILE when, there is buffered data that has not yet been written to the file when you close it
  6. 10. Which of the SQL*Loader parameters enable you to load a specified number of records stored in the data file?
Down
  1. 1. See the given query: SQL> create table temp(name blob); What will be the output of this insert? SQL> insert into temp values('king');
  2. 4. What will be the output of the given PL/SQL code? SQL>Begin dbms_output.put('m'); dbms_output.put('a'); dbms_output.put_line('p'); dbms_output.put('s'); end; /
  3. 7. How do you send the output of your SQL* Plus session to a text operating system file called MYOUTPUT.LST?
  4. 9. Scenario: We have two tables having parent-child relationship. In order delete exiting data from within the parent table without disabling referential integrity, which SQL*Loader option should be used?