Here mostly students face some problems in database specially in class second year. For the help of these students all database important questions according to the requirements of Punjab boards write briefly.
It work like a Table. Table is also called Relation. Relation is the combination of vertical and horizontal lines.
computer science papers database
- Chapter One
- Two
- Three
- Four
- Five
- Six
- Seven
 |
| database |
Important Questions Chapter One
SHORT QUESTION) 1. Define Query language? 2. What is Report generator? 3. Define Data Dictionary? 4. Define data Integrity? 5. Write a short note on Database? 6. What is data Redundancy? 7. What is DBMS? 8. Difference between Field and Record? 9. What is Back up and Recovery? 10. Write any four advantages of DBMS?
LONG) 1. What is database and also explain three database Models?
- What is DBMS and also write the disadvantages of it with detail?
Chapter Number Two Important Questions
1). A key that is used strictly for data retrieval purposes:
- Secondary keyb. Candidate key c. Composite key d.Primary key
2) A table in which the foreign key is found is called:
- Parent tableb. Dependent table c. View d.All
3) Which of the following iS known as control key: A. Primary key b.candidate key c.Sort key
4) A Candidate key is: a. Primary key b. The primary key selected to be the of relation
- Foreign keyd. An attribute or a group of attribute that can be the primary key
5) How many primary keys can a table have : a.One b. Two c.Three d.None
6) DBA stands for: a. data basic Administrative b. data base Administrative
- Data base Applicationd. Data base Authority
SHORT QUESTION
1). Who is End User? 2. What are Parent and Depend Table? 3.Who is data Administrator?
4). Write the purpose of index file? 5. Write a short note on DA? 6. How many primary can be defined in a table? 7. Write any two important task performed by DBA?
LONG What is key and also explain its types?
Chapter Three Database
1). A relationship between countries and capitals is an example of----------- relationship.
- One-to-oneB. One-to-many c. Many-to-many d.None
- Which of the following a one-to-many relationship:
- Mother daughterb. Student-reg No c. Both d.None
- Which of the following is one-to-one relationship:
- Student reg Nob. Mother daughter c. Persone automobile d.None
- Merging the relation is also known:
- Which of the following is related to Modality?
- Optionalb. Unidirectional c. Both d.None
- Which of the following defines the nature of the relationship:
- Modalityb. Deision Tree c. Both d.None
Chapter Four Database
1., Every relation must have :
- Primary keyb. secondary key c, Candidate key d. none
- In 3NF, which form of dependency is removed:
- Functionalb. Non- Functional c. Associative d. Transtive
- Which of the following anomalies that can be caused by redundancy in tables:
- Insertionb. Deletion c. Modification d. All
- Which of the following anomalies that can be caused by Transitive dependency :
- Insertionb. Deletion c. Modification d. All
5 Table is also called a. Relation b. Key c. Entity d. None
SHORT) Define entity integrity? 2. Define Referential integrity? 3. What is Synonym? 4. What is Homonym? 5. Write a short Note on normalization? What is partial dependency? 7. Write a short note on transitive dependency? 8. What is anomalies?
Chapter Five
1., A report may be based on : a. Table b. Query v. Both d. None
- Columns of table are: a. table b. record c. field d. Cell
- The output of query is: a. Table b, Form c. Report d. Query
- Each set of related items in a table is called: a. Table b. Record c. Query d. None
SHORT) 1. Define Query? 2. What is report? 3. Define RDBMS? 4. Define wIzard? 5. What is MS Access? 6. Differ b/w Tital bar and Menu bar?
Chapter Six
1., How many types of relationship can be used: a. 2 b, 3 c. 4 d. 5
- How many table views are available in Micro soft Access:
- 4 b. 3 c. 2 d. 1
- Field properties determine
- Field size b. Input mask c. Default value d. All
- What is Z to A order is called: a. Ascending b, Descending
- Condescending d. None of these
- Which type of Query is used to join two table: a. select b. crosstable
- Find Duplicates d. Find Unmatch
- What is the term for characteristics or attribute of an object the determine how the object looks and behave:
- color b. size c. property d. None
SHORT) 1. What is join? 2. Write a short note on Action query? 3. What is filter and also write its types name? 4, Differ between ascending sort and descending Sort?
LONG) 1. What is table write a detail on its types and characteristics?
- What is Query discus its uses and advantages. Also write a complete Note on its types?
Chapter Seven
1.,How many are layout of report: a. 2 b. 3 c. 5 d. 4
- How many are layout are provided by Ms Access: a. 2 b. 3 c. 5 d. 4
- A form within a form is called: a. Multi form b. Sub form
- Main form d. None
- A form that contain a sub form is called:
- Report b. Form c. Main form d. none
SHORT QUESTIONS) 1. Define form? 2. W rite down any three uses of Form? 3. Write a short note on Sub-Form? 4. Differ between header and Footer?
LONG) 1. What is Form. Write down its uses and Advantages and also write its types with Detail?
- What is Report. Write down its uses and Advantages and also write its types with Detail?
No comments:
Post a Comment
Thanks for Visiting