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