Course Code dam461 Question The query given below will not give an error. Which one of the following has to be replaced to get the desired output?____ SELECT ID, name, dept name, salary * 1.1 WHERE instructor; Answer Where Question Here which of the following displays the unique values of the column? ____ SELECT ________ dept_name FROM instructor; Answer Distinct Question An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces. Answer 3, 20 Question SELECT * FROM employee What type of statement is this? ____ Answer DML Question Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database? Answer DML(Data Manipulation Langauge) Question A domain is atomic if elements of the domain are considered to be _______ units. Answer Indivisbile Question Course(course_id,sec_id,semester) Here the course_id, sec_id and semester are ______ and course is a _____ Answer Attributes, Relation Question For each attribute of a relation, there is a set of permitted values, called the ______ of that attribute. Answer Domain Question The term _______ is used to refer to a row. Answer Tuple Question A relational database consists of a collection of ____ Answer Tables Question The query given below will not give an error. Which one of the following has to be replaced to get the desired output?____ SELECT ID, name, dept name, salary * 1.1 WHERE instructor; Answer Where Question Here which of the following displays the unique values of the column? ____ SELECT ________ dept_name FROM instructor; Answer Distinct Question An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces. Answer 3, 20 Question SELECT * FROM employee What type of statement is this? ____ Answer DML Question Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database? Answer DML(Data Manipulation Langauge) Question A domain is atomic if elements of the domain are considered to be _______ units. Answer Indivisbile Question Course(course_id,sec_id,semester) Here the course_id, sec_id and semester are ______ and course is a _____ Answer Attributes, Relation Question For each attribute of a relation, there is a set of permitted values, called the ______ of that attribute. Answer Domain Question The term _______ is used to refer to a row. Answer Tuple Question A relational database consists of a collection of ____ Answer Tables Question The query given below will not give an error. Which one of the following has to be replaced to get the desired output? SELECT ID, name, dept name, salary * 1.1 WHERE instructor; Answer Where Question Here which of the following displays the unique values of the column? SELECT ________ dept_name FROM instructor; Answer Distinct Question An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces. Answer 3, 20 Question SELECT * FROM employee What type of statement is this? Answer DML Question Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database? Answer DML(Data Manipulation Langauge) Question A domain is atomic if elements of the domain are considered to be ____________ units. Answer Indivisbile Question Course(course_id,sec_id,semester) Here the course_id,sec_id and semester are __________ and course is a ________ Answer Attributes, Relation Question For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute. Answer Domain Question The term _______ is used to refer to a row. Answer Tuple Question A relational database consists of a collection of Answer Tables Try Another Search