Select Category
All Categories
Accounting
Agriculture
Civilizations
Computer Science & IT
Current affairs
Earth Science
Environment
Explore the Animal World
Food chain
General Knowledge
Geography Map
History
Human Health
Journalism
Law
Science
Social Science
About Us
Contact Us
Login
DBMS - Part 2
1
of
25
Q1. 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
Q2. What is an example of a database?
A. My best friend
B. Play Station
C. The Television
D. Phone Contacts
Q3. Data is/has
A. raw facts
B. unprocessed information
C. no meaning
D. All of the above
Q4. Another name for a record
A. Field
B. Table
C. Tuple
D. Attribute
Q5. The words- "and", "or", "not"- are examples of
A. Boolean Operators
B. Train Operators
C. Smooth Operators
D. Common Operators
Q6. What type of relationship exists between a person and national insurance number?
A. One to One
B. One to Many
C. Many to Many
Q7. Which programming language type is the most basic human-readable and closest to actual machine language?
A. Interpreted
B. Assembly
C. Compiled
D. Query
Q8. 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
Q9. Study this example of a database. Which field uses the Number format?
A. Birthdate
B. Favorite Color
C. Age
D. Name
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. Find out the templates available in Access
A. Contacts
B. Nutrition Tracking
C. Call Tracker
D. All of the above
Q12. 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
Q13. Which are the operators for less than, greater than and equal to?
A. /=
B. =
C. () ==
D. <> ==
Q14. 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
Q15. 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
Q16. Which of the following SQL ORDER BY clauses would produce the records sorted in the order shown above.
×
A. ORDER BYlastname ASC, school name ASC;
B. ORDER BYfirstname ASC, school name ASC;
C. ORDER BY schoolname ASC, last name ASC;
D. ORDERBYschoolnameASC,first name ASC;
Q17. All of the following could be attributes of an ENTITY called PERSON, except which one?
A. Gender
B. Natacha Hansen
C. Weight
D. Haircolor
Q18. This icon shows a
×
A. Table
B. Query
C. Form
D. Report
Q19. 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
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. Which feature of a DBMS enables a database to be interrogated based on specific criteria?
A. Query.
B. Report
C. Form
D. Relationship
Q22. 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
Q23. How many people can access a manual database at any one time?
A. Zero
B. One
C. Two
D. Unlimited
Q24. Please choose the correct Data Type to store the following:Payment re ceived? Yes/No
A. Text
B. Alphanumeric
C. Integer/Decimal
D. Boolean
Q25. ___ Aset of information held in a computer
A. Database
B. information
C. topic
Important:
All questions are mandatory. Please answer every question to submit your quiz.
Submitting Your Quiz...
Please wait while we process your answers