DBMS

Multiple Choice

What does SQL stand for?

• • A) Structured Query Language

• • B) Secure Query Language

• • C) Simple Query Language

• • D) Standard Query Language

Multiple Choice

Which SQL command is used to create a new table in a database?

• • A) NEW

• • B) MAKE

• • C) CREATE

• • D) ADD

Multiple Choice

In SQL, which command is used to add new rows of data to a table?

• • A) ADD

• • B) INSERT

• • C) UPDATE

• • D) APPEND

Multiple Choice

What will be the output of following command?

• This command will show the table

• This command will show the schema

• This command will show the rows

• This command will show an error.

Multiple Choice

What this command will do in Apex Oracle?

• will add multiple attributes

• Will add multiple schema

• Will add multiple rows

• Will add multiple tables

Multiple Choice

What does the SQL command TRUNCATE do?

• • A) Deletes all rows from a table

• • B) Deletes a specific row from a table

• • C) Removes a column from a table

• • D) Modifies the structure of a table

Multiple Choice

Which SQL command is used to permanently remove a table from a database?

• • A) DROP

• • B) REMOVE

• • C) DELETE

• • D) TRUNCATE

Multiple Choice

Altering Table

ALTER TABLE Products

ADD Quantity INT;

Question:

• What will be the result of the ALTER TABLE statement in the script?

• • A) Adds a new column named "Quantity" to the "Products" table.

• • B) Removes the "Quantity" column from the "Products" table.

• • C) Changes the data type of the "Price" column.

• • D) None of the above.

Multiple Choice

In SQL, which command is used to change the structure of an existing table?

• • A) MODIFY

• • C) CHANGE

• • B) ALTER

• • D) RENAME

Multiple Choice

What is the purpose of data manipulation language (DML) in SQL?

• • A) To define the structure of a database

• • B) To perform operations on data like insert, update, and delete

• • C) To establish connections between databases

• • D) To create backups of a database