The maximum value that can be specified to the size of VARCHAR is _____________

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

A

i, iii, iv

B

ii, iii, iv

C

i, ii, iv

D

iii, iv

Find out the logical error in the following MySQL code snippet?

CREATE TABLE person( person_id VARCHAR(20), Name VARCHAR (20), Address VARCHAR (20), Mobile_no SMALLINT );

A

Lesser number of columns

B

Incorrect definition

C

Primary key is missing

D

None of the mentioned

The maximum value that can be specified to the size of VARCHAR is . . . . . . . .

A

0

B

127

C

1023

D

65535

create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0), primary key (ownerID)); Choose the correct option regarding the above statement

A

The statement is syntactically wrong

B

It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.

C

It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.

D

It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.

In the following SQL query, what does "person_id" stands for?

CREATE TABLE person(person_ id SMALLINT UNSIGNED,fname VARCHAR(20),lname VARCHAR(20),CONSTRAINT pk_person PRIMARY KEY (person_id));

A

Normal attribute of the table

B

Super key

C

Composite key

D

Primary key

Find the error in the following SQL statement?

CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, LAST) VALUES(1,’s’,’p’);

A

No error

B

Error, Duplicate value

C

Any other error

D

None of the mentioned

Find the error in the following SQL statement?

CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATECONSTRAINTS pk_person PRIMARY KEY (person_id));INSERT INTO personVALUES( person_id, name, LAST, Birth_date)(1,’s’,’p’, 24-1991-01);

A

In correct data value

B

No error

C

Any other error

D

None of the mentioned

Which of the following statements are true with regards to the selection of a sample size? (i) The sample size (n) may be a fixed percentage of lot size (N). (ii) The sample size (n) may be kept constant irrespective of lot size (N). (iii) Sample size (n) can be selected at the personal whim of the inspector.

A

i only

B

i, ii only

C

i, ii, iii

D

i, iii only

Consider the following C function in which size is the number of elements in the array E: int MyX(int *E, unsigned int size) { int Y = 0; int Z; int i, j, k; for(i = 0; i < size; i++) Y = Y + E[i]; for(i = 0; i < size; i++) for(j = i; j < size; j++) { Z = 0; for(k = i; k <= j; k++) Z = Z + E[k]; if (Z > Y) Y = Z; } return Y; } The value returned by the function MyX is the

A

maximum possible sum of elements in any sub-array of array E

B

maximum element in any sub-array of array E.

C

sum of the maximum elements in all possible sub-arrays of array E.

D

The sum of all the elements in the array E.

Consider the following statements regarding limits and fits 1. Actual size is the standard size for the part and is the same both for the hole and its shaft. 2: Basic size is the dimension as measured on the manufactured part. 3. Deviation is the algebraic difference between a size and the corresponding basic size. Which of the above statements is/are correct ?

A

3 only

B

1 and 3 only

C

2 only

D

1, 2 and 3

The maximum value that can be specified to the size of VARCHAR is _____________

Related Questions