Top 50+ Solved DataBases MCQ Questions Answer
Q. Which one of the following databases has PHP supported almost since thebeginning?
a. Oracle Database
b. SQL
c. SQL+
d. MySQL
Q. Which one of the following statements is used to create a table?
a. CREATE TABLE table_name (column_namecolumn_type);
b. CREATE table_name (column_typecolumn_name);
c. . CREATE table_name (column_namecolumn_type);
d. . CREATE TABLE table_name (column_typecolumn_name);
Q. Which method returns the error code generated from the execution of the lastMySQL function?
a. errno()
b. . errnumber()
c. . errorno()
d. errornumber()
Q. If there is no error, then what will the error() method return?
a. . TRUE
b. . FALSE
c. . Empty String
d. . non of these
Q. Which one of the following statements should be used to include a file?
a. . #include ‘filename’;
b. include ‘filename’;
c. include <filename>
d. none of these
Q. Which one of the following methods recuperates any memory consumed by aresult set?
a. destroy()
b. remover()
c. alloc()
d. free()
Q. Which one of the following methods can be used to diagnose and displayinformation about a MySQL connection error?
a. . connect_errno()
b. connect_error()
c. mysqli_connect_errno()
d. . mysqli_connect_error()
Q. Which method retrieves each row from the prepared statement result and assignsthe fields to the bound results?
a. get_row()
b. . fetch_row()
c. . fetch()
d. row()
Q. Which one of the Following methods is responsible for sending the query toDatabase
a. query()
b. send_query( )
c. sendquery()
d. query_send()
Q. ________ is used to uniquely identify the rows in table.
a. primary key
b. Database
c. not null
d. none of these
Q. _____ returns the last error description for the most recent function call
a. Error no
b. Zero no
c. no error
d. none of these
Q. RDBMS stands for __________.
a. Relation data base management
b. reletives data base management
c. Random data base management
d. none of these