JOBSEEKERS
Login
Sign Up
Jobseeker
Employer
Staffing Firm
Direct Client
MySQL interview questions part 53
MySQL interview questions part 53
Back
Take as many assements as you can to improve your validate your skill rating
Total Questions: 20
1. Which one of the following is known as the key to object-oriented programming ?
A. Declaring primary key
B. Declaring Foreign Key
C. Restrictions on columns
D. All of the mentioned
Show Correct Answer
Correct Answer is :
All of the mentioned
2. Which one among the following means tight coupling ?
A. DESC table_name;
B. DESC table_name
C. DESC
D. None of the mentioned
Show Correct Answer
Correct Answer is :
DESC table_name;
3. UML stands for?
A. gender char(1) check( gender IN (‘M’, ‘F’)),
B. gender char (1) check,
C. gender char (1) check ( gender ),
D. none of the mentioned
Show Correct Answer
Correct Answer is :
gender char(1) check( gender IN (‘M’, ‘F’)),
4. In a class diagram the class is divided into three sections, what is displayed in the first section?
A. ENUM
B. ENUM1
C. ENUM2
D. None of the mentioned
Show Correct Answer
Correct Answer is :
ENUM
5. ___ are used in class diagrams to describe the way in which specific elements should be used.
A. gender ENUM (‘M’, ‘F’),
B. gender ENUM,
C. gender ENUM ( ),
D. none of the mentioned
Show Correct Answer
Correct Answer is :
gender ENUM (‘M’, ‘F’),
6. Which one of the following is displayed below the class name in the class diagrams?
A. Absence of value
B. Unknown
C. Empty set
D. All of the mentioned
Show Correct Answer
Correct Answer is :
All of the mentioned
7. Which relationship is illustrated by a line that begins with an unfilled diamond?
A. Lesser number of columns
B. Incorrect definition
C. Primary key is missing
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Primary key is missing
8. If the diamond is filled it depicts which relationship?
A. Primary key
B.
C. Foreign Key
D. A ”foreign Key” belong to this particular table
Show Correct Answer
Correct Answer is :
A ”foreign Key” belong to this particular table
9. Which one of the following statements is true about sequence diagrams?
A.
B. 0
C. 1
D. -1
Show Correct Answer
Correct Answer is :
10. A bidirectional relationship in class diagrams is described by________
A. It defines the tables used by a query
B. It defines the linking of tables in Mysql
C. It defines the tables used by a query & linking of tables in Mysql
D. None of the mentioned
Show Correct Answer
Correct Answer is :
It defines the tables used by a query & linking of tables in Mysql
11. # is the visibility code for?
A. Permanent Tables
B. Virtual tables
C. Temporary tables
D. All of the mentioned
Show Correct Answer
Correct Answer is :
All of the mentioned
12. Which one of the following is displayed in the third section of the class diagram?
A. Permanent Tables
B. Virtual tables
C. Temporary tables
D. All of the mentioned
Show Correct Answer
Correct Answer is :
Permanent Tables
13. Which one of the following is not a valid class name?
A. Permanent Tables
B. Virtual tables
C. Temporary tables
D. All of the mentioned
Show Correct Answer
Correct Answer is :
Virtual tables
14. Fill in the blank with the best option. An Object is a/an ________ of a class.
A. Rows returned by sub query
B. Permanent tables
C. Virtual tables
D. All of the mentioned
Show Correct Answer
Correct Answer is :
Rows returned by sub query
15. There are two objects- $product1 = new Shop(); $product2 = new Shop(); Which one of the following statements is right about them?
A. FROM
B. WHERE
C. ORDER BY
D. All of the mentioned
Show Correct Answer
Correct Answer is :
FROM
16. Which version of PHP introduced the visibility keywords i.e public, private, and protected?
A. “VIEW” is a query that stored in the data dictionary
B. There is no data associated with “VIEW”
C. “VIEW” creates virtual tables in Database
D. All of the mentioned
Show Correct Answer
Correct Answer is :
All of the mentioned
17. Which characters is used to access property variables on an object-by-object basis?
A. FROM
B. WHERE
C. SELECT
D. None of the mentioned
Show Correct Answer
Correct Answer is :
FROM
18. Code that uses a class, function, or method is often described as the..
A. Permanent Tables
B. Virtual tables
C. Temporary tables
D. None of the mentioned
Show Correct Answer
Correct Answer is :
Virtual tables
19. Which keyword precedes a method name?
A. CREATE TABLE;
B. CREATE VIEW
C. Both CREATE TABLE; and CREATE VIEW
D. None of the mentioned
Show Correct Answer
Correct Answer is :
None of the mentioned
20. If you omit the visibility keyword in your method declaration, by default the method will be declared as..
A. To hide columns from the users
B. To hide the complexity of the database
C. To simplify complexity of database design
D. All of the mentioned
Show Correct Answer
Correct Answer is :
All of the mentioned
Similar Interview Questions
Search for latest jobs
Find Jobs