Is there any error in the following MySQL command?
SELECT emp_id, title, start_date, fname, fed_id
FROM person
ORDER BY 2, 5;A. Yes
B. No
C. Depends
D. None of the mentioned
Select an option to see the answer and solution.
The function that returns reference to hash of row values is . . . . . . . .
A. fetchrow_array()
B. fetchrow_arrayref()
C. fetch()
D. fetchrow_hashref()
Select an option to see the answer and solution.
Which datatype is used for a fixed length binary string?
A. VARCHAR
B. BINARY
C. VARBINARY
D. BLOB
Select an option to see the answer and solution.
Post MySQL 6.0, utf8 was . . . . . . . .
A. 3 bytes
B. 4 bytes
C. 5 bytes
D. 6 bytes
Select an option to see the answer and solution.
Is the following MySQL statement belongs to the "Equality condition"?
SELECT product_type.name, product.name
FROM product_type INNER JOIN Product
ON product_type.dept=Product.dept
WHERE product_type.name=’customers_accounts’;A. Yes
B. No
C. Depends
D. None of the mentioned
Select an option to see the answer and solution.
What will be the result of the following MySQL command?
WHERE TITLE= ‘teller’ AND start_date < ’2007-01-01’A. Only tellers who began working for the bank prior to 2007 will be included
B. Any employee who is either not a teller or began working for the bank in 2007 or later will be removed from consideration
C. Only tellers who began working for the bank prior to 2007 will not be included
D. None of the mentioned
Select an option to see the answer and solution.
Which of the following WHERE clauses are faster?
1. WHERE col * 3 < 9
2. WHERE col < 9 / 3A. 1
B. 2
C. same speed
D. dependent on operating system
Select an option to see the answer and solution.
What allows nesting one select statement into another?
A. nesting
B. binding
C. subquerying
D. encapsulating
Select an option to see the answer and solution.
What will be the output of the following MySQL statement?
SELECT emp_id, fname, lname
FROM employee
WHERE LEFT (lname, 1) =’F’;A. Only those employees are selected whose last name started with 'F'
B. Only those employees are selected whose last name started with other than 'F'
C. All of the mentioned
D. None of the mentioned
Select an option to see the answer and solution.
Which function returns an array of row values?
A. fetchrow_array()
B. fetchrow_arrayref()
C. fetch()
D. fetchrow_hashref()
Select an option to see the answer and solution.
The static C library client in Windows is . . . . . . . .
A. mysqlclient.lib
B. mysqlclient.lb
C. mysqlclient.lm
D. myclient.lib
Select an option to see the answer and solution.
What is abc in the following MySQL statement?
CREATE VIEW xyz (abc) AS SELECT a FROM t;A. row name
B. column name
C. view
D. database
Select an option to see the answer and solution.
Which table is used to run a UNION-type query on MyISAM tables?
A. TRADITIONAL
B. MERGE
C. SERVELET
D. UNITE
Select an option to see the answer and solution.
Which mode of search is the search string parsed into words and the search looks for rows?
A. Boolean mode
B. Natural language
C. Query expansion
D. Cross mode
Select an option to see the answer and solution.
What will be the output of the following MySQL statement?
SELECT *
FROM employee
WHERE lname LIKE %bas% OR fname LIKE %bbs%;A. All employees whose last name should contain substring "bas"
B. All employees whose first name should contain substring "bbs"
C. All employees whose last name should contain substring "bas" or first name should contain substring "bbs"
D. None of the mentioned
Select an option to see the answer and solution.
The basic operation of PHP is to interpret a script.
Select an option to see the answer and solution.
The data directory subdirectory that corresponds to the nbdinfo database is . . . . . . . .
A. mysql
B. performance_schema
C. sys
D. nbdinfo
Select an option to see the answer and solution.
mysql_next_result() returns a status.
Select an option to see the answer and solution.
Which of the following is case sensitive in MySQL?
A. Event names
B. Logfile group names
C. Column names
D. Indexes
Select an option to see the answer and solution.
Which is the log in which data changes received from a replication master server are written?
A. error log
B. general query log
C. binary log
D. relay log
Select an option to see the answer and solution.
