Sail E0 Webinar

MCQs

Total Questions : 50 | Page 4 of 5 pages
Question 31. A DBMS query language is designed to
  1.    Support end users who use English-like commands.
  2.    Support in the development of complex applications software.
  3.    Specify the structure of a database.
  4.    all of the above
 Discuss Question
Answer: Option D. -> all of the above
Question 32. Which of the following levels is considered as the level closed to the end-users?
  1.    Internal Level
  2.    External Level
  3.    Conceptual Level
  4.    Physical Level
 Discuss Question
Answer: Option B. -> External Level
Question 33. Concurrent access by multiple users is not possible by using DBMS
  1.    true
  2.    false
 Discuss Question
Answer: Option B. -> false
Question 34. SELECT * FROM employeeWhat type of statement is this?
  1.    integrity constraint
  2.    ddl
  3.    dml
  4.    view
 Discuss Question
Answer: Option C. -> dml
Question 35. A view of database that appears to an application program is known as
  1.    schema
  2.    subschema
  3.    virtual table
  4.    none of the above
 Discuss Question
Answer: Option B. -> subschema
Question 36. CREATE TABLE employee (name VARCHAR, id INTEGER)What type of statement is this?
  1.    view
  2.    ddl
  3.    dml
  4.    tcl
 Discuss Question
Answer: Option B. -> ddl
Question 37. In the relation model, the relation are generally termed as ________
  1.    Tuples
  2.    Attributes
  3.    Rows
  4.    Tables
 Discuss Question
Answer: Option D. -> Tables
Question 38. The term "ODBC" stands for_____
  1.    Oral database connectivity
  2.    Oracle database connectivity
  3.    Open database connectivity
  4.    Object database connectivity
 Discuss Question
Answer: Option C. -> Open database connectivity
Question 39. What is missing in this code? SELECT * FROM WHERE genre = ‘action’ ORDER BY year ASC;
  1.    Missing an AND
  2.    Table name
  3.    Capitalize action
  4.    None of these
 Discuss Question
Answer: Option B. -> Table name
Question 40. Which one of the following refers to the total view of the database content?
  1.    Internal view
  2.    Physical view
  3.    Conceptual view
  4.    External view
 Discuss Question
Answer: Option C. -> Conceptual view

Latest Videos

Latest Test Papers