BLOB in SQL stands for ? , Big Logic Object, Binary Large Object, Binary Logic Object, None of these, How many Primary Keys can be created on a table?, Infinity, 2, 1, 24, Which of the following is not a part of CRUD operations in SQL?, Creating a table, Deleting records from the table, Creating a copy of a table, Updating the data stored in the table, ?SQL dqtqbqse follows which of the following principles ?, ACID, AGILE, SQL, DBMS, Whiche of the following is not a Clause in SQL?, Below, Limit, Where, Group By, Which of the following query depicts the correct Select statement?, Select # From DataFlair;, Select * From DataFlair;, Select From DataFlair;, Select col1, col2 From;, Which of the following clause allows us to extract data in a range?, Between, Range, Find In, Like, What is the full form of SQL?, Structured Query Language , Structured QuestionLanguage, Structural Query Language, Structuring Query Language, Which of the following is not true about views?, Can be created only from one table, Grouping using functions is present, No DML queries can be executed on the views, All of the above statements are true, Which keyword allows us to find the unique values in the database?, DISTINCT, UNIQUE, FIND, DIFF, Which of the following is true about a view , The view gets deleted automaticlly after the session is completed, Views can't be updated once created, Views are created by grouping a single desired attributes of a database, None of these, Which of the following shows comment in SQL, /*This is a comment*/, #This is a comment#, %This is a comment%, & This is a comment, Which of the following is true about a cursor in SQL?, It is read-only, The cursor can perform all the CRUD operations, Cursors are objects of the query, Cursors are created automatically, Which of the following is not an aggregate function in SQL, SUM, AVG, COUNT, FIND, Which of the following operator is used to extract pattern matching gata from the database?, LIKE, SELECT, FIND, UPDATE, Which of the following query would limit the output to rows?, SELECT * FROM DataFlair 5;, Select * FROM DataFlair 5 Limit;, Select * FROM DataFlair 5 LIMIT;, SELECT LIMIT(5) * FROM DataFlair, which of the following is true about NULL values in SQL?, A NULL value means zero, a null value only be used with numeric attributes, NULL value just means that data of that attribute is not available , None of these, what all languages support the integration of SQL with them ?, java, c++, Python, all of these, which of the queries below can be used to alter the Emp table such that we can add a new gender column to our table ? , Alter table emp ADD gender int ;, ALTER TABLE emp gender varchar(20);, ALTER emp ADD gender varchar;, ALTER TABLE emp ADD gender varchar2(10);, write a query to draw out details of all the employees whose name starts with "A" or are based in Pune , select * emp where name location ='Pune';, select * from emp where name like '%A__'or location ='Pune';, select * from emp where name like'a%' or location =''Pune;, None of the above, what is the major difference in the operation of the UNION and UNION ALL clause in SQL ? , union returns unique data and union all returns all possible cases , union all returns unique data while union returns all the possible cases , Both return the same set of data , None of the above, when the SQL query is executed the result is ? , a blank screen, a table, a row , all of these, which of the below queries can be used to rename the table emp to emp_info, alter table emp ;, alter table emp set to emp_info ;, alter table emp rename to emp_info;, alter table emp update to emp_info ;, what are the data definition commands , DML, UML, RDBMS, DDL.

SQL_QUIZ

vytvoril(a)
Tlač
Vložiť

Rebríček

Vizuálny štýl

Možnosti

Prepnúť šablónu

)
Obnoviť automaticky uložené: ?