Sail E0 Webinar

MCQs

Total Questions : 286 | Page 1 of 29 pages
Question 1. In SQL, which of the following is not a data Manipulation Language Commands?
  1.    DELETE
  2.    SELECT
  3.    UPDATE
  4.    CREATE
  5.    None of the above
 Discuss Question
Answer: Option D. -> CREATE
Question 2. Which of the following is not characteristic of a relational database model?
  1.    tables
  2.    treelike structure
  3.    complex logical relationships
  4.    records
  5.    None of the above
 Discuss Question
Answer: Option B. -> treelike structure
Question 3. In SQL, the CREATE VIEW command is used
  1.    to recompile view
  2.    to define a view of one or more tables or views
  3.    to recompile a table
  4.    to create a trigger
  5.    None of the above
 Discuss Question
Answer: Option B. -> to define a view of one or more tables or views
Question 4. A computer file contains several records. What does each record contain?
  1.    Bytes
  2.    Words
  3.    Fields
  4.    Database
  5.    None of the above
 Discuss Question
Answer: Option C. -> Fields
Question 5. A ____ Contains the smallest unit of meaningful data, so you might call it the basic building block for a data file.
  1.    File structure
  2.    Records
  3.    Fields
  4.    Database
  5.    None of the above
 Discuss Question
Answer: Option C. -> Fields
Question 6. In the DBM approach, application programs perform the
  1.    storage function
  2.    processing functions
  3.    access control
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option B. -> processing functions
Question 7. In SQL, which command is used to create a database user?
  1.    ADD USER TO DATABASE
  2.    MK USER
  3.    CREATE USER
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option C. -> CREATE USER
Question 8. When performing a look-up operation using a form
  1.    you enter the search value into the form
  2.    you look at each form sequentially until you see the one you want
  3.    you type the key in an entry line, and the correct form is displayed
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option A. -> you enter the search value into the form
Question 9. A _____ database does not use pointers or physical links, but instead finds related records by examining the contents of fields.
  1.    Network
  2.    Hierarchical
  3.    Relational
  4.    Object-Oriented
  5.    None of the above
 Discuss Question
Answer: Option C. -> Relational
Question 10. A _____ means that one record in a particular record type is related to only one record of another record type.
  1.    One-to-one relationship
  2.    One-to-many relationship
  3.    Many-to-one relationship
  4.    Many-to-many relationship
  5.    None of the above
 Discuss Question
Answer: Option A. -> One-to-one relationship

Latest Videos

Latest Test Papers