SQL Qualification Round

12345678910111213141516171819202122232425262728293031323334353637383940
Across
  1. 2. a document, describing the official features of the SQL language
  2. 3. default user made in every container after installation
  3. 4. default pdb used to copy data and create another pdb
  4. 6. used to store or reference data
  5. 11. A graphics-based operating system interface that uses icons, menus and a mouse (to click on the icon or pull down the menus) to manage interaction with the system.
  6. 16. shows the structure of table which include name of the column, data-type of column and the nullability
  7. 18. used to sort the result-set in ascending or descending order
  8. 20. hardware in a computing device where the operating system (OS), application programs and data in current use are kept
  9. 21. dictionary views a set of database tables used to store information about a database's definition
  10. 22. A database is an organized collection of data, so that it can be easily accessed and managed.
  11. 24. default pdb with con_id 3
  12. 27. allows you to return more rows with values that match the last row in the limited result
  13. 29. translates alphanumeric characters and symbols into a computer-readable code.(Numbers)
  14. 30. used in conjunction with the SELECT keyword to retrieve data from all columns from a table
  15. 31. an acronym for the sequence of operations to be performed while simplifying the mathematical expressions.
  16. 32. a collection of database objects like tables, triggers, stored procedures, etc.
  17. 34. Name of SCOTT
  18. 35. a value which is unavailable, unassigned, unknown or not applicable.
  19. 37. basic unit of storage
  20. 38. constraint ensures that all values in a column are different
  21. 39. capability of select statement
  22. 40. used to do operations from the values of the column and a single value is returned
Down
  1. 1. useful way to distinguish the order of operations
  2. 3. used to select data from a database
  3. 5. default user to handle COntainer database
  4. 7. text-based interface that is used to operate software and operating systems .
  5. 8. used to identify the starting point to return rows from a result set
  6. 9. used to filter records
  7. 10. notations or idea to represent/express a non-changing value
  8. 12. schema name is same as
  9. 13. type of storage device
  10. 14. it is store, manage, query, and retrieve data stored in tabular format database.
  11. 15. electro-mechanical data storage device that stores and retrieves digital data
  12. 17. objects that contain organized data in a row-and-column format such as spreadsheet
  13. 19. Information collected together for reference or analysis.
  14. 23. Temporary name to a column
  15. 25. default date format
  16. 26. wildcard operator in like
  17. 27. Name of Scott's Pet
  18. 28. Father of sql
  19. 33. Name of SQL Architecture
  20. 36. the order in which Oracle Database evaluates different operators in the same expression