Tag: DBMS Mcq

(A) Zero or more of the preceding character
(B) Any one character in the position held by the ?
(C) Multiple characters in the position held by the ?
(D) Any letter in the position held by the ?

(A) Month: Format([EMP_DOB],”m”)
(B) Month: Format([EMP_DOB],”mm”)
(C) Month: Format([EMP_DOB],”mmm”)
(D) Month: Format([EMP_DOB],”mmmm”)

(A) >= “01/01/1996”
(B) >= 01/01/1996
(C) >= #01/01/1996#
(D) >= ’01/01/1996′

(A) static and change queries
(B) static and action queries
(C) select and action queries
(D) select and change queries

(A) SQL for
(B) Query Code Generator
(C) Query by Example
(D) SQL compiler

(A) Delete the employees from the STORE to be deleted
(B) Permanently remove the referential integrity enforcement
(C) Open the EMPLOYEE table in the design format; then change the Required property of the EMPLOYEE’s FK to No and make sure that its default value is set to null
(D) Delete all relationships between STORE and EMPLOYEE. Redesign the database to work without them

(A) The relationship lines are thick and dark, and the nature of the relationships is labeled
(B) The relationship lines are thin, and the nature of the relationships is labeled
(C) Right-click the relationship line to see if enforce referential integrity is checked
(D) Right-click the relationship line, select referential integrity, and look at the relationship’s properties

(A) :1 relationships are only possible if the tables contain a supertype and subtype
(B) Make sure that the PK in the related table has unique values
(C) Make sure that the FK in the related table has an index property that specifies unique values
(D) Nothing special is required