SQL/SQL%20MCQ%20SET%204 Sample Test,Sample questions

Question:
A stored program associated with a schedule is _____________

1.Trigger

2.Event

3.Stored function

4.Stored procedure

Posted Date:-2021-07-19 04:12:24


Question:
By default, the AUTO_INCREMENT sequences begin at __________

1.0

2.1

3.-1

4.2

Posted Date:-2021-07-19 04:12:24


Question:
CGI stands for ________

1.Computer Gateway Interface

2.Common Gateway Interface

3.Computer Generated Interface

4.Common Generated Interface

Posted Date:-2021-07-19 04:12:24


Question:
DBI scripts are located in the directory ______________

1.cgi-inc

2.cgi-bin

3.cgi-usr

4.cgi-perl

Posted Date:-2021-07-19 04:12:24


Question:
fetchrow_hashref() returns reference to hash of row values keyed by _____

1.row name

2.column name

3.table name

4.database name

Posted Date:-2021-07-19 04:12:24


Question:
Illegal values converted to the appropriate ‘zero’ value for ________

1.Numeric

2.String

3.ENUM

4.TIME

Posted Date:-2021-07-19 04:12:24


Question:
In PHP, if $a represents an array with numeric indices, how is the first element accessed?

1.$a[1]

2.$a[0]

3.$a.1

4.$a.0

Posted Date:-2021-07-19 04:12:24


Question:
In PHP, which operator is used to access property of an object?

1..

2.*

3.->

4.@

Posted Date:-2021-07-19 04:12:24


Question:
MySQL uses security based on ACL which stands for ______

1.Access Control Language

2.Access Control Lists

3.Automatic Control Lists

4.Automatic Control Language

Posted Date:-2021-07-19 04:12:24


Question:
PHP variables are preceded by __________

1._

2.@

3.$

4.&

Posted Date:-2021-07-19 04:12:24


Question:
RTF refers to ________

1.Rich Text Format

2.Right Text Format

3.Rich Text Function

4.Right Text Function

Posted Date:-2021-07-19 04:12:24


Question:
The AUTO_INCREMENT column attribute is best used with ______________

1.FLOAT

2.INT

3.CHARACTER

4.DOUBLE

Posted Date:-2021-07-19 04:12:24


Question:
The column attribute provides unique numbers for identification is _______

1.AUTO_INCREMENT

2.UNSIGNED

3.IDENTIFY

4.DESCRIBE

Posted Date:-2021-07-19 04:12:24


Question:
The datatype best suited to store currency values is __________

1.INT

2.FLOAT

3.DOUBLE

4.DECIMAL

Posted Date:-2021-07-19 04:12:24


Question:
The datatype best suited to store currency values is ______________

1.INT

2.FLOAT

3.DOUBLE

4.DECIMAL

Posted Date:-2021-07-19 04:12:24


Question:
The function returning an array of row values is ______________

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-19 04:12:24


Question:
The function returning reference to array of row values is ______

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-19 04:12:24


Question:
The function returning reference to hash of row values is ______________

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()

Posted Date:-2021-07-19 04:12:24


Question:
The function used to convert a string to an int is ____

1.INET_ATON()

2.INET_NTOA()

3.INET_ITOS()

4.INET_STOI()

Posted Date:-2021-07-19 04:12:24


Question:
The function used to convert an int to string is ________

1.INET_ATON()

2.INET_ATON()

3.INET_ITOS()

4.INET_STOI()

Posted Date:-2021-07-19 04:12:24


Question:
The hub of a MySQL installation is _______

1.mysqla

2.mysqlb

3.mysqlc

4.mysqld

Posted Date:-2021-07-19 04:12:24


Question:
The indicator of presence/absence of a word in search is used in the mode _____

1.Natural language

2.Boolean mode

3.Boolean mode

4.Cross mode

Posted Date:-2021-07-19 04:12:24


Question:
The line used to turn on the event scheduler is ______________

1.event_scheduler = ON

2.eventscheduler = ON

3.event_scheduler_ON

4.events_scheduler_ON

Posted Date:-2021-07-19 04:12:24


Question:
The log in which data changes received from a replication master server are written are ____

1.error log

2.general query log

3.binary log

4.relay log

Posted Date:-2021-07-19 04:12:24


Question:
The max_binlog_cache_size system variable has default size _____

1.1 GB

2.2 GB

3.4 GB

4.8 GB

Posted Date:-2021-07-19 04:12:24


Question:
The module that links DBI to the web is ________

1.CGI.pn

2.CGI.pem

3.CGI.pm

4.CGI.po

Posted Date:-2021-07-19 04:12:24


Question:
The number of values that can be returned from a given stored function is ______________

1.0

2.1

3.2

4.3

Posted Date:-2021-07-19 04:12:24


Question:
The numbers that are prefixed with ‘0x’ are in base ______

1.8

2.16

3.32

4.64

Posted Date:-2021-07-19 04:12:24


