Important Questions [11]
- Differentiate between CHAR and VARCHAR data types in SQL with appropriate examples.
- Name any two DDL commands.
- The code given below deletes the record from the table employee, which contains the following record structure: E_code - String E_name - String Sal - Integer City - String Note the following
- Write the command to view all databases.
- The code given below reads the following records from the table employee and displays only those records that have employees coming from the city 'Delhi':
- ______ clause is used with a SELECT statement to display data in a sorted form with respect to a specified column.
- Write the output of the queries (i) to (iv) based on the table, WORKER given below: TABLE: WORKER W_ID F_NAME L_NAME CITY STATE 102 SAHIL KHAN KANPUR UTTAR PRADESH 104 SAMEER
- Write the outputs of the SQL queries (i) to (iv) based on the relations COMPUTER and SALES given below: Table: COMPUTER PROD_ID PROD_NAME PRICE COMPANY TYPE P001 MOUSE 200 LOGITECH INPUT P002
- The SELECT statement when combined with the ______ clause returns records without repetition.
- Name any two DML commands.
- Which function returns the sum of all elements of a list?
