Database Management Quiz

What is the primary purpose of using Data Definition Language (DDL) in database management?

• To modify the data in the database

• To define and manage the structure of the database

• To enhance the security of the database

• To create backup copies of the database

Which of the following is NOT a task you can perform with DDL?

• Create basic tables

• Define constraints

• Query data from the database

• Modify table structure

What does the term 'Truncate Tables' specifically refer to in database management?

• Deleting specific rows from a table

• Removing all rows from a table without deleting the table itself

• Changing the table's structure

• Creating a duplicate of the table

When creating a table based on an existing table, what aspect of the original table is typically utilized?

• The original data only

• The constraints only

• The structure and constraints

• The table name only

What does DDL stand for in the context of SQL?

• Data Definition Language

• Data Duplication Language

• Data Development Language

• Detailed Definition Language

Which SQL operation is not a part of DDL as mentioned in the image?

• Update

• Create

• Rename

• Truncate

What is the primary purpose of Data Definition Language (DDL)?

• To modify the data in a database

• To query data from a database

• To change the structure of the database

• To create backups of a database

What is the correct SQL syntax for creating a new table named 'employees' with columns 'employee_id' as INTEGER and 'employee_name' as VARCHAR?

• CREATE TABLE employees (employee_id VARCHAR, employee_name INTEGER)

• CREATE TABLE employees (employee_id INT, employee_name TEXT)

• CREATE TABLE employees (employee_id INTEGER, employee_name VARCHAR)

• INSERT INTO employees (employee_id, employee_name) VALUES (1, 'John')

Which SQL command is used to insert a new row into a table named 'products' with columns 'product_id' as INTEGER and 'product_name' as VARCHAR?

• INSERT INTO products (product_id, product_name) VALUES (101, 'Laptop')

• CREATE TABLE products (product_id INTEGER, product_name VARCHAR)

• UPDATE products SET product_id = 101, product_name = 'Laptop'

• DELETE FROM products WHERE product_id = 101

What is the primary use of the INTEGER/INT data type in databases?

• To store decimal numbers

• To store whole numbers

• To store character strings

• To store date values