mysql_pconnect() is used to make a persistent connection to the database which means a SQL link that do not close when the execution of your script ends.

True

False

None of the above

Similar Questions

Which SQL function is used to count the number of rows in a SQL query?

COUNT()

NUMBER()

SUM()

COUNT(*)

Which of the following is not a valid aggregate function ?

COUNT

COMPUTE

SUM

MAX

The SQL statement:

SELECT ROUND (65.726, -1) FROM DUAL;

is illegal

garbage

726

Evaluate the SQL statement:

SELECT ROUND (TRUNCATE (MOD (1600, 10), -1), 2) FROM dual;

An error statement

What is the need for our query to execute successfully on an existing view?

The specified table must contain data.

We must have a SELECT privilege on the view.

We should have a SELECT privilege only on the specified table.

The specified table must be in the same database or schema.

Which function returns an array of row values?

fetchrow_array()

fetchrow_arrayref()

fetch()

fetchrow_hashref()

Which function returns a reference to hash of row values?

fetchrow_array()

fetchrow_arrayref()

fetch()

fetchrow_hashref()

‘fetchrow_hashref()’ returns a reference to the hash of row values keyed by what?

row name

column name

table name

database name

The maximum non zero value for FLOAT is ______________

3.402823466E+38

3.402823466E+37

3.402823466E+39

3.402823466E+35

10.

The COUNT function in SQL returns the number of ______________

Values

Distinct values

Group By

Columns

STRUCTURED QUERY LANGUAGE TOPICS