Oracle (BI_ORAAPPS) Crossword Day-1

12345678910
Across
  1. 1. Assume that in a Production database, we have User Account "TEST" with many database objects, structures, relationships, etc. So, this user is also interchangeably termed as ______ present in the given database.
  2. 5. COMMTI, ROLLBACK and SAVEPOINT are ________ Control Language Commands.
  3. 7. When the below mentioned query is executed, what would be the output? (Do spell the answer) SQL>Select 10 from dual;
  4. 8. Consider the question "How many books does SCOTT own?" The answer may be "zero" or "number of books"(as we do not know how many he owns, or doesn't own). In a database table, the column reporting this answer would start out with no value and it would not be updated with the value "zero" until we have ascertained that SCOTT owns no books.What should we insert for such a column if there is a lack of value?
  5. 9. SELECT empno, ename FROM emp WHERE empno = 1001 OR empno = 1002 OR empno = 1003; Which other operator can replace the OR condition in the WHERE clause for the queries having filter condition?
  6. 10. This is a single row table that is used for ad hoc queries and calculations.
Down
  1. 2. In many applications, it is crucial to ensure that once a failure has occurred and has been detected, the data are restored to the consistent state existed prior to the failure. This is called as _____ which is one of the ACID transaction properties.
  2. 3. This SQL*Plus command displays the most recent script executed.
  3. 4. See these examples: (1) If an employee is entered with an employee_id value of 123, the database should not allow another employee to have an ID with the same value. (2) If you have an employee_rating column intended to have values ranging from 1 to 5, the database should not accept a value of 6. All these business rules ensure data ________ in the database.
  4. 6. Scenario:A shop has the same customer's name appearing several times if that customer has bought several different products at different dates. So, customer's details appear multiple times repeatedly in a database for a variety of reasons. Here in the given database systems, Data ____ is the issue.