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

  1. Home
  2. Back

SQL - Online Exam Test Papers | SQL - MCQs[multiple choice questions and answers ] | SQL - Mock Test Papers | SQL - Practice Papers | SQL - Sample Test Papers |

Question:
Which clause is used to Modify the existing field of the table?

1.ALTER

2.FROM

3.SELECT

4.MODIFY

Posted Date:-2021-07-18 05:04:44

More MCQS Questions and answers

  1. "MODIFY" is used with which "Query clause"?
  2. Among the following, for which language is image processing least simple?
  3. For a heavily used program, which of these languages should be preferred?
  4. For which language is the engine specific interface PDO defined?
  5. For which language is the PEAR module used?
  6. mysql_init() returns a _____
  7. Select the sequence for how the query mechanism works?
  8. The "protocol value TCP' runs on which operating systems?
  9. The CGI.pm module for website development is a part of _____
  10. The DBI API for Perl is _____
  11. The JDBI interface is available for ____
  12. The MySQL clients are linked with ____
  13. The primary programming interface to MySQL is _______
  14. The protocol CGI is ____
  15. The SOCKET protocol is permitted on which operating systems?
  16. The static C library client in Windows is ____
  17. The users responsible for query processing in database system are ____
  18. What can be used as an alternative to mysqlconfig?
  19. What exports table definitions and contents?
  20. What loads data files into tables?
  21. What performs administrative operations?
  22. Which among the following is not a "query clause"?
  23. Which API provides the lowest level interface to the server?
  24. Which clause is used to determine which column to include in the query sets?
  25. Which clause is used to filter out unwanted Groups?
  26. Which clause is used to Filters out unwanted data?
  27. Which clause is used to group rows together by common columns values?
  28. Which clause is used to Identifies table from which to draw table and how the table should be joined?
  29. Which clause is used to Modify the existing field of the table?
  30. Which clause is used to sort the rows of the final result set by one or more columns?
  31. Which file can be used to execute multiple compile statements?
  32. Which flag is used to compile client programs that use MySQL header files?
  33. Which header should be included first?
  34. Which is the correct decreasing order for highly developed text manipulation capabilities?
  35. Which language is the core for APIs and communication in MySQL?
  36. Which library file contains various portability macros and definitions?
  37. Which of the following can be used interchangeably with MYSQL_VERSION_ID?
  38. Which of the following is used on Solaris?
  39. Which of the following returns a MySQL-specific numeric code?
  40. Which of the following returns an SQLSTATE code?
  41. Which of these can be used in place of MYSQL_SERVER_VERSION?
  42. Which of these has a smaller memory footprint?
  43. Which of these is not used to connect to the MySQL server?
  44. Which of these is the most general purpose language?
  45. Which of these is used during MySQL setup?
  46. Which of these returns a string containing an error message?
  47. Which option executes all SQL statements in a SQL script irrespective of the number of errors?
  48. Which option is necessary to compile a C program havin math functions?
  49. Which option is supplied to ensure TCP/IP connection to local server?
  50. Which program emulates the client load for a MySQL server?

Question :- "MODIFY" is used with which "Query clause"?

1.ALTER

2.FROM

3.WHERE

4.ORDER BY

Answer 1

Question :- Among the following, for which language is image processing least simple?

1.PHP

2.Perl

3.Python

4.C

Answer 4

Question :- For a heavily used program, which of these languages should be preferred?

1.C

2.Perl

3.PHP

4.Python

Answer 1

Question :- For which language is the engine specific interface PDO defined?

1.Python

2.Perl

3.PHP

4.C

Answer 3

Question :- For which language is the PEAR module used?

1.Python

2.Perl

3.PHP

4.C

Answer 3

Question :- mysql_init() returns a _____

1.integer

2.float

3.structure

4.pointer to a structure

Answer 4

Question :- Select the sequence for how the query mechanism works?

1.Authentication-> DDL->DML->query optimizer->output

2.DDL->DML->query optimizer-> Authentication->output

3.DML->query optimizer-> Authentication-> DDL-> output

4.All of the mentioned

Answer 1

Question :- The "protocol value TCP' runs on which operating systems?

1.all

2.unix only

3.windows only

4.none

Answer 1

Question :- The CGI.pm module for website development is a part of _____

1.Perl

2.Java

3.Python

4.C++

Answer 1

Question :- The DBI API for Perl is _____

1.database interface

2.database id

3.database identity

4.database integrity

Answer 1

Question :- The JDBI interface is available for ____

1.C

2.C++

3.Python

4.Java

Answer 4

Question :- The MySQL clients are linked with ____

1.#NAME?

2.-cmysqlclient

3.-dmysqlclient

4.-vmysqlclient

Answer 1

Question :- The primary programming interface to MySQL is _______

1.C API

2.C++ API

3.Java API

4.Python API

Answer 1

Question :- The protocol CGI is ____

1.computer graphics interface

2.common graphics interface

3.computer gateway interface

4.common gateway interface

Answer 4

Question :- The SOCKET protocol is permitted on which operating systems?

1.all

2.unix only

3.windows only

4.none

Answer 2

