D426 - Practice Test 2 | QUESTIONS AND AANSWERS
What is an entity in an ER model? A person, place, product, concept, or 3 multiple choice
activity options
Which SQL clause is used to filter WHERE 3 multiple choice
rows in a SELECT statement? options
The BETWEEN operator checks if Between an inclusive range of two 3 multiple choice
a value is: values options
What does the 'many' in a 1-M No exact numerical limit but more than 3 multiple choice
relationship imply? one options
Which operation combines rows JOIN 3 multiple choice
from two tables based on options
related columns?
In which normal form are all 3NF 3 multiple choice
non-key attributes fully options
functionally dependent on the
entire primary key, and nothing
but the key?
How are weak entities With a double rectangle 3 multiple choice
represented in an ER Diagram? options
Which SQL command is used to CREATE TABLE 3 multiple choice
create a new table? options
To calculate the square root of a SQRT() 3 multiple choice
number in SQL, you would options
, use:
Which SQL statement is used DELETE 3 multiple choice
to remove rows of data from options
a database?
What is a primary feature of Tables 3 multiple choice
relational databases? options
The LIKE operator is used to: Search for a specified pattern in a 3 multiple choice
column options
What is an entity in an ER model? A person, place, product, concept, or 3 multiple choice
activity options
Which SQL clause is used to filter WHERE 3 multiple choice
rows in a SELECT statement? options
The BETWEEN operator checks if Between an inclusive range of two 3 multiple choice
a value is: values options
What does the 'many' in a 1-M No exact numerical limit but more than 3 multiple choice
relationship imply? one options
Which operation combines rows JOIN 3 multiple choice
from two tables based on options
related columns?
In which normal form are all 3NF 3 multiple choice
non-key attributes fully options
functionally dependent on the
entire primary key, and nothing
but the key?
How are weak entities With a double rectangle 3 multiple choice
represented in an ER Diagram? options
Which SQL command is used to CREATE TABLE 3 multiple choice
create a new table? options
To calculate the square root of a SQRT() 3 multiple choice
number in SQL, you would options
, use:
Which SQL statement is used DELETE 3 multiple choice
to remove rows of data from options
a database?
What is a primary feature of Tables 3 multiple choice
relational databases? options
The LIKE operator is used to: Search for a specified pattern in a 3 multiple choice
column options
