Top 1000+ Database Subject Mcqs Pdf Download Set No 1

by
Print/Downlaod pdf

MCQsFoundry.com brings to you 1000+ Database Mcqs which are new and latest. These Mcqs are gathered form various free sources over the Internet. If someone have any issue regarding to the copyright will contact us. MCQsFoundry.com is committed to provide Database Computer Science MCQs with Answers. Here are the Top 1000+ Database Computer Science Mcqs (Volume 1) is being published. Computer Science(Database) MCQs From various online sources over the internet are the best source for job test preparation in Pakistan.

Top 1000+ Software Engineering Subject Mcqs Pdf Download
Top 1000+ Database Subject Mcqs Pdf Download
01Database MCQS Set 0102Database MCQS Set 02
03Database MCQS Set 0304Database MCQS Set 04
05Database MCQS Set 0506Database MCQS Set 06
07Database MCQS Set 0708Database MCQS Set 08
09Database MCQS Set 0910Database MCQS Set 10
11Database MCQS Set 1112Database MCQS Set 12
13Database MCQS Set 1314Database MCQS Set 14
15Database MCQS Set 1516Database MCQS Set 16
17Database MCQS Set 1718Database MCQS Set 18
19Database MCQS Set 1920Database MCQS Set 20
Top 1000+ Software Engineering Subject Mcqs Pdf Download

1.Most of the commercial software implementations of the relational algebra operators yield listings and new tables.

  1. TRUE
  2. FALSE
  3. none   

2 .The final outcome of a natural JOIN operation yields a table that does not include the unmatched row.

  1. TRUE
  2. FALSE
  3. none

3. The final outcome of a natural JOIN yields a table that provides only the copies of the unmatched pairs.

  1. TRUE
  2. FALSE
  3. none

4. Another form of JOIN, known as equijoin, links tables on the basis of an equality condition that compares specified columns of each table.

  1. TRUE
  2. FALSE
  3. none    

5. In a relational table, each table must have an attribute or a combination of attributes that uniquely identifies each row.

  1. TRUE
  2. FALSE
  3. none     
  1.                

6.I n a relational table, each table row (topless) does not necessarily represent a single entity occurrence within the entry set.

  1. TRUE
  2. FALSE
  3. none                    

7.In a relational table, each column represents an attribute and each column has a distinctive name.    intersection represents a single data value.

  1. TRUE
  2. FALSE
  3. none

9.In a relational table, each value in a column must conform to the same data format.

  1. TRUE
  2. FALSE
  3. none  
  1.   

10.Each column in a relational table has a specific range of values knows as the attribute object.

  1. TRUE
  2. FALSE
  3. none

11.The order of the rows and columns in a relational table is immaterial to the DBMS.

  1. TRUE
  2. FALSE
  3. none

12. Some older DBMSs might impose constraints restricting the table names to ten characters.

  1. TRUE
  2. FALSE
  3. none  
  1.   

13 .Some older DBMSs might impose constraints restricting the column names to ten characters.

  1. TRUE
  2. FALSE
  3. none  
  1.   

14. Some older DBMSs impose constraints that allow column names to start with a digit.

  1. TRUE
  2. FALSE
  3. none   

15. Numeric data are data on which you can perform meaningful arithmetic procedures.

  1. TRUE
  2. FALSE
  3. none    

16. Character data can contain any character or symbol intended for mathematical manipulation.

  1. TRUE
  2. FALSE
  3. none 
  1.    

17. Date attributes contain calendar dates stored in a special format known as Julian date format.

  1. TRUE
  2. FALSE
  3. none  
  1.   

18. Logical data can have only a true or false (yes or no) condition.

  1. TRUE
  2. FALSE
  3. none   
  1.  

19. The proper use of foreign keys is crucial to exercising data redundancy control.

  1. TRUE
  2. FALSE
  3. none  
  1.   

20. An entity set is a named collection of entities that share common characteristics.

  1. TRUE
  2. FALSE
  3. none

21 Nulls, if used improperly, can create problems because they can represent ____.

  1. a default value 
  2. zero
  3. a known, but missing, attribute value   
  4. an unsuitable value

22. The entity integrity rule requires that ____.

  1. all primary key entries are unique
  2. a part of the key may be null
  3. C. foreign key values do not reference primary key values
  4. duplicate object values are allowed

23. Data are classified, according to their format and function, into which categories?  

  1. Numeric and character 
  2. Numeric, character, and date
  3. Numeric and logical        
  4. Numeric, character, date, and logical 
  1.    

24. A table is perceived as a ____.          

  1. flat structure     
  2. linked structure
  3. two-dimensional structure        
  4. graph             
  1.       

