A SQL query automatically eliminates duplicates (True / False) ? November 7, 2022November 7, 2022 administrator A.TRUEB.FALSEC.NoD.None of Options are Correct Share the Post Share the Post
Which of the following is a legal expression in SQL? November 7, 2022November 7, 2022 administrator A.SELECT NULL FROM SALES;B.SELECT NAME FROM SALES;C.SELECT * FROM SALES WHEN PRICE = NULL;D.SELECT # FROM SALES; Share the Post Share the Post
Which function is used to divides one numeric expression by another and get the remainder ? November 7, 2022November 7, 2022 administrator A.POWERB.MODC.ROUNDD.REMAINDER Share the Post Share the Post
What is the full form of DDL ? November 7, 2022November 7, 2022 administrator A.Dynamic Data LanguageB.Detailed Data LanguageC.Data Definition LanguageD.Data Derivation Language Share the Post Share the Post
A database language used for defining the whole databasestructureand schema is called : November 7, 2022November 7, 2022 administrator A.DCLB.DMLC.DDLD.All Options are Correct Share the Post Share the Post
Which data type can store unstructured data in a column? November 7, 2022November 7, 2022 administrator A.RAWB.CHARC.NUMERICD.VARCHAR Share the Post Share the Post
DCL provides commands to performactionslike November 7, 2022November 7, 2022 administrator A.Change thestructureof TablesB.Insert, Update or Delete Records and ValuesC.Authorizing Access and othercontrolover DatabaseD.None of Options are Correct Share the Post Share the Post
The COUNT function in SQL returns the number of __ November 7, 2022November 7, 2022 administrator A.ValuesB.Distinct valuesC.Group ByD.Columns Share the Post Share the Post
The virtual table that its created by data from the result of an SQL Select statement is called _ November 7, 2022November 7, 2022 administrator A.ViewB.SynonymC.SequenceD.Transaction Share the Post Share the Post
Which statement in SQL allows us to change the definition of a table is? November 20, 2021November 20, 2021 administrator A. ALTERB. UPDATEC. CREATED. SELECT Share the Post Share the Post