Sail E0 Webinar

MCQs

Total Questions : 50 | Page 3 of 5 pages
Question 21. A
  1.    FILE SYSTEM
  2.    DATABASE
  3.    DBMS
  4.    none of the above
 Discuss Question
Answer: Option A. -> FILE SYSTEM
Question 22. Data items grouped together for storage purposes are called a :
  1.    Record
  2.    title
  3.    list
  4.    string
 Discuss Question
Answer: Option A. -> Record
Question 23. Which of the following is used in the application programs to request data from the database management system?
  1.    Data Manipulation language
  2.    Data Definition Language
  3.    Data Control Language
  4.    All of the above
 Discuss Question
Answer: Option A. -> Data Manipulation language
Question 24. Correct syntax query syntax to drop a column from a table is
  1.    DELETE COLUMN column_name;
  2.    DROP COLUMN column_name;
  3.    ALTER TABLE table_name DROP COLUMN column_name;
  4.    None is correct.
 Discuss Question
Answer: Option C. -> ALTER TABLE table_name DROP COLUMN column_name;
Question 25. This is an authorization command of SQL
  1.    Access
  2.    Grant
  3.    Allow
  4.    None of these
 Discuss Question
Answer: Option B. -> Grant
Question 26. What is returned by SUBSTR(‘TUTORIALS POINT’, 1, 9)
  1.    TUTORIAL
  2.    POINT
  3.    TUTORIALS
  4.    UTORIALS
 Discuss Question
Answer: Option C. -> TUTORIALS
Question 27. Which command is used for removing a table and all its data from the database:
  1.    Create command
  2.    Drop table command
  3.    Alter table command
  4.    All of the mentioned
 Discuss Question
Answer: Option B. -> Drop table command
Question 28. Which of the following refers to the number of attributes in a relation?
  1.    Degree
  2.    Row
  3.    Column
  4.    All of the above
 Discuss Question
Answer: Option A. -> Degree
Question 29. Which of the following is NOT a purpose of database?
  1.    To collect records
  2.    To store records
  3.    To perform calculations
  4.    To create a letter
 Discuss Question
Answer: Option D. -> To create a letter
Question 30. The Database Management Query language is generally designed for the _____
  1.    Support end-users who use English like commands
  2.    Specifying the structure of the database
  3.    Support in the development of the complex applications software
  4.    All of the above
 Discuss Question
Answer: Option D. -> All of the above

Latest Videos

Latest Test Papers