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 4
1
of
25
💡
Hints:
3
Q1. Which piece of validation shown can be defined as Range check
A. ("Cat", "Dog", "Tortoise", "Hamster")
B. Length = 4
C. >=10 and <=20
D. Required: Yes
Q2. Which Data Type is used to store whole numbers?
A. String
B. Integer
C. Double/Real
D. Boolean
Q3. Which software is used for coding the Python language?
A. Idea
B. IDLE
C. python Script
D. Connector
Q4. Referential integrity allows the following to happen
A. prevent orphan data
B. allow auto updates
C. allow auto deletes
D. All of the above
Q5. Which Register would be first to be accessed during the Fetch- DecodeExecute cycle?
A. PC
B. MAR
C. MDR
D. CIR
Q6. With SQL, how can you insert "Olsen" as the "LastName" in the "Per sons" table?
A. INSERT (’Olsen’) INTO Persons (LastName)
B. INSERT INTO Persons (LastName) VALUES (’Olsen’)
C. INSERT INTO Persons (’Olsen’) INTO LastName
D. INSERT INTOPersons INTO Last Name (’Olsen’)
Q7. Identification of the ___ will let you know where you are in the normalization process.
A. normal form
B. primary key
C. attributes
D. repeating groups
Q8. A tool used to organise and store information.
A. Spreadsheet
B. Word
C. Presentations
D. Database
Q9. Database is an organized collection of related
A. Data
B. Modules
C. Programs
D. Concept
Q10. A complete description of all the information relating to one item is called a
A. Field
B. Table
C. Record
D. Column
Q11. What would be the correct data type for the field ’Date of Birth’?
×
A. Auto Number
B. Date
C. Text
D. Date/Time
Q12. Many databases let you create queries that search whole fields or just parts of fields to find specific pieces of data.
A. TRUE
B. FALSE
Q13. A database is an organised collection of structured information, typically stored electronically in a computer system.
A. TRUE
B. FALSE
Q14. Ephesians 2:19-20
A. Through apostles and prophets the Church grew
B. My love is seen
C. Father of our spirit selves
D. My Light is Alive
Q15. A ___ enables you to view data from a table based on a specifica criterion.
A. Query
B. Report
C. Forms
D. All of the above
Q16. what is the function used to add a new data to the local storage?
A. localStorage.setItem(key , value)
B. localStorage.key(index)
C. localStorage["key"]
D. localStorage.removeItem(key)
Q17. Which database error commonly occurs when a user is creating a database that can result in data errors?
A. Entering the wrong data type in a field
B. Failing to identify a common field
C. Forgetting to assign each record an ID
D. Failing to add a foreign key
Q18. We can create a relational database using the software
A. MS Excel
B. MS Access
C. MS Word
D. All the above
Q19. In relational data model, the total number of rows can be identified as ___ .
A. Cardinality
B. Degree
C. Attribute
D. Entity
Q20. Which tab in the ribbon would take you to the option to make a report based on another object?
A. Home
B. Create
C. View
D. External Data
Q21. The complete information about an entity in a database is called
A. Field
B. Record
C. Information
D. All the other
Q22. Which of the following enables us to view data from a table based on a specific criterion?
A. Form
B. Query
C. Report
D. View
Q23. used to change the appearance of a control or the value in a control when certain conditions are met
A. conditional formatting
B. Control Wizards
C. stacked layout
D. unbound control
Q24. What is this button?
×
A. Last record
B. Next record
C. New record
D. Previous record
Q25. Which procedure involved reports?
A. computing using criteria
B. print preview of query
C. building forms
D. data types
Submitting Your Quiz...
Please wait while we process your answers