Priya Dogra – Certification | Jobs | Internships
Related Articles
Database Design and Development Certification Free Certificate | Multiple Choice Questions and Answers
Hi everyone, Here is an opportunity fr y’all. The Digital Adda has launched Database Design and Development Quiz & after completing the quiz you get Free Certificate.Get complete details below and apply:
Terms and Conditions:
- There are 20 MCQ Questions in this test
- You need to score atleast 50% to get a certificate
- A certificate of achievement will be awarded .
Benefits :
Get Database Design and Development Free Certificate from The Digital Adda which you can share in the Certifications section of your LinkedIn profile, on printed resumes, CVs, or other documents.
Question 1: Can DISTINCT command be used for more than one column?
No
Yes
Question 2: Can I call a trigger directly called from an application?
Yes
No
Question 3: A view is nothing but a __ table or a stored query
A. Dymanic
B. Real
C. Virtual
D. Static
Question 4: User() function returns the current users user name and
A. password
B. host name
C. both a and b above
D. database name associated with the user
Question 5: Which of the following ways below are the correct way to get the current date?
A. SELECT CURTIME();
B. SELECT CURDATE();
C. SELECT CURRENT_TIME();
D. All of above
Question 6: Which is the default order of sort in ORDER BY clause?
A. Ascending
B. Descending
Question 7: Enum values are stored according to their index numbers
True
False
Question 8: On executing DELETE command, if you get an error “foreign key constraint”- what does it imply?
A. Foreign key not defined
B. Table is empty
C. Connectivity issue
D. Data is present in the other table
Question 9: USE keyword is used to select a _
A. Table
B. Column
C. Database
D. All of above
Question 10: What is a candidate key?
A. Used to uniquely identify a row
B. Alias for primary key
C. Used to identify a column
D. Alias for foreign key
Question 11: How much storage space does DATETIME require?
A. 4 bytes
B. 2 bytes
C. 8 bytes
D. 1 bytes
Question 12: How can we get the number of records or rows in a table?
A. Using COUNT
B. Using NUM
C. Using NUMBER
D. Both a and c above
Question 13: Which of the following file extension is a valid MyISAM file extension?
A. .ism
B. .myd
C. .my
D. .mys
Question 14: When do we use a HAVING clause?
A. To limit the output of a query
B. To limit the output of a query using an aggregate function only
C. When GROUP by is used
D. both b and c above
Question 15: Write a select query to retrieve the records from the table Students?
A. SELECT FROM students
B. SELECT FROM students;
C. SELECT FROM “students”;
D. SELECT FROM ‘students’;
E. Both (a) and (b)
Question 16: How much character are allowed to create database name?
A. 64
B. 55
C. 72
D. 40
Question 17: Which of the following is used to delete an entire MYSQL database?
A. mysql_drop_database
B. mysql_drop_entiredb
C. mysql_drop_db
D. mysql_drop_dbase
Question 18: What SQL clause is used to restrict the rows returned by a query?
A. AND
B. WHERE
C. HAVING
D. FROM
Question 19: A __ is a stored program that is attached to a table or a view.
A. pseudofile
B. embedded SELECT statement
C. trigger
D. None of the above is correct.
Question 20: What is an advantage of placing computations in SQL views?
A. To save users from having to write an expression.
B. To ensure that the results are consistent.
C. To accomplish both of the above.
D.None of the above
APPLY FOR THE QUIZ : CLICK HERE
FOLLOW MY SOCIAL MEDIA CHANNELS, TELEGRAM CHANNEL, AND WHATSAPP GROUP FOR THE LATEST UPDATES ON FREE COURSES, CERTIFICATIONS, SCHOLARSHIPS, INTERNSHIPS, AND JOBS
