Home > Information Technology (IT) Support Executive > Quizzes > Database System Assistant Practice Test: Database and Table Creation
Database System Assistant Practice Test: Database and Table Creation
Fast practice, instant feedback. Timer auto-submits when time’s up.
Avg score: 67% • Most missed: “The user defined data type can be created using ”
Database System Assistant Practice Test: Database and Table Creation
Time left 00:00
18 Questions

1. Which of the following is not included in DML (Data Manipulation Language)?
2. Data integrity control _______  .
3. Determine data type for the given column? Column Name: IFSC_Code; Description: A 11 Character alphanumeric code that identifies a bank branch; Example: SBIN0009044
4. The language used application programs to request data from the DBMS is referred to as __________
5. Determine the most suitable data type for the given column? Column Name: Profile_Image ; Description: Image of the employee
6. Determine data type for the given column? Column Name:Price; Description: Cost of an item in rupees and paise; Example: 200.21
7. Data integrity refers to ?
8. The user defined data type can be created using     
9. Choose the most suitable data type in case multiple data types are possible for the column. Column Name: PIN_Code ; Description: Six digit numeric PIN code for any address in India ; Example: 560100
10. Which key accepts multiple NULL values?
11. By default, which key creates Clustered index?
12. Choose the most suitable data type in case multiple data types are possible for the column. Column Name: PIN_Code ; Description: Six digit numeric PIN code for any address in India ; Example: 560100
13. Determine the most suitable data type for the given column? Column Name: Profile_Image ; Description: Image of the employee
14. Choose the most suitable data type in case multiple data types are possible for the column.Column Name: Date_Of_Birth ; Description: Date of Birth of the employee ; Example: 1990/01/01
15. SQL allows comparison operations on the data types i.e.,
16. What is true about Unique and primary key?
17. Which of the following is not included in DML (Data Manipulation Language)?
18. Choose the most suitable data type in case multiple data types are possible for the column. Column Name: Student_id ; Description: Unique number assigned to every Student ; Example: 100000

⚡ Recently practiced quizzes in this topic
Live quiz activity
Multimedia Animation and Special Effects Practice Test: Basics of 3ds Max Database System Assistant Practice Test: Introduction To Database Assistant Database System Assistant Practice Test: Open Tools in Database Systems Information Technology Support Executive Practice Test: PageMaker & CorelDraw Database System Assistant Practice Test: MySQL Open Source Database Database System Assistant Practice Test: Taking Backup and Restoring Backup
 
❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

🌈  Our mission is to help improve your scores in any subject and exam withonline quizzes, practice tests, study guides, & advice for students. Since 2018.
About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | OSHA Basics Quiz | What Should We Know?
Privacy | Terms |
Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.