Select Category
All Categories
Accounting
Agriculture
Astrobiology
Banking & Finance
Business World
Civilizations
Commerce & Economics
Competitive exams
Computer Science & IT
Current affairs
Earth Science
Education
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 2
1
of
25
💡
Hints:
3
Q1. This icon shows a
×
A. Table
B. Query
C. Form
D. Report
Q2. What type of relationship exists between a person and national insurance number?
A. One to One
B. One to Many
C. Many to Many
Q3. What is an example of a database?
A. My best friend
B. Play Station
C. The Television
D. Phone Contacts
Q4. Tables, queries, forms, and reports are objects that allow you to enter, store, analyze, and compile data how ever you want.
A. TRUE
B. FALSE
Q5. Data is/has
A. raw facts
B. unprocessed information
C. no meaning
D. All of the above
Q6. Find out the templates available in Access
A. Contacts
B. Nutrition Tracking
C. Call Tracker
D. All of the above
Q7. Please choose the correct Data Type to store the following:Payment re ceived? Yes/No
A. Text
B. Alphanumeric
C. Integer/Decimal
D. Boolean
Q8. ___ Aset of information held in a computer
A. Database
B. information
C. topic
Q9. Which programming language type is the most basic human-readable and closest to actual machine language?
A. Interpreted
B. Assembly
C. Compiled
D. Query
Q10. An element of ERD where anything about which data are to be collected and stored
A. entity
B. attribute
C. relationship
D. constraint
Q11. The words- "and", "or", "not"- are examples of
A. Boolean Operators
B. Train Operators
C. Smooth Operators
D. Common Operators
Q12. What does a Primary Key do
A. Collects fields and records together
B. Uniquely identifies each record
C. Unlocks the Database
D. Formats a Database into a table
Q13. The SQL BETWEEN operator
A. Specifies that a column is a primary key
B. Specifies which tables we are selecting from
C. Specifies a range to test
Q14. All of the following could be attributes of an ENTITY called PERSON, except which one?
A. Gender
B. Natacha Hansen
C. Weight
D. Haircolor
Q15. How many people can access a manual database at any one time?
A. Zero
B. One
C. Two
D. Unlimited
Q16. Which of the following SQL ORDER BY clauses would produce the records sorted in the order shown above.
×
A. ORDER BY last name ASC
B. ORDER BY first name ASC
C. ORDER BY school name ASC
Q17. Study this example of a database. Which field uses the Number format?
A. Birthdate
B. Favorite Color
C. Age
D. Name
Q18. Which of the following is the most important feature of DBMS:
A. Command language like SQL
B. Ability to back up data
C. Ease of use
D. Ability to automate some tasks
Q19. Which are the operators for less than, greater than and equal to?
A. /=
B. =
C. () ==
D. <> ==
Q20. This feature ensures records deleted in the Parent table will result in any related records deleted in the Child table.
A. Referential Integrity
B. Cascade Delete
C. Cascade Updated
D. Cascade amend
Q21. Another name for a record
A. Field
B. Table
C. Tuple
D. Attribute
Q22. Which type of software is considered the most difficult to learn?
A. Presentation software
B. Database software
C. Text document software
D. Basic image-editing software
Q23. Which feature of a DBMS enables a database to be interrogated based on specific criteria?
A. Query.
B. Report
C. Form
D. Relationship
Q24. If you host your database on Amazon EC2 instances, which of the following operations must you manage? (Choose all that apply)
A. Application optimization
B. OS Installation
C. OS patches
D. All of the above
Q25. To ensure best performance, in which of the following situations would you choose to store data in a NoSQL database instead of a relational database?
A. You need to perform a variety of complex queries against the data
B. You need to query data based on only one attribute
C. You need to store JSON documents
D. The data will be used by different applications
Submitting Your Quiz...
Please wait while we process your answers