(A) primary
(B) secondary
(C) logical
(D) foreign
Tag: Database Interview Questions
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