Select Category
All Categories
Accounting
Agriculture
Astrobiology
Banking & Finance
Business World
Civilizations
Commerce & Economics
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
Q1. Which are the operators for less than, greater than and equal to?
A. /=
B. =
C. () ==
D. <> ==
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. 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
Q4. Which feature of a DBMS enables a database to be interrogated based on specific criteria?
A. Query.
B. Report
C. Form
D. Relationship
Q5. All of the following could be attributes of an ENTITY called PERSON, except which one?
A. Gender
B. Natacha Hansen
C. Weight
D. Haircolor
Q6. Study this example of a database. Which field uses the Number format?
A. Birthdate
B. Favorite Color
C. Age
D. Name
Q7. This icon shows a
×
A. Table
B. Query
C. Form
D. Report
Q8. 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
Q9. What type of relationship exists between a person and national insurance number?
A. One to One
B. One to Many
C. Many to Many
Q10. ___ Aset of information held in a computer
A. Database
B. information
C. topic
Q11. 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
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. 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
Q14. 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
Q15. 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
Q16. An element of ERD where anything about which data are to be collected and stored
A. entity
B. attribute
C. relationship
D. constraint
Q17. Another name for a record
A. Field
B. Table
C. Tuple
D. Attribute
Q18. How many people can access a manual database at any one time?
A. Zero
B. One
C. Two
D. Unlimited
Q19. Find out the templates available in Access
A. Contacts
B. Nutrition Tracking
C. Call Tracker
D. All of the above
Q20. 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
Q21. The words- "and", "or", "not"- are examples of
A. Boolean Operators
B. Train Operators
C. Smooth Operators
D. Common Operators
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. What is an example of a database?
A. My best friend
B. Play Station
C. The Television
D. Phone Contacts
Q24. Which programming language type is the most basic human-readable and closest to actual machine language?
A. Interpreted
B. Assembly
C. Compiled
D. Query
Q25. Data is/has
A. raw facts
B. unprocessed information
C. no meaning
D. All of the above
Submitting Your Quiz...
Please wait while we process your answers