Select Category
All Categories
Accounting
Agriculture
Astrobiology
Banking & Finance
Business World
Civilizations
Commerce & Economics
Competitive exams
Computer Science & IT
Current affairs
Earth Science
Educational Development
Environment
Explore the Animal World
Food chain
General Knowledge
Geography Map
Green Life
History
Human Health
Journalism
Law
Science
Social Science
TAX
About Us
Contact Us
Login
DBMS - Part 3
1
of
25
💡
Hints:
3
Q1. PRIMARY KEY does allow the NULL VALUES.
A. Yes
B. No
Q2. Each column represents a
A. relation
B. attribute
C. record
D. field
Q3. What is a foreign key?
A. A filed that holds unique values in the host table
B. A field that is used to link to unique values in another table
C. A way to unlock data about other countires
D. A physical key to open a door or cabinet
Q4. Which topology is this?
×
A. Bus
B. Star
C. Ring
D. Wave
Q5. Which of these is not a type of data which might be recorded by a school about a Year 10 pupil?
A. IQ
B. Scores
C. Grade level
D. Tax Number
Q6. Comparison operators used for comparing values " >= " means that " Greater than or equal to "
A. TRUE
B. FALSE
Q7. To create reports you need to select ___ option available under Tasks.
A. Use Wizard
B. Wizard
C. Use
D. All of the above
Q8. Which statement below refers to purpose of Primary Key?
A. To create a link or cross reference between one table to another.
B. To implement a relationship between two tables in a relational database.
Q9. Can you find interesting information on the internet for your research?
A. Yes! There are some great sites, however there are many not so great sites and it’s hard to tell them apart.
B. No. The internet is never used for research
Q10. For an ID number which is created by the software each time a new record is added, you use datatype
A. Generate
B. NewNumber
C. Autonumber
D. Automatic
Q11. A field that connects one table to another table that creates a relationship is called:
A. Car Key
B. Foreign Key
C. Main Key
D. Primary Key
Q12. We can retrieve data from a database to be printed using a
A. form
B. table
C. query
D. report
Q13. What is circled here?
×
A. File
B. Field
C. Record
D. None of the above
Q14. Assume that there is "Product+" in a DTD. The (+) symbol indicates
A. Product occurs one or more times
B. The child element of product occurs zero or more times
C. Either zero occurrences or exactly one occurrence for product
D. It is the root element.
Q15. In a Relational Database, a field is
A. The smallest unity of meaningful data to be stored in a file or database
B. The largest unit of meanngful data to be stored in a file or database
C. All of the above
D. None of the above
Q16. A record contains all ___ for one topic/person.
A. Cell
B. Fields
C. Column
D. Record
Q17. It is difficult to access conventional f ile system than Database System.
A. TRUE
B. FALSE
Q18. What is missing in the following code?CREATE TABLE table-name;
A. Column name
B. Column name and data type
C. Database name
Q19. Through apostles and prophets the Church grew
A. Ephesians 2:19-20
B. Matt 11:28-30
C. Eph. 4:11-14
D. Matt. 16:15-19
Q20. Analysis activity pertain to -
A. Deliverable-functional system specifications
B. Deliverable-detailed design specifications
C. Deliverable-program/data structures, technology purchases, organization redesigns
D. none of the above
Q21. Advantages of The Database Approach
A. *Planned data redundancy*Improved data consistency*Improved data sharing
B. *New, specialized personnel*Installation and management cost and complexity
C. *Conversion costs*Need for explicit backup and recovery
D. None of the above
Q22. For a table to be in 4NF, what must the table not have?
A. Multi-valued dependencies
B. Join dependencies
Q23. Apersonnel file might contain records that have fields. Which of the following might a personnel file contain?
A. name field
B. address field
C. phone number field
D. all of the above
Q24. The word information implies?
A. information implies data that has no organisation or processing to facilitate understanding.
B. information implies data is highly organised or processed to prevent understanding.
C. information implies data that has had some organisation or processing to facilitate understanding.
Q25. monthname(2020/04/07) will return the value
A. 4
B. 7
C. April
Submitting Your Quiz...
Please wait while we process your answers