Dynamic Web Page Development (3350702) MCQs

MCQs of Establishing a Database Connection and Working With Database

Showing 31 to 33 out of 33 Questions
31.

Which function closes a previously opened database connection?

(કયા ફંકશન પહેલા ઓપન ડેટાબેસ કનેક્શનને close કરે છે?)

(a)

mysql_end

(b)

mysql_drop()

(c)

 mysql_close() 

(d)

mysql close()

Answer:

Option (c)

32.

In the following SQL code, InnoDB is __________.

CREATE TABLE student (

  name CHAR(30),

  student_id INT,

  PRIMARY KEY (student_id)

 ) ENGINE = InnoDB;

 

નીચે આપેલા SQL કોડમાં, InnoDB __________ છે.

CREATE TABLE student (

  name CHAR(30),

  student_id INT,

  PRIMARY KEY (student_id)

 ) ENGINE = InnoDB;

 

(a)

database name

(b)

table name

(c)

reference engine

(d)

storage engine

Answer:

Option (d)

33.

What is ‘xyz’ in the following SQL statement? SELECT abc FROM xyz;

(નીચે આપેલા SQL સ્ટેટમેંટમાં ‘xyz’ શું છે? SELECT abc FROM xyz;)

(a)

row name

(b)

column name

(c)

table name

(d)

database name

Answer:

Option (c)

Showing 31 to 33 out of 33 Questions