Question :- The static C library client in Windows is ____

1.mysqlclient.lib

2.mysqlclient.lb

3.mysqlclient.lm

4.myclient.lib

Answer 1

Question :- The users responsible for query processing in database system are ____

1.Native users

2.Application programmers

3.Sophisticated users

4.Specialized users

Answer 3

Question :- What can be used as an alternative to mysqlconfig?

1.pkg-config

2.dkg-config

3.rkg-config

4.qkg-config

Answer 1

Question :- What exports table definitions and contents?

1.mysqldump

2.mysqladmin

3.mysqlimport

4.mysqlexport

Answer 1

Question :- What loads data files into tables?

1.mysqldump

2.mysqladmin

3.mysqlimport

4.mysqlexport

Answer 3

Question :- What performs administrative operations?

1.mysqldump

2.mysqladmin

3.mysqlimport

4.mysqlexport

Answer 2

Question :- Which among the following is not a "query clause"?

1.WHERE

2.MODIFY

3.ALTER

4.FROM

Answer 1

Question :- Which API provides the lowest level interface to the server?

1.C API

2.Perl

3.PHP

4.Python

Answer 1

Question :- Which clause is used to determine which column to include in the query sets?

1.SELECT

2.FROM

3.WHERE

4.ORDER BY

Answer 1

Question :- Which clause is used to filter out unwanted Groups?

1.HAVING

2.FROM

3.WHERE

4.SELECT

Answer 1

Question :- Which clause is used to Filters out unwanted data?

1.FROM

2.WHERE

3.SELECT

4.ORDER BY

Answer 2

Question :- Which clause is used to group rows together by common columns values?

1.SELECT

2.GROUP BY

3.FROM

4.WHERE

Answer 2

Question :- Which clause is used to Identifies table from which to draw table and how the table should be joined?

1.FROM

2.SELECT

3.ORDER By

4.WHERE

Answer 1

Question :- Which clause is used to Modify the existing field of the table?

1.ALTER

2.FROM

3.SELECT

4.MODIFY

Answer 1

Question :- Which clause is used to sort the rows of the final result set by one or more columns?

1.HAVING

2.ORDER BY

3.WHERE

4.FROM

Answer 2

Question :- Which file can be used to execute multiple compile statements?

1.makefile

2.dofile

3.putfile

4.pushfile

Answer 1

Question :- Which flag is used to compile client programs that use MySQL header files?

1.-O

2.-I

3.-U

4.-A

Answer 2

Question :- Which header should be included first?

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Answer 1

Question :- Which is the correct decreasing order for highly developed text manipulation capabilities?

1.Perl, PHP, C

2.Perl, C, PHP

3.PHP, Perl, C

4.C, PHP, Perl

Answer 1

Question :- Which language is the core for APIs and communication in MySQL?

1.C

2.C++

3.Python

4.Ruby

Answer 1

Question :- Which library file contains various portability macros and definitions?

1.my_global.h

2.my_sys.h

3.mysql.h

4.my_local.h

Answer 2

Question :- Which of the following can be used interchangeably with MYSQL_VERSION_ID?

1.LIBMYSQL_VERSION

2.LIBMYSQL_VERSION_ID

3.MYSQL_VERSION_ID

4.MYSQL_ID

Answer 2

Question :- Which of the following is used on Solaris?

1.gcc

2.clang

3.Sun Studio

4.FreeBSD

Answer 3

Question :- Which of the following returns a MySQL-specific numeric code?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()

Answer 2

Question :- Which of the following returns an SQLSTATE code?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()

Answer 3

Question :- Which of these can be used in place of MYSQL_SERVER_VERSION?

1.LIBMYSQL_VERSION

2.LIBMYSQL_VERSION_ID

3.MYSQL_VERSION_ID

4.MYSQL_ID

Answer 1

Question :- Which of these has a smaller memory footprint?

1.Perl

2.PHP

3.Same

4.Machine dependent

Answer 2

Question :- Which of these is not used to connect to the MySQL server?

1.mysql

2.mysqladmin

3.mysqlcheck

4.mysql_upgrade

Answer 4

Question :- Which of these is the most general purpose language?

1.C

2.Perl

3.Python

4.PHP

Answer 1

Question :- Which of these is used during MySQL setup?

1.mysqld_multi

2.mysql.server

3.mysqld_safe

4.comp_err

Answer 4

Question :- Which of these returns a string containing an error message?

1.mysql_error()

2.mysql_errno()

3.mysql_sqlstate()

4.mysql_close()

Answer 1

Question :- Which option executes all SQL statements in a SQL script irrespective of the number of errors?

1.ensure

2.violent

3.force

4.run

Answer 3

Question :- Which option is necessary to compile a C program havin math functions?

1.-lm

2.-ln

3. -lp

4.-lq

Answer 1

Question :- Which option is supplied to ensure TCP/IP connection to local server?

1.localhost

2.host

3.hostlocal

4.connectlocal

Answer 2

Question :- Which program emulates the client load for a MySQL server?

1.mysqlslap

2.mysqldump

3.mysqladmin

4.mysqlimport

Answer 1
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!