Oracle Database Developer Question:
Download Job Interview Questions and Answers PDF
Explain Database Table in Oracle?
Answer:
A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a column name, such as employee_id, last_name, and job_id; a datatype, such as VARCHAR2, DATE, or NUMBER; and a width. The width can be predetermined by the datatype, as in DATE. If columns are of the NUMBER datatype, define precision and scale instead of width. A row is a collection of column information corresponding to a single record.
Download Oracle Database Developer Interview Questions And Answers
PDF
Previous Question | Next Question |
Explain Database Schema in Oracle? | Explain Table Index in Oracle? |