Bissoy.com
Doctors Medicines MCQs Q&A

In SQL, if a value is entered in CHAR datatype which does not occupy all the length spaces then the remaining spaces will be occupied with blank spaces.

In SQL, if a value is entered in CHAR datatype which does not occupy all the length spaces then the remaining spaces will be occupied with blank spaces. Correct Answer True

If a value is entered in the CHAR datatype which does not takes up the whole space then instead of changing the space of the datatype or removing the left space, they are filled by blank spaces.

Related Questions

Which among the following is correct syntax to declare a 2D array using new operator? = new char; b) char (pchar) = new char; c) char (*char) = new char; d) char (*char)= new char;
Select the correct differences between char and varchar data types? i. varchar is non unicode and char is unicode character data type ii. char is ‘n’ bytes whereas varchar is actual length in bytes of data entered in terms of storage size iii. varchar is variable in length and char is the fixed length string iv. For varchar, if a string is less than the maximum length then it is stored in verbatim without any extra characters while for char if a string is less than the set length it is padded with extra characters to equalize its length to given length
An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.
Which of the following syntax is correct way to declare a variable in PL/SQL? ; b) variable_name datatype ; c) variable_name datatype; d) variable_name datatype (NOT NULL := value );
What does 'name' represent in the following SQL code snippet?
CREATE TABLE student( name CHAR(30), roll_num INT, address CHAR(30), phone CHAR(12));
What is the total number of employees in the company? Which of the following option is sufficient alone to find the answer? A) In the company, employees like either tea or coffee or cold drink. Out of the total employees, 25% like tea and 40% like coffee. Out of remaining employees, 20% like cold drink and remaining employees don’t like any of these drinks. B) Out of total employees 18% working in the marketing departments, 35% working in IT departments. From the remaining employees 25% working in HR departments and 45% working in content departments and remaining 141 are working in other departments. C) Employees working in the company is form state X, Y and Z. 20% of employees working in the company is from state X and from remaining 60% employees is from state Z and the remaining employees is from the state Y. D) 60% of the employees in the company are married and remaining employees are unmarried. The ratio of male and female unmarried employees is 4 : 5 and ratio of married male and female employees is 3 : 4.
In the following question, two statements are numbered as A and B. On solving these statements we get quantities A and B respectively. Solve for the both quantities and choose the correct option. Quantity A: A fruit seller sold 40% of his apples at a price of Rs. 80 per kg. Then he sold 30% of the remaining apples at a price of Rs. 100 per kg. Later, he sold 75% of the remaining apples for Rs. 120 per kg, and further remaining apples at Rs. 60 per kg. If he earned a total of Rs. 11762.50 from selling all his apples, how many apples did he have? Quantity B: 20% of the fruits in a shop are apples, while 40% of the remaining fruits are bananas. Also, 50% of the remaining fruits are mangoes. If the remaining fruits are 16 kg of pineapples and 20 kg of grapes, how many kg fruits are there in the shop?
What will be the value of ‘i’ after the execution of the given C code fragment? static char str1[] = ”dills”; static char str2[20]; static char str3[] = ”daffo”; int i; I = strcmp(strcat(str3,strcpy(str2,str1)),”daffodills”);
Name the first Europeans which came in power in Pondicherry (now Puducherry)? A). The first European power to occupy Pondicherry were the Portuguese. B). The second European power to occupy Pondicherry were the French. C). The English never occupied Pondicherry.
With reference to Pondicherry (now Puducherry), consider the following statements :      1. The first European power to occupy Pondicherry were the Portuguese. 2. The second European power to occupy Pondicherry was the French. 3. The English never occupied Pondicherry. Which of the statements given above is/are correct?