In one-to-many relationship the table in ‘one’ side is called _______
Parent
Explanation: None
Child
Owner
None of Options are Correct
Category: Databases MCQs
Which database object is ideal to view, change, andanalyze datain different ways ?
Which database object is ideal to view, change, andanalyze datain different ways ?
Query
Explanation: None
Table
Form
Report
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
Explanation: None
Form
Report
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
Explanation: None
Data Refinement
Establishing Relationship
None of Options are Correct
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
Explanation: None
Parent
Master
Sister
What are the different view to present a Table ?
What are the different view to present a Table ?
All Of Options are correct
Explanation: None
Design View
Datasheet View
Pivote TableView
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
Explanation: None
One class may have many teachers
Many classes may have many teachers
Many teachers may have many classes
“SELECT name __ instructor name, course id
FROM instructor, teaches
WHERE instructor.ID= teaches.ID; Which keyword must be used here to rename the field name?
“
“
SELECT name ____ instructor name, course id
FROM instructor, teaches
WHERE instructor.ID= teaches.ID; Which keyword must be used here to rename the field name?
FROM instructor, teaches
WHERE instructor.ID= teaches.ID; Which keyword must be used here to rename the field name?
As
Explanation: As keyword is used to rename.
From
Rename
Join
In the given query which of the keyword has to be inserted? INSERT INTO employee _____ (1002,Joey,2000);
“
In the given query which of the keyword has to be inserted? INSERT INTO employee _____ (1002,Joey,2000);
Values
Explanation: Value keyword has to be used to insert the values into the table.
Relation
Table
Field
Which of the following statements contains an error?
Which of the following statements contains an error?
Select empid where empid = 1009 and lastname = ‘GELLER’;
Explanation: This query do not have from clause which specifies the relation from which the values has to be selected.
Select * from emp where empid = 10003;
Select empid from emp where empid = 10006;
Select empid from emp;