In one-to-many relationship the table on ‘many’ side is called _______
Child
Well Done. Your Answer is Correct Keep it Up!
Master
Parent
Sister
Tag: Databases MCQs
What do you mean by one to many relationship between Teacher and Class table?
What do you mean by one to many relationship between Teacher and Class table?
One teacher can have many classes
Well Done. Your Answer is Correct Keep it Up!
One class may have many teachers
Many classes may have many teachers
Many teachers may have many classes
_______ is a constraint that can be defined only at the column level?
_______ is a constraint that can be defined only at the column level?
CHECK
Well Done. Your Answer is Correct Keep it Up!
NOT NULL
UNIQUE
PRIMARY KEY
What is the need for our query to execute successfully on an existing view?
What is the need for our query to execute successfully on an existing view?
We must have a SELECT privilege on the view.
Well Done. Your Answer is Correct Keep it Up!
The specified table must contain data.
We should have a SELECT privilege only on the specified table.
The specified table must be in the same database or schema.
Which data dictionary table can be used to show the object privileges granted to the user on specific columns?
Which data dictionary table can be used to show the object privileges granted to the user on specific columns?
USER_COL_PRIVS
Well Done. Your Answer is Correct Keep it Up!
USER_TAB_PRIVS
USER_COL_PRIVS_MADE
USER_TAB_PRIVS_MADE
What is the advantage of the clustered index?
What is the advantage of the clustered index?
It minimizes the page transfer and maximizes the cache hits.
Well Done. Your Answer is Correct Keep it Up!
It does not need extra work for SQL queries.
It is fast to update the records.
None of the options are correct
________ is a program that performs some common action on database data and also stored in the database.
________ is a program that performs some common action on database data and also stored in the database.
Stored Procedure
Well Done. Your Answer is Correct Keep it Up!
Trigger
Stored Function
None of the options are correct
______ is NOT a type of constraint in SQL language?
______ is NOT a type of constraint in SQL language?
ALTERNATE KEY
Well Done. Your Answer is Correct Keep it Up!
UNIQUE
PRIMARY KEY
FOREIGN KEY
When the wildcard in a WHERE clause is useful?
When the wildcard in a WHERE clause is useful?
When an exact match is not possible in a SELECT statement.
Well Done. Your Answer is Correct Keep it Up!
When an exact match is required in a SELECT statement.
When an exact match is required in a CREATE statement.
When an exact match is not possible in a CREATE statement.
Which operator is used to compare the NULL values in SQL?
Which operator is used to compare the NULL values in SQL?
IS
Well Done. Your Answer is Correct Keep it Up!
IN
Equal
None of the options are correct