Data Models into Database Designs - General Questions Online Exam Quiz
Data Models into Database Designs - General Questions GK Quiz. Question and Answers related to Data Models into Database Designs - General Questions. MCQ (Multiple Choice Questions with answers about Data Models into Database Designs - General Questions
Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
Options
A : A domain constraint
B : A range constraint
C : An intrarelation constraint
D : An interrelation constraint
In a 1:N relationship, the foreign key is placed in:
Options
A : either table without specifying parent and child tables.
B : the parent table.
C : the child table.
D : either the parent table or the child table.
Which of the following column properties specifies whether or not cells in a column must contain a data value?
Options
A : Null status
B : Data type
C : Default value
D : Data constraints
A primary key should be defined as:
Options
A : NULL.
B : NOT NULL.
C : Either of the above can be used.
D : None of the above are correct.
Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Options
A : Null status
B : Data type
C : Default value
D : Data constraints
Which of the following situation requires the use of ID-dependent entities?
Options
A : Association relationships only
B : Multivalued attributes only
C : Archetype/instance relationships only
D : All of the above use ID dependent entities
A foreign key is:
Options
A : a column containing the primary key of another table.
B : used to define data types.
C : used to define null status.
D : all of the above are above correct.
Which of the following columns is(are) are required in a table?
Options
A : A foreign key
B : An alternate key
C : A primary key
D : A surrogate key.
In a 1:1 relationship, the foreign key is placed in:
Options
A : either table without specifying parent and child tables.
B : the parent table.
C : the child table.
D : either the parent table or the child table.
Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
Options
A : Null status
B : Data type
C : Default value
D : Data constraints
Advanced SQL - General Questions more Online Exam Quiz
The Database Development Process - General Questions
The Database Environment - General Questions
ER Model and Business Rules - General Questions
The Internet Database Environment - General Questions
The Relational Model and Normalization - General Questions
XML and ADO.NET - General Questions
Boolean Algebra and Logic Simplification - General Questions
Code Converters and Multiplexers - General Questions