CS403 - Database Management Systems
Question(s) similar to the following:
Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order ByCUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS WhereREGION = 'E' Order By CUSTOMERThe above statement
Question 1: Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order ByCUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS WhereREGION = 'E' Order By CUSTOMERThe above statement
Has an error - the string should be in double quotes
Has an error - ORDER BY clause.
Does not have an error.
Has an error - the string in single quotes 'NORTH' and 'SOUTH'.
Similar Questions:
Question 2: Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order ByCUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS WhereREGION = 'E' Order By CUSTOMERThe above statement
Has an error - the string should be in double quotes
Has an error - ORDER BY clause.
Does not have an error.
Has an error - the string in single quotes 'NORTH' and 'SOUTH'.
Quizzes of CS403 - Database Management Systems
Question 1: Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order ByCUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS WhereREGION = 'E' Order By CUSTOMERThe above statement
Has an error - the string should be in double quotes
Has an error - ORDER BY clause.
Does not have an error.
Has an error - the string in single quotes 'NORTH' and 'SOUTH'.
Similar Questions:
Question 2: Select 'NORTH', CUSTOMER From CUST_DTLS Where REGION = 'N' Order ByCUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS WhereREGION = 'E' Order By CUSTOMERThe above statement
Has an error - the string should be in double quotes
Has an error - ORDER BY clause.
Does not have an error.
Has an error - the string in single quotes 'NORTH' and 'SOUTH'.
Sponsored
Attach VULMS for better learning experience!
Our VULMS adds features of MDBs and lets your populate VU subjects automatically.
Tajweed Classes (Learn Quran with Tajweed)
Try our 3 days free demo now! Online online holy quran tajweed classes are useful to learn reading holy quran with tajweed.
Gegasoft POS/CRM Software
Gegasoft Point of Sale/Customer Relationship Management software is an accounting software to fulfill your business needs.
Sponsored
?