Login / Signup

Question

What is the primary purpose of a `SEQUENCE` in SQL?

A To enforce unique values in a column, similar to a primary key.

B To automatically generate unique numeric values, typically for primary keys.

C To store a collection of related data in a specific order.

D To speed up data retrieval operations by creating a lookup table.

E To restrict data access for security purposes.

Practice Next

More SQL Questions

Which SQL keyword is used to remove duplicate records from a query result?
Which SQL clause is used to filter results after a GROUP BY operation?
Given a table employees(id, dept_id, salary), which query returns departments with average salary greater than overall average across the company?
In normalization, which normal form removes transitive dependencies?
Which SQL function is used to calculate the average of a numeric column?
What will be the output of the following SQL query? SELECT COUNT(*) FROM Transactions WHERE Amount > 10000 AND Status = 'Completed';
What is the output of this SQL snippet if the price column contains NULL values? SELECT SUM(price) FROM products;
Which SQL clause is used for filtering rows?
Which SQL keyword is used to eliminate duplicate rows in a query result?
What is the primary purpose of a `SEQUENCE` in SQL?

Hey! Ask a query

ask-question