Sql multiple choice questions

Для ботов

Subscribe to RSS

You will have to read all the given answers and click over the correct answer. If you are not sure about the answer then you can check the answer using Show Answer button. You can use Next Quiz button to check new set of questions in the quiz. A - A Cartesian product is formed when a join condition is omitted. B - A Cartesian product is formed when a join condition is valid. C - Some rows in the first table are joined to all rows in the second table. D - All rows in the first table are joined to some rows in the second table. A - select h. B - select h. C - select h. A - Subqueries could be used for Top-N analysis. B - Subqueries can be of two types — single-row subquery and multiple-row subquery. C - The outer and inner queries can get data from different tables. C - You cannot delete rows based on values from another table. B - This statement also record information in the data dictionary. A - All the data in the table are deleted. C - The indexes in the table are deleted. A - They are used for generating sequential numbers. Previous Page. Next Page. Show Answer. A - Q 3 - Which of the following is true about Cartesian Products? Q 5 - Which of the following is true about subqueries? D - All of the above. Q 6 - Which of the following is true about removing rows from a table? A - This is a DML statement.

SQL Multiple Choice Question set-1

The test is not official, it's just a nice way to see how much you know, or don't know, about SQL. You will get 1 point for each correct answer. At the end of the Quiz, your total score will be displayed. Maximum score is 25 points. The Bootstrap Certificate documents your knowledge of the Bootstrap framework. If you want to report an error, or if you want to make a suggestion, do not hesitate to send us an e-mail:. Start the Quiz Good luck! W3Schools' Online Certification The perfect solution for professionals who need to balance work, family, and career building. More than 25 certificates already issued! HOW TO. Your message has been sent to W3Schools. W3Schools is optimized for learning, testing, and training. Examples might be simplified to improve reading and basic understanding. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using this site, you agree to have read and accepted our terms of usecookie and privacy policy. Copyright by Refsnes Data. All Rights Reserved. Powered by W3.

PL/SQL (MCQ) questions and answers - Placement Tests

SQL stand for Structured query language and this is the basic of almost all the database driven software. How much you are efficient in SQL will also define you much time and money you can save the development cost of your software. What is the full form of SQL? Originally based upon relational algebra and tuple relational calculus, SQL consists of a data definition language and a data manipulation language. The scope of SQL includes data insert, query, update and delete, schema creation and modification, and data access control. Which operator performs pattern matching? What operator tests column for the absence of data? In SQL, which of the following is not a data definition language commands? This, of course, necessarily means that there will be redundancies. What if we only want to select each distinct element? This is easy way to accomplish in SQL. The syntax is as follows:. Which of the SQL statements is correct? Which SQL keyword is used to retrieve only unique values? Which SQL keyword is used to retrieve a maximum value? What is a view? A A view is a special stored procedure executed when certain event occurs. B A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are. C A view is a database diagram. A view do not contain data of their own. They are used to restrict access to the database or to hide data complexity. Which of the following SQL commands is used to retrieve data? Which of the following is a SQL aggregate function? Which SQL statement is used to update data in a database? Which SQL keyword is used to sort the result-set? Which of the following group functions ignore NULL values? Table Employee has 10 records. So, in that 10 records one of the record will be minimum which cannot be greater than any nine value of the salary column. The syntax is: ROUND expression, [decimal place] where [decimal place] indicates the number of decimal points returned. A negative number means the rounding will occur to the digit to the left of the decimal point. For example, -1 means the number will be rounded to the nearest tens. For above given example, the output would be 50 because the nearest tens of Taking another example, if we have to round

SQL Multiple Choice Question set-1

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. I have two tables, Questions and Answers which store the multiple choice question and the 4 possible answers, respectively. I am trying to insert one question along with its 4 answers at a time. Expected output: I want the above command or what it should change to to make the following changes to the tables:. You have done what is called a cyclic reference. Here you have placed contraints on both table of each other. So you can not insert neither because none of two exists during insert. How are we doing? Please help us improve Stack Overflow. Take our short survey. Learn more. Inserting multiple choice questions and answers in sql Ask Question. Asked 4 years ago. Active 4 years ago. Viewed 1k times. Answers", column 'AnswerID'. Questions", column 'QuestionID'. C Answers: QuestionID AnswerID Choice 1 A increased use of mass transit systems 1 B growing prosperity of inner-city areas 1 C rapid development of suburbs 1 D return of city dwellers to farm areas. Tysia Krepps. Tysia Krepps Tysia Krepps 39 7 7 bronze badges. Active Oldest Votes. I understand that there should not be a cyclic reference, but I'm not sure how I can remove the reference, or create a Map table, as you say. In the Question table, there is no need to have any reference to it's answers. The answer table, however, does need to know which Question it belongs to. Continuing along, the answer table does not need to know the correct answer. The mapping table will record what the correct answer is to each question. Clark Mar 18 '16 at TysiaKrepps I have added sqlfiddle demo!! You can get the schema script from there. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog.

SQL Online Quiz

As per my experience good interviewers hardly plan to ask any particular question during your Job interview and these model questions are asked in the online technical test and interview of many Medical companies. The normal login security is sufficient for MySQL, and it does not have any extra controls of its own. Michael Widenius B. Bill Joy C. Bill Gates D. Stephanie Wall E. Some sort of client program to access the databases C. A Browser D. MySQL comes with as standard with client libraries for: A. C only B. Java only C. Java and C D. C, C and the. What kind of replication is supported by the MySQL server? Multiple-master replication B. Master to slave replication C. Single file based clustering D. Internally information is held in tables. Which of these is NOT a valid format: A. BDB B. Isam99 C. MyIsam D. Hash E. Isam F. English C. Which of these is not a valid name for a column A. Far B. Near C. Which of the following can add a row to a table? Alter B. Add C. Insert D. Create E. Update F. Which of these commands will delete a table called XXX if you have appropriate authority: A. The USE command A. Has been deprecated and should be avoided for security reasons C. MySQL runs on which operating systems?

Database (DBMS) Quiz Exam (MCQ) Question and Answers Part-1

Comments on “Sql multiple choice questions

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>