DBMS

Which of the following is not a DDL command?

• TRUNCATE

• ALTER

• SELECT

• RENAME

How many Primary keys can have in a table?

• 1. Only 1

• 1. Only 2

• 1. Depends on no of Columns

• 1. Depends on DBA

Which of the following statement is true?

• 1. TRUNCATE free the table space while DELETE does not.

• 1. Both TRUNCATE and DELETE statements free the table's space.

• 1. Both TRUNCATE and DELETE statement does not free the table's space.

• 1. DELETE free the table space while TRUNCATE does not.

MySQL 's abbreviation is

• Manage Your Structured Query Language

• Mitigate your Structured Query Language

• Modify Structured Query Language

• My Structured Query Language

SQL is case sensitive

​

• True

• False

Which of the following is NOT a valid name for a DB

• employee_database

• emp details

• emp0101011111100

  
  

• 1emp000002222

Which of the following is a characteristic of Data

• It can be of any form

• It is gives a proper context

• It is processed

• None of the above

Priya wants to empty a table called "Mytable", she uses a command: "TRUNCATE TABLE MYTABLE; " What will happen?

• Deletes the entire delete from the database

• Deletes the data from the table

• No effect

• throws an Error

Which of the following cannot be done using ALTER command

• Adding a column called "NULL"

• Deleting four columns at a time

• Deleting rows from a table

• Changing the datatype of age to char

How does the value 'NULL' is stored a column whose data type is char(6)

• It cannot be stored

• 0

• "NULL "

• N