In one-to-many relationship the table in ‘one’ side is called _______
Parent
Well Done. Your Answer is Correct Keep it Up!
Child
Owner
None of the options are correct
Category: Computer Science
Which of the following enables us to view data from a table based on a specific criterion
Which of the following enables us to view data from a table based on a specific criterion
Query
Well Done. Your Answer is Correct Keep it Up!
Report
Form
Macro
In which state one gathers and list all the necessary fields for the database design project.
In which state one gathers and list all the necessary fields for the database design project.
Data Definition
Well Done. Your Answer is Correct Keep it Up!
Data Refinement
Establishing Relationship
None of the options are correct
What are the different view to present a Table ?
What are the different view to present a Table ?
All options are correct
Well Done. Your Answer is Correct Keep it Up!
Datasheet View
Design View
Pivote TableView
In one-to-many relationship the table on ‘many’ side is called _______
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
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