Quiz: Database Mock Test
Here is a very interesting quiz which is a database mock test for you. We have prepared this quiz to test your knowledge of the database and how well you understand that. There are many questions on the topic in the quiz; you will need to answer as many correctly as you can. In the end, your score will be a reflection of your knowledge of the subject. Let's go for it. Best of luck to you!
- 1.ENTITY INTEGRITY is a state where a column that is part of a primary key can have null values.
- A.
True
- B.
False
- 2.SQLCODE -922 is for authorization failure.
- A.
True
- B.
False
- 3.We Can use MAX on a CHAR column.
- A.
True
- B.
False
- 4.Every SQL statement is executable.
- A.
True
- B.
False
- 5.SUBSTR(CUSTNAME,1,3) will extract 1st 3 character from CUSTNAME string.
- A.
True
- B.
False
- 6.Which of the following DB2 objects allows multiple users to access data in a table, with each only being able to access certain portions of the data?
- A.
Views
- B.
Aliases
- C.
indexes
- D.
Mirrored tables
- E.
table constraints
- 7.Which one of the following is NOT a DB2 object?
- A.
Storage Group
- B.
Table
- C.
Synonym
- D.
Column
- 8.What does a positive value of SQL code mean?
- A.
Warning
- B.
Error
- C.
Successful execution
- D.
No rows found
- 9.AUTOMATIC RECOMPILATION occurs when
- A.
An existing index is dropped.
- B.
A new index is created.
- C.
Both A and B
- D.
None of the above
- 10.The final result of a DB2 BIND is
- A.
Load-module
- B.
DB2 catalog
- C.
Database request module
- D.
DB2 (application) Plan
- 11.In DB2, DATA is physically stored in
- A.
VSAM ESDS.
- B.
VSAM KSDS.
- C.
VSAM LDS
- D.
TABLES
- 12.DATABASE SERVICES doesn’t consist of
- A.
BIND
- B.
RUNTIME SUPERVISOR
- C.
PACKAGES.
- D.
PRECOMPILER.
- 13.Count(*) will return -----------------if the target table is empty.
- A.
0
- B.
1
- C.
2
- D.
3
- 14.All PLANS are stored in ____DB2 directory[Blank][Blank]_____.
- A.
SY.SYSPL
- B.
SYPSL.SB
- C.
SYSIBM.SYSPL
- D.
None of these
- 15.An ______ is an ordered set of pointers to rows of a base table.
- A.
Index
- B.
Opened-file
- C.
Auto-file
- D.
None of these
- 16..______ is a single bound DBRM with an optimized access path.
- A.
Box
- B.
Package
- C.
File
- D.
None of these
Questions: 9 | Attempts: 8642 | Last updated: Mar 21, 2022
-
Sample QuestionWhich of the following makes it possible for entities toshare a relationship?
Questions: 31 | Attempts: 7620 | Last updated: Mar 22, 2022
-
Sample Question-------------------------------responsible for authorizing access to the database, for coordinating and monitoring its use, acquiring software, and hardware resources, controlling its use, andmonitoring efficiency of operations.
Questions: 15 | Attempts: 7574 | Last updated: May 1, 2022
-
Sample QuestionThe Yellow Pages is an example of a paper-based database. True or false?
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- Hci Quizzes
- Internet Quizzes
- It Security Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top