PHP Advanced Concepts, PHP

PHP Advanced Concepts

Question: A ______ ______ is a set of SQL statements that is stored in the database and made avaliable in the same manner as SQL functions such as min() and rand().
A
stored

B
procedure

Note: Not available
1. Report
Question: Subqueries are made avaliable since MySQL varsion 5.
A
True

B
False

Note: Not available
1. Report
Question: OLTP stands for ______.
A
Online Transaction Processing

Note: Not available
1. Report
Question: ______ is a MySQL configuration file.
A
my.ini

Note: Not available
1. Report
Question: my-large.cnf is a one of MySQL Configuration Template.
A
True

B
False

Note: Not available
1. Report
Question: To logging Queries we can initiate logging with the _____ option.
A
\T,tee

Note: Not available
1. Report
Question: To display query results vertically we use ______ option in MySQL.
A
\G

Note: Not available
1. Report
Question: To backup all databases with data using mysqldump client, we use _____ option
A
--all-databases

Note: Not available
1. Report
Question: To create databases we use
A
mysql>CREATE DATABASE company;

B
mysql>CREATE table company;

C
mysql>CREATE databses company;

D
All

Note: Not available
1. Report
Question: The CHAR data type offer--------string representation?
A
fixed-length

B
variable-length

C
attribute-length

D
char-length

Note: Not available
1. Report

Question: A is a set of SQL statements that is stored in the database and made avaliable in the same manner as SQL functions such as min() and rand().