Querying database part-1 DDL MCQ

Test your knowledge with important Querying database part-1 DDL MCQ and their applications. These MCQs are beneficial for competitive exams too. Explore 30 + more Querying database part-1 DDL MCQs at Bissoy

• To replace the relation section with some other relation the initial step to be carried out is
  ক

  Delete section;

  খ

  Drop section;

  গ

  Delete from section;

  ঘ

  Replace section new_table ;
• In order to include an attribute Name to the teaches relation which of the following command is used?
  ক

  Alter table teaches include Name;

  খ

  Alter table teaches add Name;

  গ

  Alter table teaches add Name varchar;

  ঘ

  Alter table teaches add Name varchar(20);
• In the section relation which of the following is used as a foreign key?
  ক

  Course_id

  খ

  Course_id,sec_id

  গ

  Room_number

  ঘ

  Course_id,sec_id,room_number
• Which of the following can be used as a primary key entry of the instructor relation.
  ক

  DEPT_NAME

  খ

  NAME

  গ

  ID

  ঘ

  All of the mentioned
• Identify the error in the section relation
  ক

  No error

  খ

  Year numeric (4,0)

  গ

  Building varchar (15)

  ঘ

  Sec_id varchar (8)
• In the above DDL command the foreign key entries are got by using the keyword
  ক

  References

  খ

  Key reference

  গ

  Relating

  ঘ

  None of the mentioned
• In the course relation, the title field should throw an error in case of any missing title. The command to be added in title is
  ক

  Unique

  খ

  Not null

  গ

  0

  ঘ

  Null
• The department relation has the an entry budget whose type has to be replaced by
  ক

  Varchar (20)

  খ

  Varchar2 (20)

  গ

  Numeric (12,2)

  ঘ

  Numeric
• Which is the main relation which is used in the university database which is referenced by all other relation of the university?
  ক

  Teaches

  খ

  Course

  গ

  Department

  ঘ

  Section