(A) Database Designers
(B) Database Administrators
(C) End Users
(D) Application Programmers
Tag: DBMS Mcqs
A software package designed to store and manage databases?
(A) DBMS
(B) Database
(C) Data
(D) Data Model
Select ‘NORTH’, CUSTOMER From CUST_DTLS Where REGION = ‘N’ Order By CUSTOMER Union Select ‘EAST’, CUSTOMER From CUST_DTLS Where REGION = ‘E’ Order By CUSTOMER.
(A) Has an error – the string should be in double quotes
(B) Has an error – ORDER BY clause
(C) Has an error – the string in single quotes ‘NORTH’ and ‘SOUTH’
(D) Does not have an error
Materialized views and Indexes are NOT similar by the following way(s).
(A) They must be refreshed when the data in their master tables changes
(B) They can be accessed directly using a SELECT statement
(C) They consume storage space
(D) All of the above
Which of the following is Advantage of Re-Hashing technique to handle the collisions?
(A) Collisions don’t use primary table space
(B) Unlimited number of elements
(C) Fast access through use of main table space
(D) Overhead of multiple linked lists
ALTER TABLE exams RENAME COLUMN Q_description TO Question_Descp, Std_ID to Student_ID. Syntax of ALTER TABLE is NOT correct.
(A) True
(B) False
Which of the following is an example of volatile memory?
(A) RAM
(B) ROM
(C) Flash Memory
(D) CPU
Which of the following is not true about input forms?
(A) Provide an easy, effective, efficient way to enter data into a table
(B) Especially useful when the person entering the data is not familiar with the inner workings
(C) Provide different controls to add data into the table
(D) One input forms can populate one table at a time