CS403P Quiz 5 Solved by Munir
Question #1:
Consider the following relation:
STD(stId, stName, stAdr, prName, prCrdts)
stId → stName, stAdr, prName, prCrdts
prName → prCrdts
Which of the following dependency exists in the above relation?
Options:
A) Composite dependency
B) Transitive dependency
C) Terminal dependency
D) Reflexive dependency
Answer: B) Transitive dependency
Question #2:
Which of the following is NOT related to the basic SELECT statement?
Options:
A) WHERE
B) SELECT
C) FROM
D) NOT NULL
Answer: D) NOT NULL
Question #3:
A table is in third normal form if it is in second normal form and there is no __________.
Options:
A) Full functional dependency
B) Transitive dependency
C) Partial dependency
D) Consistency
Answer: B) Transitive dependency
Question #4:
A transitive dependency occurs when __________.
Options:
A) Primary key attribute is dependent on a non-key attribute
B) Non-key attribute is dependent on another non-key attribute
C) Part of the key is dependent on a key attribute
D) Non-key attribute is not dependent on another non-key attribute
Answer: B) Non-key attribute is dependent on another non-key attribute
Question #5:
___________ in an SQL table is used to uniquely identify individual rows of a given table.
Options:
A) Primary key column
B) Secondary key column
C) NOT NULL constraints
D) Foreign key column
Answer: A) Primary key column
We Provide Paid Services (LMS Handling, QUIZ, GDB's, Assignments)
Contact Us Click Here
Question #6:
Which of the following is NOT a type of integer data type in SQL?
Options:
A) Smallint
B) Int
C) Smallint
D) Smallerint
Answer: D) Smallerint
Question #7:
From the following options, choose the correct statement for the third normal form.
Options:
A) There is redundant data in the relation
B) Non-key attribute is dependent on another non-key attribute
C) No non-key attribute is dependent on another non-key attribute
D) There is partial dependency in the relation
Answer: C) No non-key attribute is dependent on another non-key attribute
Question #8:
Which of the following command is used to insert data into tables?
Options:
A) DML
B) DDL
C) DLD
D) DQL
Answer: A) DML
Question #9:
Which of the following wildcard placeholders allows matching any string of any length, including zero length?
Options:
A) _
B) @
C) %
D) #
Answer: C) %
Question #10:
Which of the following is NOT related to the CREATE TABLE command?
Options:
A) Data types
B) Attributes
C) Records
D) Constraints
Answer: C) Records
CS403P Graded Quiz 3 Solved by Munir
Question #1:
If a relation is not in third normal form, then anomalies are due to ________.
Select the correct option:
a) Partial dependency
b) Transitive dependency
c) Reflexive dependency
d) Full functional dependency
Correct option: a) Partial dependency
Question #2:
Wild card character is used with_________ operator.
Select the correct option:
a) NOT NULL
b) NULL
c) Binary
d) Like
Correct option: d) Like
Question #3:
Which of the following is NOT related to the basic SELECT statement?
Select the correct option:
a) WHERE
b) SELECT
c) NOT NULL
d) FROM
Correct option: c) NOT NULL
Question #4:
___________ in SQL table is used to uniquely identify individual rows of a given table.
Select the correct option:
a) NOT NULL constraints
b) Foreign key column
c) Secondary key column
d) Primary key column
Correct option: d) Primary key column
Question #5:
___________ is not a DML command.
Select the correct option:
a) CREATE
b) UPDATE
c) INSERT
d) SELECT
Correct option: a) CREATE
Question #6:
___________ SQL statement is used to enter values into columns.
Select the correct option:
a) INSERT INTO
b) ENTER INTO
c) INSERT TOP
d) PUT INTO
Correct option: a) INSERT INTO
Question #7:
Which of the following commands is used to create a database table and its structure?
Select the correct option:
a) DML
b) DQL
c) DDL
d) DCL
Correct option: c) DDL
Question #8:
Which of the following is the correct syntax for creating a database table?
Select the correct option:
a) CREATE TABLE;
b) CREATE MYSQL TABLE name;
c) TABLE name CREATE;
d) CREATE TABLE name;
Correct option: d) CREATE TABLE name;
Question #9:
Which of the following is the correct syntax for inserting some values into the employee table?
Select the correct option:
a) INSERT into (col1, col2, col3) VALUES (val1, val2, val3)
b) INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)
c) INSERT into employee COLUMN (col1, col2, col3) VALUES (val1, val2, val3)
d) INSERT into employee (col1, col2, col3), (val1, val2, val3)
Correct option: b) INSERT into employee (col1, col2, col3) VALUES (val1, val2, val3)
Question #10:
A transitive dependency occurs when __________.
Select the correct option:
a) Primary key attribute is dependent on non-key attribute
b) Non-key attribute is not dependent on another non-key attribute
c) Non-key attribute is dependent on another non-key attribute
d) Part of the key is dependent on key attribute
Correct option: c) Non-key attribute is dependent on another non-key attribute