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 1
1
of
25
💡
Hints:
3
Q1. The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
A. FALSE
B. TRUE
Q2. What is data?
×
A. Data is monitor
B. Data is information
C. Data is document
D. Data is a collection
Q3. Table Rows are called
A. fields
B. records
C. table
D. entry
Q4. Which of the following is DDL command?
A. Insert
B. Roll back
C. Create
D. Update
Q5. Ted is creating a database for several customers. What is the data type for the field customer name?
A. Yes/No
B. Data
C. Number
D. Currency
Q6. What does this SQL line mean:WHEREPUPIL.candidateNumber = SUBJECT.canditadeNumber
A. Makes a link between the PUPIL and SUBJECT tables
B. 2 Candidates must be equal to each other
C. PUPIL and SUBJECT are fields in the candidateNumber table
D. Ask your teacher if you do not know
Q7. Which Of The Following Is Not A Type Of Microsoft Access Database Object
A. Table
B. Form
C. Worksheets
D. Modules
Q8. Which of the following is NOT an example of a database?
A. telephone book
B. real estate listing
C. online library catalog
D. DVD
Q9. Which are disadvantages of distributed databases?
A. If data is stored and updated in more than one place there is an increased chance of data inconsistency.
B. Increased costs due to expensive communication lines.
C. There are security issues if sensitive personal data is being transferred.
D. All of the above
Q10. Primary Key field ___ contain a null value
A. Can
B. can’t
Q11. Which key press for quit Microsoft access
A. Control + w
B. Alt + F4
C. Alt + F5
D. Control + F4
Q12. If ye love me, keep my commandments
A. John 14:15
B. Matt 11:28-30
C. Eph. 4:11-14
D. Matt. 16:15-19
Q13. All databases require you to understand SQL.
A. TRUE
B. FALSE
Q14. I am a snapshot in time of the database that can be printed, sorted and grouped. I may be printed to look at monthly sales
A. Form
B. Report
C. Query
D. Filter
Q15. A graphical interface that allows users to query a database by filling in information on the form.
A. Table
B. Query
C. Form
D. Report
Q16. Which of these is NOT a validation rule?
A. Input Mask- Data should be spe cific format
B. Field Length- Only so many char acters
C. Spell Check- Checks the spelling is correct
D. List Check- Only options from a given list
Q17. Which datatype is suitable for your date of birth?
A. TEXT
B. NUMBER
C. DATE
D. TIME
Q18. Which database would you use to find a new fashion item?
A. A journal
B. A catalogue
C. A magazine
D. An encyclopedia
Q19. Mr. Cheek needs a printout of students arranged by age from oldest to youngest. This is an example of which type of sort?
A. Ascending
B. Descending
C. Primary Sort
D. Secondary Sort
Q20. Integrity is protecting the database from unauthorised users.
A. TRUE
B. FALSE
Q21. Can you identify this logo?
×
A. Google Cloud
B. Alibaba Cloud
C. Tencent Cloud
D. Amazon Cloud
Q22. A collection of fields related or associated with a focal point is called?
A. File
B. Database
C. Field
D. Record
Q23. The records of a table can be of ___ order.
A. Any
B. Same
C. Sorted
D. Constant
Q24. In a database form, the blanks in which information is entered are called
A. Fields
B. Record
C. Query
D. Database
Q25. A secondary key is;
A. A second way to open the Lab door
B. A second table in a database
C. Two columns with the same data in a database
D. A candidate key until the primary key is selected
Submitting Your Quiz...
Please wait while we process your answers