(A) primary
(B) secondary
(C) logical
(D) foreign
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
Which of the following is a feature of CHECK constraint?
(A) limit the values that can be placed in a column
(B) used to enforce referential integrity
(C) enforces the uniqueness of the values in a set of columns
(D) is a unique identifier for a row within a database table
Which of the following might be represented with a multivalued attribute?
(A) person’s name
(B) class location
(C) bank account balance
(D) book title
Which of the following constraints enforces entity integrity?
(A) PRIMARY KEY
(B) FOREIGN KEY
(C) CHECK
(D) NOT NULL
Data Redundancy Means?
(A) Security of data
(B) Duplication of data
(C) Management of data
(D) Recovery of data
A __ relationship exists when an association is maintained within a single entity?
(A) Unary
(B) Binary
(C) Ternary
(D) Weak
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) Does not have an error
(D) Has an error – the string in single quotes ‘NORTH’ and ‘SOUTH’
Materialized views and Indexes are NOT similar by the following way(s)?
(A) They consume storage space
(B) They must be refreshed when the data in their master tables changes
(C) They can be accessed directly using a SELECT statement
(D) All of the Given