SQL/SQL MCQ SET 4 Sample Test,Sample questions

Question:
A stored program associated with a schedule is _____________

1.Trigger

2.Event

3.Stored function

4.Stored procedure


Question:
By default, the AUTO_INCREMENT sequences begin at __________

1.0

2.1

3.-1

4.2


Question:
CGI stands for ________

1.Computer Gateway Interface

2.Common Gateway Interface

3.Computer Generated Interface

4.Common Generated Interface


Question:
DBI scripts are located in the directory ______________

1.cgi-inc

2.cgi-bin

3.cgi-usr

4.cgi-perl


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

1.row name

2.column name

3.table name

4.database name


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

1.Numeric

2.String

3.ENUM

4.TIME


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


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

1..

2.*

3.->

4.@


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


Question:
PHP variables are preceded by __________

1._

2.@

3.$

4.&


Question:
RTF refers to ________

1.Rich Text Format

2.Right Text Format

3.Rich Text Function

4.Right Text Function


Question:
The AUTO_INCREMENT column attribute is best used with ______________

1.FLOAT

2.INT

3.CHARACTER

4.DOUBLE


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

1.AUTO_INCREMENT

2.UNSIGNED

3.IDENTIFY

4.DESCRIBE


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

1.INT

2.FLOAT

3.DOUBLE

4.DECIMAL


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

1.INT

2.FLOAT

3.DOUBLE

4.DECIMAL


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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()


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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()


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

1.fetchrow_array()

2.fetchrow_arrayref()

3.fetch()

4.fetchrow_hashref()


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

1.INET_ATON()

2.INET_NTOA()

3.INET_ITOS()

4.INET_STOI()


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

1.INET_ATON()

2.INET_ATON()

3.INET_ITOS()

4.INET_STOI()


Question:
The hub of a MySQL installation is _______

1.mysqla

2.mysqlb

3.mysqlc

4.mysqld


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


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


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


Question:
The max_binlog_cache_size system variable has default size _____

1.1 GB

2.2 GB

3.4 GB

4.8 GB


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

1.CGI.pn

2.CGI.pem

3.CGI.pm

4.CGI.po


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

1.0

2.1

3.2

4.3


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

1.8

2.16

3.32

4.64


Question:
The output from PHP is __________

1.statically generated

2.dynamically generated

3.not generated

4.no output


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

1.$rc

2.$rv

3.$rows

4.$ary


Question:
The statement used to create a trigger is ______________

1.CREATE TRIGGER

2.CREATE TRIGGERS

3.PRODUCE TRIGGER

4.PRODUCE TRIGGERS


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

1.table_cache

2.cache_table

3.open_cache

4.cache_open


Question:
The tool for copying databases is _______

1.mysql

2.mysqlcheck

3.mysqlhotcopy

4.mysqlisamchk


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

1.1

2.0

3.error

4.-1


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

1.2.4

2.2

3.error

4.0


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

1.Stored functions

2.Stored procedures

3.Triggers

4.Events


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

1.Trigger

2.Event

3.View

4.Table


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

1.FLOAT

2.DOUBLE

3.INT

4.BIGINT


Question:
What is the escape sequence for carriage return?

1.‘c’

2.‘ ’

3.‘’

4.‘z’


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

1.0

2.1

3.2

4.more than 1


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


Question:
What returns a result to the client?

1.Stored functions

2.Stored procedures

3.Triggers

4.Events


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


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


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


Question:
Which of these exports table definitions and contents?

1.mysqldump

2.mysqladmin

3.mysqlimport

4.mysqlexport


Question:
Which of these is the metadata log?

1.error log

2.ddl log

3.binary log

4.relay log


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

1.TELL

2.SHOW

3.DISPLAY

4.EXPLAIN


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

1.PRODUCE FUNCTION

2.CREATE FUNCTION

3.PRODUCE PROCEDURE

4.CREATE PROCEDURE


Question:
Without LOCAL, LOAD DATA is ____

1.less efficient

2.more efficient

3.same speed

4.arbitrary


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!