CREATE TABLE employee (name VARCHAR, id INTEGER)What type of statement is this? DBMS

  • view
  • ddl
  • dml
  • tcl
Answer: ddl
1537 students attemted this question.

Explanation

No Explanation Available.

Share this question with friends

Similar Questions

  1. An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces .(i.e the total number of utilized space by A,B)

  2. In existing table, ALTER TABLE statement is used to

  3. SQL Query to delete all rows in a table without deleting the table (structure, attributes, and indexes)

  4. SELECT * FROM employee WHERE dept_name="Comp Sci";In the SQL given above there is an error . Identify the error.

  5. What is the name of the Table in the diagram?

  6. The statement in SQL which allows to change the definition of a table is

  7. SELECT * FROM employeeWhat type of statement is this?

  8. The database management system can be considered as the collection of ______ that enables us to create and maintain the database.

  9. Which command is used to remove all rows from a table ?

  10. Which one of the following command is used to delete the existing row in a table?

  11. Correct syntax query syntax to drop a column from a table is

  12. Which command is used for removing a table and all its data from the database:

  13. How will a data analyst retrieve a list of all employees' first_name, last_name and hire_date from the employees table?

  14. How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?

  15. In SQL, which command(s) is (are) used to change a table’s storage characteristics?

  16. In SQL, which command is used to add new rows to a table?

  17. What is a good primary key to use for a Product table?

  18. .......... can be facts related to any object in consideration. For example, your name, age, height, weight, etc

  19. SELECT statement is a ...............in SQL

  20. Which SQL statement would add a record to the database?

Comments

Add Your Review

Your email address will not be published.

Subscribe to Newsletter!

Subscribe to get latest updates and information.