Home ≫ General Knowledge ≫ Computer ≫ Page 26
251. ............ provides total solutions to reduce data redundancy, inconsistency, dependence and unauthorised access of data.
  A.  DBMS
  B.  Database
  C.  Centralisation of data
  D.  Protection password
     
   
View Answer

252. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as
  A.  E-R model
  B.  database
  C.  data model
  D.  DBMS
     
   
View Answer

253. ......... is one reason for problems of data integrity.
  A.  Data inconsistency
  B.  Data availability constraints
  C.  Unauthorised access of data
  D.  Security constraints
     
   
View Answer

254. Oracle is a (n)
  A.  RDBMS
  B.  hardware
  C.  system software
  D.  operating system
     
   
View Answer

255. The purpose of the primary key in a database is to
  A.  provide a map of the data
  B.  establish constraints on database operations
  C.  uniquely identify a record
  D.  unlock the database
     
   
View Answer

256. The particular field of a record that uniquely identifies each record is called the
  A.  primary field
  B.  master field
  C.  order field
  D.  Monitor
     
   
View Answer

257. ......... is an invalid type of database key.
  A.  Atomic primary key
  B.  Structured primary key
  C.  Primary key
  D.  Composite primary key
     
   
View Answer

258. Key to represent relationship between tables is called
  A.  secondary key
  B.  composite key
  C.  primary key
  D.  foreign key
     
   
View Answer

259. Dr. E F Codd represented ......... rules that a database must obey if it has to be considered truly relational.
  A.  6
  B.  10
  C.  12
  D.  8
     
   
View Answer

260. A logical schema
  A.  is a standard way of organising information into accessable part
  B.  describes how data is actually stored on disk
  C.  is the entire database
  D.  All of the above
     
   
View Answer

Copyright © 2020-2022. All rights reserved. Designed, Developed and content provided by Anjula Graphics & Web Desigining .