Sail E0 Webinar

MCQs

Total Questions : 262 | Page 4 of 27 pages
Question 31. Which command is used to remove a table from the database in SQL?
  1.    ERASE TABLE
  2.    DROP TABLE
  3.    DELETE TABLE
  4.    UNATTACH TABLE
 Discuss Question
Answer: Option B. -> DROP TABLE
Question 32. A file produced by a spreadsheet
  1.    can be used for graphic
  2.    all of the listed here
  3.    can be used as it by the DBMS
  4.    is generally stored on disk in an ASCII text format
 Discuss Question
Answer: Option D. -> is generally stored on disk in an ASCII text format
Question 33. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
  1.    Master file
  2.    Update file
  3.    Log file
  4.    Specialized file
 Discuss Question
Answer: Option A. -> Master file
Question 34. Which of the following is true of a network structure?
  1.    It is conceptually simple
  2.    It allows a many-to-many relationship
  3.    It will be the dominant data base of the future
  4.    It is a physical representation of the data
 Discuss Question
Answer: Option B. -> It allows a many-to-many relationship
Question 35. A form defines
  1.    the width of each field
  2.    none of the listed here
  3.    both of the listed here
  4.    where data is placed on the screen
 Discuss Question
Answer: Option C. -> both of the listed here
Question 36. In SQL, GRANT command is used to
  1.    allow user to access databases
  2.    None of the listed here
  3.    grant system privileges, roles, and object privileges to uses and roles
  4.    allow user to create databases
 Discuss Question
Answer: Option C. -> grant system privileges, roles, and object privileges to uses and roles
Question 37. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
  1.    All of the listed here
  2.    MODIFY TRIGGERS IN TABLE
  3.    ALTER TABLE
  4.    ALTER TRIGGERS
 Discuss Question
Answer: Option C. -> ALTER TABLE
Question 38. Updating a database means
  1.    reorganizing the database
  2.    revising the file structure
  3.    all of the listed here
  4.    modifying or adding record occurrences
 Discuss Question
Answer: Option D. -> modifying or adding record occurrences
Question 39. The logical data structure with a one-to-many relationship is a
  1.    chain
  2.    network
  3.    relational
  4.    tree
 Discuss Question
Answer: Option D. -> tree
Question 40. The highest level in the hierarchy of data organization is called
  1.    data file
  2.    data record
  3.    data bank
  4.    database
 Discuss Question
Answer: Option D. -> database

Latest Videos

Latest Test Papers