Sail E0 Webinar

MCQs

Total Questions : 262 | Page 7 of 27 pages
Question 61. The language used in application programs to request data from the DBMS is referred to as the
  1.    query language
  2.    DDL
  3.    DML
  4.    All of the listed here
 Discuss Question
Answer: Option C. -> DML
Question 62. A database management system might consist of application programs and a software package called
  1.    BPL
  2.    AUTOFLOW
  3.    FORTRAN
  4.    TOTAL
 Discuss Question
Answer: Option A. -> BPL
Question 63. A race condition occurs when
  1.    None of the listed here
  2.    two users of the DBMS are interacting with different files at the same time
  3.    Both of the listed here
  4.    Two concurrent activities interact to cause a processing error
 Discuss Question
Answer: Option D. -> Two concurrent activities interact to cause a processing error
Question 64. An indexing operation
  1.    sorts file using two keys
  2.    None of the listed here
  3.    sorts a file using a single key
  4.    establishes an index for a file
 Discuss Question
Answer: Option D. -> establishes an index for a file
Question 65. An audit trail
  1.    can be used to restore lost information
  2.    All of the listed here
  3.    is used to make back-up copies
  4.    is the recorded history of operations performed on a file
 Discuss Question
Answer: Option D. -> is the recorded history of operations performed on a file
Question 66. Which of the following is not characteristic of a relational database model?
  1.    complex logical relationships
  2.    tables
  3.    treelike structure
  4.    records
 Discuss Question
Answer: Option C. -> treelike structure
Question 67. If you want your database to include methods, you should use a _____ database.
  1.    Distributed
  2.    Object-Oriented
  3.    Network
  4.    Hierarchical
 Discuss Question
Answer: Option B. -> Object-Oriented
Question 68. In SQL, which command(s) is(are) used to create a synonym for a schema object?
  1.    CREATE SCHEMA
  2.    CREATE SAME
  3.    CREATE SYNONYM
  4.    All of the listed here
 Discuss Question
Answer: Option C. -> CREATE SYNONYM
Question 69. The on-line, softcopy display a customer's charge account to respond to an inquiry is an examples of a
  1.    on demand report
  2.    regularly scheduled report
  3.    exception report
  4.    forecasting report
 Discuss Question
Answer: Option A. -> on demand report
Question 70. In SQL, which of the following is not a data Manipulation Language Commands?
  1.    DELETE
  2.    UPDATE
  3.    SELECT
  4.    CREATE
 Discuss Question
Answer: Option D. -> CREATE

Latest Videos

Latest Test Papers