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. An element of ERD where anything about which data are to be collected and stored
A. entity
B. attribute
C. relationship
D. constraint
Q2. 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
Q3. What is an example of a database?
A. My best friend
B. Play Station
C. The Television
D. Phone Contacts
Q4. Data is/has
A. raw facts
B. unprocessed information
C. no meaning
D. All of the above
Q5. What type of relationship exists between a person and national insurance number?
A. One to One
B. One to Many
C. Many to Many
Q6. The words- "and", "or", "not"- are examples of
A. Boolean Operators
B. Train Operators
C. Smooth Operators
D. Common Operators
Q7. 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
Q8. Which are the operators for less than, greater than and equal to?
A. /=
B. =
C. () ==
D. <> ==
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. 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
Q11. 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
Q12. Which feature of a DBMS enables a database to be interrogated based on specific criteria?
A. Query.
B. Report
C. Form
D. Relationship
Q13. How many people can access a manual database at any one time?
A. Zero
B. One
C. Two
D. Unlimited
Q14. 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
Q15. Study this example of a database. Which field uses the Number format?
A. Birthdate
B. Favorite Color
C. Age
D. Name
Q16. 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
Q17. 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
Q18. ___ Aset of information held in a computer
A. Database
B. information
C. topic
Q19. Another name for a record
A. Field
B. Table
C. Tuple
D. Attribute
Q20. This icon shows a
×
A. Table
B. Query
C. Form
D. Report
Q21. 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
Q22. Please choose the correct Data Type to store the following:Payment re ceived? Yes/No
A. Text
B. Alphanumeric
C. Integer/Decimal
D. Boolean
Q23. All of the following could be attributes of an ENTITY called PERSON, except which one?
A. Gender
B. Natacha Hansen
C. Weight
D. Haircolor
Q24. 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
Q25. Find out the templates available in Access
A. Contacts
B. Nutrition Tracking
C. Call Tracker
D. All of the above
Submitting Your Quiz...
Please wait while we process your answers