PPSC Lectures Computer Science Quiz No 2 A.J. Bhatti August 31, 2020 Welcome to your PPSC Lectures Computer Science Quiz No 3 Name Email The main Disadvantages of Flat File Database System Duplication of Data inconsistency of Data Vulnerability All of Above What is Database? Add description here! A shared collection of logically related data, designed to meet the information needs of multiple users in an organization. A Private collection of logically related data, designed to meet the information needs of multiple users in an organization. A Protected collection of logically related data, designed to meet the information needs of multiple users in an organization. None of These Among the options below , Which is not an advantage of a Modern Database Data Sharing Consistency Inconsistency Data Integrity The data for different applications or subsystems is placed at the same place data Sharing data Independence Controlled Redundancy data Integrity The Process in which once change in the Data has no or minimum effect on other File or Data is known as Data Sharing Data Retundacy Data Integrity Data Independence Data Integrity is also Known as Validity of Data Duplication of Data Multiplication of Data Division of Data The Process in which we do not need to duplicate data unnecessarily; we do duplicate data in the databases, however, this duplication is deliberate and controlled Integrity Controlled Redundancy Data independency Data Sharing ..............................is a program or group of programs which is used for performing certain operations on the data stored in the database. Data Appliccation Database Application Database Database management system .....................is software of collection of small programs to perform certain operation on data and manage the data Data Application Database Application Database management System Simple Sql Database The basic operations performed by the DBMS are............................... Management of Data in the Database Management of Users associated with the database Management associated database Both A & B The process in changes made to different occurrence of data should be controlled and managed in such a way that all the occurrences have same value for any specific data item Data consistency Better data security Faster development of new applications Economy of scale Better concurrency control can very efficiently check that which user is performing which action and accessing which part of data Data Database DBMS None of the above Economy of Scale is Databases and database systems are designed to share data stored in one location for many different purposes access of database form as number of points simultaneously Both A & B None of Above .................. is the process to access the database in such a way that all the data accesses are completed correctly and transparently Concurrency Concurrency Control Economy Scale Both A & C High Cost and Conversion Cost are the benefits of DBMS System , Is it True ??? True False The Data is Divided into ....... Levels 1 2 3 4 The Term Data About the Data is use to specify which level of Data? Real Data Meta Data Existing Data None of above All the Characteristics of Applicants of PPSC is an example of ........ Real World Data Mete Data Existing Data All of above A single or many Database records related to any real world entity shows which level of Data ............ Real World Data Meta Data Existence of Data All of the above How many types of Users can use a Database......... 2 3 1 all of the above The End-User Who have some rights of database like account generation etc is known as Application Programmer Naive Sophisticated User None of the above The Class of Database user which is the most technical class of db users and are responsible manage as well as design the database is known as Naive Sophisticated Db incharge Database administrator The actions includes in the duties of Database Administrator are Schema Definition Granting Data Access Routine maintenance All of the Above ....................is the person who create all the meta data information for the organization End User Sophisticated User DB in charge DBA How many layers are there in Database Architecture........ 1 2 3 4 I am now quite--------------and hearty. Hail Hale Hell Hall Who is known as the Poet of Nature? William Black William Shakespeare William Wordsworth William Butler Yeats Four or Eight or Twelve Rakat offered in the late night is Called? Ishraq Salat-e-Tahajjud Witr Sunnah Who said that Zakat is treasure of Islam? Rasool Ullah (P.B.U.H) Hazrat Umar Farooq (R.A) Imam Abu Hanifa (R.A) None of them As per Chief Justice of Pakistan information, ------ policemen were assigned the security of non-entitled persons. 6,000 7,000 8,000 9,000 Related Author: A.J. Bhatti