Question:
The output from PHP is __________

1.statically generated

2.dynamically generated

3.not generated

4.no output

Posted Date:-2021-07-19 04:12:24


Question:
The return value from operations returning a row count is ______

1.$rc

2.$rv

3.$rows

4.$ary

Posted Date:-2021-07-19 04:12:24


Question:
The statement used to create a trigger is ______________

1.CREATE TRIGGER

2.CREATE TRIGGERS

3.PRODUCE TRIGGER

4.PRODUCE TRIGGERS

Posted Date:-2021-07-19 04:12:24


Question:
The system variable controls the size of the table cache _______

1.table_cache

2.cache_table

3.open_cache

4.cache_open

Posted Date:-2021-07-19 04:12:24


Question:
The tool for copying databases is _______

1.mysql

2.mysqlcheck

3.mysqlhotcopy

4.mysqlisamchk

Posted Date:-2021-07-19 04:12:24


Question:
What does ‘abc’ || ‘xyz’ result in if the PIPES_AS_CONCAT is disabled?

1.1

2.0

3.error

4.-1

Posted Date:-2021-07-19 04:12:24


Question:
What does the expression ’12 DIV 5′ evaluate to?

1.2.4

2.2

3.error

4.0

Posted Date:-2021-07-19 04:12:24


Question:
What is defined to execute when the table is modified only?

1.Stored functions

2.Stored procedures

3.Triggers

4.Events

Posted Date:-2021-07-19 04:12:24


Question:
What is the creation of a stored program similar to?

1.Trigger

2.Event

3.View

4.Table

Posted Date:-2021-07-19 04:12:24


Question:
What is the datatype for single precision floating point number?

1.FLOAT

2.DOUBLE

3.INT

4.BIGINT

Posted Date:-2021-07-19 04:12:24


Question:
What is the escape sequence for carriage return?

1.‘c’

2.‘ ’

3.‘’

4.‘z’

Posted Date:-2021-07-19 04:12:24


Question:
What is the maximum number of indexes on MyISAM table?

1.0

2.1

3.2

4.more than 1

Posted Date:-2021-07-19 04:12:24


Question:
What is used to perform an analysis of key values by the server?

1.ANALYZE KEYS

2.ANALYZE TABLE

3.PERFORM ANALYSIS

4.PERFORM TABLE ANALYSIS

Posted Date:-2021-07-19 04:12:24


Question:
What returns a result to the client?

1.Stored functions

2.Stored procedures

3.Triggers

4.Events

Posted Date:-2021-07-19 04:12:24


Question:
When the security context enables carefully written stored programs to be set up that provide controlled access to tables for users, it is called __________

1.bad

2.good

3.illegal

4.fare

Posted Date:-2021-07-19 04:12:24


Question:
Which line is written at the top of the script to write a Perl script using CGI.pm?

1.use this CGI

2.put CGI

3.use CGI

4.include CGI

Posted Date:-2021-07-19 04:12:24


Question:
Which mode of search is the search string parsed into words and the search looks for rows?

1.Boolean mode

2.Natural language

3.Query expansion

4.Cross mode

Posted Date:-2021-07-19 04:12:24


Question:
Which of these exports table definitions and contents?

1.mysqldump

2.mysqladmin

3.mysqlimport

4.mysqlexport

Posted Date:-2021-07-19 04:12:24


Question:
Which of these is the metadata log?

1.error log

2.ddl log

3.binary log

4.relay log

Posted Date:-2021-07-19 04:12:24


Question:
Which statement is used to check how MySQL would execute a SELECT query?

1.TELL

2.SHOW

3.DISPLAY

4.EXPLAIN

Posted Date:-2021-07-19 04:12:24


Question:
Which statement is used to produce a stored function?

1.PRODUCE FUNCTION

2.CREATE FUNCTION

3.PRODUCE PROCEDURE

4.CREATE PROCEDURE

Posted Date:-2021-07-19 04:12:24


Question:
Without LOCAL, LOAD DATA is ____

1.less efficient

2.more efficient

3.same speed

4.arbitrary

Posted Date:-2021-07-19 04:12:24


More MCQS

  1. SQL MCQ SET 1
  2. SQL MCQ SET 2
  3. SQL MCQ SET 3
  4. SQL MCQ SET 4
  5. SQL MCQ SET 5
  6. SQL MCQ SET 6
  7. SQL MCQ SET 7
  8. SQL MCQ SET 8
  9. SQL MCQ SET 9
  10. SQL MCQ SET 10
  11. SQL MCQ SET 11
  12. SQL MCQ SET 12
  13. SQL MCQ SET 13
  14. SQL MCQ SET 14
  15. SQL MCQ SET 15
  16. SQL MCQ SET 16
  17. SQL MCQ SET 17
  18. SQL MCQ SET 18
  19. MCQ | SQL Basics
  20. MCQ | SQL Data Types
  21. SQL Server DBA Multiple Choice Questions
Search
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!