SQL

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