Data Definition Language MCQ

Test your knowledge with important Data Definition Language MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Data Definition Language MCQs at Bissoy

• Which of the following statement drops the synonym?
  ক

  DELETE SYNONYM

  খ

  DROP SYNONYM

  গ

  REMOVE SYNONYM

  ঘ

  None of the mentioned
• DDL statements not used for Synonym is __________
  ক

  CREATE SYNONYM

  খ

  DROP SYNONYM

  গ

  ALTER SYNONYM

  ঘ

  None of the mentioned
• Purpose of ALTER CERTIFICATE is __________
  ক

  Adds a private key to a certificate

  খ

  Changes the public key of a certificate

  গ

  Removes the certificate from the database

  ঘ

  None of the mentioned
• Creation of new database role in the current database is made by __________
  ক

  CREATE APPLICATION ROLE

  খ

  CREATE ROLE

  গ

  CREATE USER

  ঘ

  CREATE LOGIN
• Command used to modify the schema is __________
  ক

  ALTER SCHEMA

  খ

  ALTER STRUCTURE

  গ

  ALTER VIEW

  ঘ

  DBCC SHRINKDB
• Statement used to remove a user from the current database is ____________
  ক

  DROP ROLE

  খ

  DROP USER

  গ

  DROP LOGIN

  ঘ

  None of the mentioned
• Which of the following creates a new Microsoft Windows or SQL Server login account?
  ক

  CREATE LOGIN

  খ

  DROP LOGIN

  গ

  UPDATE LOGIN

  ঘ

  REMOVE LOGIN
• Which is a new DDL statement?
  ক

  DROP ROLES

  খ

  CREATE APPLICATION ROLE

  গ

  CREATE USERS

  ঘ

  None of the mentioned
• Which of the following adds MOVE TO clause?
  ক

  DROP INDEX

  খ

  ALTER INDEX

  গ

  UPDATE INDEX

  ঘ

  CREATE INDEX
• Point out the wrong statement with respect to ALTER INDEX statement.
  ক

  Adds new format for specifying index and table names

  খ

  Adds the index option:MAXDOP

  গ

  Adds the index option:ONLINE

  ঘ

  None of the mentioned
• Which of the following index options are added by the CREATE INDEX statement?
  ক

  XML INDEX

  খ

  INCLUDED (column)

  গ

  PARTITION SCHEME

  ঘ

  ONLINE
• Which of the following statement modifies view index?
  ক

  ALTER INDEX

  খ

  ALTER VIEW INDEX

  গ

  ALTER INDEX_VIEW

  ঘ

  None of the mentioned
• When does most ALTER DATABASE statements fail?
  ক

  Database is in the RESTORING state

  খ

  Database is in the STORING state

  গ

  Database is in the RESTORE state

  ঘ

  None of the mentioned
• Maximum number of filegroups specified for each database is ___________
  ক

  32, 667

  খ

  32, 777

  গ

  32, 766

  ঘ

  32, 767
• Command used to shrink the size of the database is _____________
  ক

  DBCC SHRINK

  খ

  SHRINKDATABASE

  গ

  DBCC SHRINKDATABASE

  ঘ

  DBCC SHRINKDB
• Features provided by ALTER DATABASE statement do not include ____________
  ক

  Deletes database

  খ

  Modifies file

  গ

  Changes the attributes of a database

  ঘ

  Changes the database collation
• The DROP DATABASE statement must run in ________ mode.
  ক

  Autocommit

  খ

  Commit

  গ

  Readcommit

  ঘ

  None of the mentioned
• Which of the following database should be backed up regularly?
  ক

  Adventure Works

  খ

  Pub

  গ

  TEMPDB

  ঘ

  Master
• View used used for displaying current status of database is ___________
  ক

  system.databases

  খ

  current.databases

  গ

  sys.databases

  ঘ

  status.databases
• Syntax for dropping a database snapshot named “Sushant” would be ____________
  ক

  DROP DATABASE Sushant

  খ

  DROP DATABASE SNAP Sushant

  গ

  DROP SNAPSHOT Sushant

  ঘ

  None of the mentioned
• Which of the following statement is used to create database snapshot?
  ক

  CREATE DATABASE

  খ

  CREATE SNAPSHOT

  গ

  CREATE SNAPDB

  ঘ

  None of the mentioned
• Which of the following statement removes sales and suppliers database?
  ক

  DROP DATABASE Sales, NewSales

  খ

  DROP DATABASE Sales, suppliers

  গ

  DROP DATABASE Sales and suppliers

  ঘ

  DROP DATABASE Sales-suppliers
• Which is the minimal permission that a user must have to drop the database?
  ক

  READ

  খ

  WRITE

  গ

  VIEW

  ঘ

  CONTROL
• Which of the following database cannot be dropped?
  ক

  TEMPDB

  খ

  Master

  গ

  MSDB

  ঘ

  All of the mentioned
• Which of the following statement removes database including its related components?
  ক

  DROP DATABASE

  খ

  DELETE DATABASE

  গ

  REMOVE DATABASE

  ঘ

  None of the mentioned
• Which of the following item is provided by CREATE DATABASE statement?
  ক

  Service Broker options

  খ

  ALLOW_SNAPSHOT_ISOLATION

  গ

  DB_CHAINING

  ঘ

  Database mirroring
• What options did ALTER DATABASE statement add?
  ক

  DATABASE SNAPSHOT syntax

  খ

  ATTACH_REBUILD_LOG clause

  গ

  DB_CHAINING option

  ঘ

  READ_COMMITTED_SNAPSHOT