25. According to E.F. Coded, another word for the term “relation” is ____.        

  1. data file                               
  2. table
  3. data index                          
  4. data query   
  1.                       

26. The logical view of the relational database is facilitated by the ____.            

  1. wizard                  
  2. use of tables
  3. creation of queries using the wizard
  4. creation of data relationships based on a construct known as a table

27. Each table must have a ____ key.    

  1. primary                               
  2. foreign
  3. secondary          
  4. logical   

28. The key’s role is based on a concept known as ____.             

  1. consistency       
  2. determination
  3. availability          
  4. uniqueness  
  1.      

29. A super key is any key that uniquely identifies each ____ uniquely.              

  1. entity   
  2. table
  3. object in a table               
  4. structure in a table  
  1.        

30.  A primary key ____.              

  1. is a minimal super key   
  2. must be numeric
  3. is always the first field in each table
  4. must be unique

31. A table can be logically connected to another table by defining a ____.       

  1. hyperlink                            
  2. primary key
  3. common attribute          
  4. logic key    
  1.           

32. A relational operator that yields values from all rows in a table is known as the ____ operator.

  1. DIFFERENCE                      
  2. SELECT
  3. PRODUCT                           
  4. PROJECT   
  1.                           

33. A relational operator that yields all values from selected attributes is known as the ____ operator.

  1. DIFFERENCE                      
  2. SELECT
  3. PRODUCT                           
  4. PROJECT  
  1.                            

34. A relational operator that allows for the combination of information from two or more tables is known as the ____ operator.

  1. SELECT                 
  2. JOIN
  3. PROJECT                             
  4. DIFFERENCE  
  1.     

35. In a relationship, when a primary key from one table is also defined in a second table, the field is referred to as a ____ in the second table.          

  1. combined key                  
  2. primary key
  3. redundant field               
  4. foreign key
  1.         

36. A relational operator that yields all possible pairs of rows from two tables is known as the ____operator.                            

  1. UNION                
  2. DIFFERENCE
  3. INTERSECT                         
  4. PRODUCT     
  1.                       

37. A primary key that consists of more than one field is called a ____ key.       

  1. composite                         
  2. group
  3. secondary                          
  4. foreign

38. A relational operator that yields all rows in one table that are not found in the other table is the operator.                            

  1. UNION                
  2. DIFFERENCE
  3. INTERSECT                         
  4. PRODUCT   
  1.         

39. The short Date format is ____.        

  1. DD-MM-YY                        
  2. MM/DD/Y

40. A field that consists of integer values is a ____ type field.

  1. Date/Time         
  2. Memo
  3. Yes/No
  4. Numeric 
  1.             

41. Which of the following statements concerning the primary key is true?

  1. All primary key entries are unique.        
  2. The primary key may be null.
  3. The primary key is not required for all tables.
  4. The primary key data do not have to be unique.

42. Which of the following is NOT an allowable operation for a date field?

  1. Compare two dates       
  2. Multiply two dates
  3. Convert a date from its internal representation to a different presentation format
  4. Create a date by adding or subtracting a number of days from a given date

43. In general terms, the ____ key is an attribute (or combination of attributes) that uniquely identifies any given entity.    

  1. indexed              
  2. foreign
  3. primary  redundant            

 44.In the context of a database table, the statement “A determines B” indicates that ____.knowing the value of attribute A, you cannot look up the value of attribute B B.  you do not need to know the value of attribute

  1. in order to look up the value of attribute B
  2. knowing the value of attribute
  3. you can look up the value of attribute A
  4. knowing the value of attribute A, you can look up the value of attribute B

45. A ____ is any key that identifies each entity uniquely.   It functionally determines all of the entity’s attributes.         

  1. super key           
  2. foreign key
  3. primary key       
  4. combined key

46. It might take more than a single attribute to define functional dependence; that is, a key may be composed of more than one attribute.   A multi-attribute key is known as a ____ key.

  1. primary
  2. composite
  3. super   
  4. foreign

47. The table is said to exhibit ____ integrity.

  1. referential         
  2. enforced
  3. entity   
  4. key

48 .In a sophisticated application development software, nulls can create problems when using functions such as               

  1. COUNT
  2. COUNT and AVERAGE
  3. SUM     

D.  COUNT, SUM, and AVERAGE

49. We can describe a link by observing that ____.

  1. a primary key of one table appears again as a primary key in a related table
  2. a foreign key of one table appears again as a foreign key in a related table
  3. a primary key of one table appears again as a foreign key in a related table
  4. a foreign key of one table appears again as a primary key in a related table ANS 

50. User rights information is stored in

  1. Physical database  
  2. Catalog
  3. Logical database   
  4. Buffer

<Previous Page
Take Quiz No 01
Next Page >

Post Views: 2,289