SQL Treasure Hunt
Across
- 3. A Database is an Organized Collection of Data, so that it can be easily accessed and managed.
- 5. One of the capabilities of SQL Select Statement.
- 11. Basic unit of storage.
- 13. User Supplied Value or Constant in SQL.
- 15. Starter Database with CON_ID 3.
- 18. ______ is an electro-mechanical data storage device.
- 21. ________ make the basic query block more powerful, and they are used to manipulate data values.
- 23. Name of Scott's daughter's Pet.
- 25. _________ is a synonym for DISTINCT in Oracle Database.
- 26. Information collected together for reference or analysis.
- 28. A database type which is used to store, manage, query, and retrieve data that is stored in a tabular format.
- 30. Schema name is same as ______.
- 32. Type of Storage Device.
- 33. Objects that contain organized data in a Row-And-Column format such as spreadsheet.
- 35. Temporary or Alternate Name to a Column.
- 36. ______ clause in SQL Statement is used to retrieve data from one or more tables.
- 37. Clause used to Filter Records.
- 38. _________ are used to override the rules of precedence.
- 40. Father Of RDBMS.
Down
- 1. The hardware in a computing device where the operating system (OS), application programs, and data in current use are kept is known as memory.
- 2. Shows the Structure of Table Which Include Name of The Column, Data-Type of Column and The Null-ability.
- 4. ________ set of keywords that returns additional rows with the same sort key as the last row fetched.
- 5. An Oracle-supplied PDB can be used as a template to create another PDB.
- 6. A value which is Unavailable, Unassigned, Unknown or not applicable.
- 7. First Container in an Oracle Database 12c and above.
- 8. Administrative accounts in each container of Oracle Database.
- 9. Default DATE display format.
- 10. Tables, Views, Sequence, Indexes, Synonyms are collectively called as?
- 12. A set consists of three views containing similar information and distinguished from each other by their prefixes.
- 14. Translates alphanumeric characters and symbols into a Computer-Readable Code. (Numbers)
- 15. ______ clause is used to specify the number of rows to skip before row limiting begins.
- 16. Text-Based Interface that is used to Operate Software and Operating Systems.
- 17. You can use the ______ identifier to search for the actual wildcard symbols.
- 19. Used in Conjunction with The SELECT Keyword to Retrieve Data from all Columns of a Table.
- 20. SQL Developer is a _ _ _ Tool. (Type of Interface)
- 22. Used to Sort the Result-Set in Ascending or Descending Order.
- 24. First Name Of SCOTT.
- 27. SQL is a popular relational database language first standardized in 1986 by the _____.
- 29. An acronym for the Sequence of Operations to be performed while simplifying the Mathematical Expressions.
- 31. A database option that enables you to create multiple PDBs in a CDB.
- 34. The order in which Oracle Database evaluates different operators in the same expression.
- 39. A collection of Database Objects like Tables, Triggers, Stored Procedures, Etc.