officerpath@gmail.com Hyderabad, Pakistan
Login Register
Latest Jobs CSS 2025 PMS CCE Sindh FPSC PPSC MCQs Past Papers Current Affairs Scholarships Admissions Downloads Roll No. Slips Results
Computer

Databases Handling MCQs

Practice Databases Handling MCQs for competitive exams.

Databases Handling MCQs

Practice questions from this topic.

Can joins be nested?

  1. A. True
  2. B. False
Report Error

Use the .............. to delete the data inside the table, and not the table itself?

  1. A. DROP TABLE
  2. B. DELETE TABLE
  3. C. TRUNCATE TABLE
  4. D. REMOVE TABLE
Report Error

The ............. statement is used to delete a table.

  1. A. DROP TABLE
  2. B. DELETE TABLE
  3. C. DEL TABLE
  4. D. REMOVE TABLE
Report Error

What does the DESC keyword do in the following query? SELECT * FROM MY_TABLE WHERE ID > 0 ORDER BY ID, NAME DESC"

  1. A. It causes the dataset returned by the query to be sorted in descending order
  2. B. It causes rows with the same ID to be sorted by NAME in ascending order
  3. C. It causes rows with the same ID to be sorted by NAME in descending order
  4. D. It causes rows to be sorted by NAME first and then by ID E. It causes the result set to include a description of the NAME field
Report Error

SQL is not case sensitive. SELECT is the same as select.

  1. A. True
  2. B. False
Report Error

Transactions are used to treat sets of SQL statements atomically.

  1. A. True
  2. B. False
Report Error

In PHP in order to access MySQL database you will use:

  1. A. mysqlconnect() function
  2. B. mysql-connect() function
  3. C. mysql_connect() function
  4. D. sql_connect() function
Report Error

When a user confirms that he wishes to delete an entry, that entry’s URL is passed to a function which removes the entry from the __________

  1. A. index.php
  2. B. function.inc.php
  3. C. database
  4. D. admin.php
Report Error

Your confirmation form submits your choice, via the _______ method, to ________

  1. A. GET index.php
  2. B. GET admin.php
  3. C. POST index.php
  4. D. POST admin.php
Report Error

To identify entries marked for deletion, you check whether $_GET[‘page’] == ‘delete’ inside __________

  1. A. index.php
  2. B. index.ini
  3. C. admin.php
  4. D. .htaccess
Report Error

You need to check whether ______ is set, to determine whether you’re editing an entry or creating a new one.

  1. A. $_GET[‘url’].
  2. B. $_SET[‘url’].
  3. C. $_GET[‘admin’].
  4. D. $_SET[‘admin’].
Report Error

([w-]+) will match ___________

  1. A. one word characters
  2. B. one or more word characters
  3. C. one or more word characters and/or hypens
  4. D. one or more word characters and hypens
Report Error