Sail E0 Webinar

MCQs

Total Questions : 286 | Page 6 of 29 pages
Question 51. 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 52. 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)
Question 53. If a piece of data is stored in two places in the database, then
  1.    storage space is wasted
  2.    changing the data is one spot will cause data inconsistency
  3.    it can be more easily accessed
  4.    both (a) and (b)
  5.    None of the above
 Discuss Question
Answer: Option D. -> both (a) and (b)
Question 54. A data dictionary is a special file that contains
  1.    the names of all fields in all files
  2.    the data types of all fields in all files
  3.    the widths of all fields in all files
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 55. A file that is organized in uniform format is formally referred to as a _____ or a database file.
  1.    Document
  2.    Database
  3.    Record
  4.    Structured data file
  5.    None of the above
 Discuss Question
Answer: Option D. -> Structured data file
Question 56. A form can be used to
  1.    modify records
  2.    delete records
  3.    format printed output
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option D. -> All of the above
Question 57. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
  1.    Oracle
  2.    SQL
  3.    dBASE
  4.    4GL
  5.    None of the above
 Discuss Question
Answer: Option B. -> SQL
Question 58. In SQL, the CREATE TABLE is used
  1.    to create a table, defining its columns, integrity constrains, and storage allocation
  2.    to add a column/integrity constraint to a table
  3.    to redefine a column
  4.    to change a table's storage characteristics
  5.    All of the above
 Discuss Question
Answer: Option A. -> to create a table, defining its columns, integrity constrains, and storage allocation
Question 59. Batch processing is appropriate if
  1.    a large computer system is available
  2.    only a small computer system is available
  3.    only a few transactions are involved
  4.    All of the above
  5.    None of the above
 Discuss Question
Answer: Option E. -> None of the above
Question 60. Which of the following is not true of the traditional approach to information processing?
  1.    There is common sharing of data among the various applications
  2.    It is file-oriented
  3.    Programs are dependent on the files
  4.    It is inflexible
  5.    All of the above are true
 Discuss Question
Answer: Option A. -> There is common sharing of data among the various applications

Latest Videos
Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)
Direction Sense Test Part 1 Reasoning (Hindi)
Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE
Cube & Cuboid Part 1 Reasoning (Hindi)
Data Interpretation (DI) Basic Concept Reasoning (Hindi)
Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)
Sail E0 free webinar Webinars
Real Numbers Part 7 Class 10 Maths
Real Numbers Part 1 Class 10 Maths
Polynomials Part 1 Class 10 Maths

Latest Test Papers

Pie Chart - Test Paper 1 Data Interpretation Reasoning & DI
Tabulation - Test Paper 2 Data Interpretation Reasoning & DI
Test Paper 1 Direction Sense Test Reasoning & DI
ICA , RDIC,GFM Free Modal Test Paper - Non - Technical Branch Old Syllabus 2022 - SAIL Junior Officer E0
GFM Combined 1 Free Revision Test SAIL JO E-0