Home

Advance DBMS MCQ Question with Answer

Advance DBMS MCQ with detailed explanation for interview, entrance and competitive exams. Explanation are given for understanding.

Download Advance DBMS MCQ Question Answer PDF

Try Advance DBMS Mock Test

Question No : 29
The statement in SQL which allows to change the definition of a table is

Select
Update
Create
Alter

Question No : 30
In client/server computing data are

sent only upon the client's request
sent in complete copies for the client to filter and sort
never sent to the client machine
sent in very large sections to save processing time

Question No : 31
Which of the following will NOT eliminates the ambiguities of a null value?

Define the attribute as required
Define subtypes
Define each attribute as having an initial value that is recognized as blank
Define supertypes

Question No : 32
Which of the following statements is not true about two tier client server database architecture?

SQL statements are processed on tier server
SQL statements may be processed on some of the clients
Business logic is mostly processed on clients
Business logic may be processed on the server

Question No : 33
The method by which the structure of the database is modified to eliminate hidden dependencies and replacing groups is

Normalization
Indexing
Enforcing referential integrity
Enforcing data integrity

Question No : 34
Which one of the following is provided by a data dictionary ?

User data
Database structure data
Sorted data
Functional data

Question No : 35
Benefit of database normalization is

smaller number of tables
higher query processing efficiency
reduced I/O for most queries
reduced data redundancy

Wanna test your skill? Here are some exams we prepared for you. So if you need to test your skill just attempt any exam from bellow.

Exam Name No. Of Q Link
Computer set 1 30 Start
Computer set 2 30 Start
Computer set 3 30 Start
Computer set 4 30 Start
Computer set 5 30 Start
Computer set 6 30 Start
Computer set 7 30 Start
Computer set 8 30 Start
Computer set 9 30 Start
Computer set 10 30 Start
Computer set 11 30 Start
Computer set 12 30 Start