Sail E0 Webinar

MCQs

Total Questions : 286 | Page 23 of 29 pages
Question 221. The relational model uses some unfamiliar terminology. A tuple is equivalent to a:
  1.    record
  2.    field
  3.    file
  4.    data base
  5.    data item
 Discuss Question
Answer: Option A. -> record
Question 222. In SQL, which command(s) is(are) used to enable/disable a database trigger?
  1.    MODIFY USER
  2.    CHANGE USER
  3.    ALTER TRIGGER
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> ALTER TRIGGER
Question 223. The data dictionary tells the DBMS
  1.    what files are in the database
  2.    what attribute are possessed by the data
  3.    what these files contain
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 224. Which command is used to remove a table from the database in SQL?
  1.    DELETE TABLE
  2.    DROP TABLE
  3.    ERASE TABLE
  4.    UNATTACH TABLE
  5.    None of the above
 Discuss Question
Answer: Option B. -> DROP TABLE
Question 225. A large computer information system maintains many different computer files. Which amongst them is called a perpetual file?
  1.    Specialized file
  2.    Log file
  3.    Master file
  4.    Update file
  5.    None of the above
 Discuss Question
Answer: Option C. -> Master file
Question 226. Which of the following is true of a network structure?
  1.    It is a physical representation of the data
  2.    It allows a many-to-many relationship
  3.    It is conceptually simple
  4.    It will be the dominant data base of the future
  5.    None of the above
 Discuss Question
Answer: Option B. -> It allows a many-to-many relationship
Question 227. A file produced by a spreadsheet
  1.    is generally stored on disk in an ASCII text format
  2.    can be used as it by the DBMS
  3.    can be used for graphic
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> is generally stored on disk in an ASCII text format
Question 228. A form defines
  1.    where data is placed on the screen
  2.    the width of each field
  3.    both (a) and (b)
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> both (a) and (b)
Question 229. In SQL, the _____ command is used to recompile a view
  1.    COMPILE VIEW
  2.    DEFINE VIEW
  3.    CREATE VIEW
  4.    ALTER VIEW
  5.    None of the above
 Discuss Question
Answer: Option D. -> ALTER VIEW
Question 230. A list in alphabetical order
  1.    is in descending order
  2.    is in ascending order
  3.    is the result of a sort operation
  4.    both (b) and (c)
  5.    None of the above
 Discuss Question
Answer: Option D. -> both (b) and (c)

Latest Videos

Latest Test Papers