Database Management System (DBMS) MCQs with answers Page - 45

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a DDL command?

  • (A) UPDATE
  • (B) TRUNCATE
  • (C) ALTER
  • (D) None of the Mentioned

A

Admin • 833.24K Points
Coach

Q. Which of the following are TCL commands?

  • (A) UPDATE and TRUNCATE
  • (B) SELECT and INSERT
  • (C) GRANT and REVOKE
  • (D) ROLLBACK and SAVEPOINT

A

Admin • 833.24K Points
Coach

Q. ________________ is not a category of SQL command.

  • (A) TCL
  • (B) SCL
  • (C) DCL
  • (D) DDL

A

Admin • 833.24K Points
Coach

Q. Which of the following statement is true?

  • (A) DELETE does not free the space containing the table and TRUNCATE free the space containing the table
  • (B) Both DELETE and TRUNCATE free the space containing the table
  • (C) Both DELETE and TRUNCATE does not free the space containing the table
  • (D) DELETE free the space containing the table and TRUNCATE does not free the space containing the table

A

Admin • 833.24K Points
Coach

Q. What is the purpose of the SQL AS clause?

  • (A) The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column
  • (B) The AS clause is used with the JOIN clause only
  • (C) The AS clause defines a search condition
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

Q. What does DML stand for?

  • (A) Different Mode Level
  • (B) Data Model Language
  • (C) Data Mode Lane
  • (D) Data Manipulation language

A

Admin • 833.24K Points
Coach

Q. With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?

  • (A) SELECT * FROM Persons WHERE FirstName=’a’
  • (B) SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
  • (C) SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
  • (D) SELECT * FROM Persons WHERE FirstName=’%a%’

A

Admin • 833.24K Points
Coach

Q. With SQL, how can you return all the records from a table named “Persons” sorted descending by “FirstName”?

  • (A) SELECT * FROM Persons SORT BY ‘FirstName’ DESC
  • (B) SELECT * FROM Persons ORDER FirstName DESC
  • (C) SELECT * FROM Persons SORT ‘FirstName’ DESC
  • (D) SELECT * FROM Persons ORDER BY FirstName DESC

A

Admin • 833.24K Points
Coach

Q. With SQL, how can you return the number of not null records in the “Persons” table?

  • (A) SELECT COUNT() FROM Persons
  • (B) SELECT COLUMNS() FROM Persons
  • (C) SELECT COLUMNS(*) FROM Persons
  • (D) SELECT COUNT(*) FROM Persons

A

Admin • 833.24K Points
Coach

Q. What does the ALTER TABLE clause do?

  • (A) The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
  • (B) The SQL ALTER TABLE clause is used to insert data into database table
  • (C) THE SQL ALTER TABLE deletes data from database table
  • (D) The SQL ALTER TABLE clause is used to delete a database table

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.