What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);

ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

The DROP TABLE statement:

works whether or not referential integrity constraints would be violated.

deletes the table structure only.

deletes the table structure along with the table data.

works whether or not referential integrity constraints would be violated.

Data dictionary is a special file that contains

the names of all fields in all files

the data types of all fields of all files

the names of all fields in all files

In the following query “person_id” can be SELECT person_id, fname,l name, Birth_data FROM person WHERE person_id=1;

Only Attribute but not a primary Key

Primary Key or any other Attribute

Only Attribute but not a primary Key

The master list of an indexed file

contains only a list of keys and record numbers

has a number assigned to each record

427 + Mcqs in MySQL in Technical Programming Page 9 McqOptions

401.	What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
A.	ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0);
B.	ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
C.	ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);
D.	None of the above is correct.
Answer» D. None of the above is correct.

Discussion

402.	What is the meaning of “NULL” in Mysql?
A.	Not applicable
B.	Value not yet known
C.	Value undefined
D.	All of the mentioned
Answer» E.

Discussion

403.	The data model that is produced from reverse engineering is:
A.	a conceptual model.
B.	an internal model.
C.	a logical model
D.	None of the above
Answer» E.

Discussion

404.	Instead of specifying a set of tuples, we can also use the
A.	Select
B.	Group By
C.	Having
D.	Like
Answer» B. Group By

Discussion

405.	Database redesign is not terribly difficult if the:
A.	database is structured.
B.	database is well-designed.
C.	database has no data.
D.	database is relatively small.
Answer» D. database is relatively small.

Discussion

406.	Find the error in the following query? SELECT cust_id, fed_id FROM customer WHERE cust_id = ’I’ AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;
A.	Yes
B.	No
C.	Range too high to compare
D.	None of the mentioned
Answer» C. Range too high to compare

Discussion

407.	The DROP TABLE statement:
A.	deletes the table structure only.
B.	deletes the table structure along with the table data.
C.	works whether or not referential integrity constraints would be violated.
D.	is not an SQL statement.
Answer» C. works whether or not referential integrity constraints would be violated.

Discussion

408.	Which clause is used to “Modify the existing field of the table”?
A.	ALTER
B.	FROM
C.	SELECT
D.	MODIFY
Answer» B. FROM

Discussion

409.	Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
A.	MUST COVER
B.	MUST NOT
C.	Both of the above.
D.	None of the above
Answer» B. MUST NOT

Discussion

410.	The virtual table that its created by data from the result of an SQL 'Select' statement is called _________
A.	VIEW
B.	SYNONYM
C.	SEQUENCE
D.	TRANSACTION
Answer» B. SYNONYM

Discussion

411.	Which operator is used to compare a value to a specified list of values?
A.	BETWEEN
B.	ANY
C.	IN
D.	ALL
Answer» D. ALL

Discussion

412.	The SQL keywords(s) _____ is used with wildcards.
A.	LIKE only
B.	NOTIN only
C.	IN only
D.	IN and NOT IN
Answer» B. NOTIN only

Discussion

413.	The primary key is selected from the
A.	Composite keys
B.	Candidate keys
C.	Foreign keys
D.	Determinants
Answer» C. Foreign keys

Discussion

414.	Which of the following is not a valid SQL type?
A.	DECIMAL
B.	NUMERIC
C.	FLOAT
D.	CHARACTER
Answer» B. NUMERIC

Discussion

415.	Which type of join returns all rows that satisfy the join condition?
A.	Inner Join
B.	Outer Join
C.	Semi Join
D.	Anti Join
Answer» C. Semi Join

Discussion

416.	Natural join can be related with
A.	Function dependency
B.	B tree
C.	Domain calculus
D.	Relational algebric operators
Answer» E.

Discussion

417.	Data dictionary is a special file that contains
A.	the data types of all fields of all files
B.	the names of all fields in all files
C.	Both of above
D.	None of above
Answer» B. the names of all fields in all files

Discussion

418.	Modify operation is likely to be done after
A.	Delete
B.	Lookup
C.	Indexing
D.	Insertion
Answer» C. Indexing

Discussion

419.	Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
A.	Null status
B.	Data type
C.	Default value
D.	Data constraints
Answer» C. Default value

Discussion

420.	The logical structure with one to many relationships is a
A.	network
B.	tree
C.	chain
D.	relational
Answer» C. chain

Discussion

421.	In the following query “person_id” can be SELECT person_id, fname,l name, Birth_data FROM person WHERE person_id=1;
A.	Only Primary Key
B.	Primary Key or any other Attribute
C.	Only Attribute but not a primary Key
D.	None of the mentioned
Answer» C. Only Attribute but not a primary Key

Discussion

422.	The master list of an indexed file
A.	is sorted in ascending order
B.	contains only a list of keys and record numbers
C.	has a number assigned to each record
D.	none of above
Answer» D. none of above

Discussion

423.	Which Clause is used to select a particular row from the set of row in an existing table?
A.	WHERE
B.	FROM
C.	ALTER
D.	None of the mentioned
Answer» B. FROM

Discussion

424.	If a relation scheme is in BSNF then it is also in
A.	First normal form
B.	Second normal form
C.	Third normal form
D.	Not in any normal form
Answer» D. Not in any normal form

Discussion

425.	In the following 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
Answer» C. Composite key

Discussion

426.	Is “Datetime” and “Timestamp” are same data type?
A.	Yes
B.	No
C.	Depends
D.	None of the mentioned
Answer» B. No

Discussion

427.	Which data type is more suitable for storing “documents” in Mysql?
A.	Varchar
B.	Longtext
C.	Mediumtext
D.	Either Varchar or Longtext
Answer» C. Mediumtext

Discussion

Explore topic-wise MCQs in Technical Programming.

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

What is the meaning of “NULL” in Mysql?

The data model that is produced from reverse engineering is:

Instead of specifying a set of tuples, we can also use the

Database redesign is not terribly difficult if the:

Find the error in the following query? SELECT cust_id, fed_id FROM customer WHERE cust_id = ’I’ AND fed_id BETWEEN 5000-00-000 AND 9999-999-000;

The DROP TABLE statement:

Which clause is used to “Modify the existing field of the table”?

Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?

The virtual table that its created by data from the result of an SQL 'Select' statement is called _________

Which operator is used to compare a value to a specified list of values?

The SQL keywords(s) _____ is used with wildcards.

The primary key is selected from the

Which of the following is not a valid SQL type?

Which type of join returns all rows that satisfy the join condition?

Natural join can be related with

Data dictionary is a special file that contains

Modify operation is likely to be done after

Which of the following column properties would be used to specify that cells in a column must contain a monetary value?

The logical structure with one to many relationships is a

In the following query “person_id” can be SELECT person_id, fname,l name, Birth_data FROM person WHERE person_id=1;

The master list of an indexed file

Which Clause is used to select a particular row from the set of row in an existing table?

If a relation scheme is in BSNF then it is also in

In the following 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));

Is “Datetime” and “Timestamp” are same data type?

Which data type is more suitable for storing “documents” in Mysql?