MySQL

Question: Is the following query valid?
Create table foo (id int primary key auto_increment, name varchar);
A
Yes

B
No

Note: Not available
1. Report
Question: Which of the following are PHP file upload related functions?

A
upload_file()

B
is_uploaded_file()

C
move_uploaded_file()

D
None of the above

Note: Not available
1. Report
Question: You need to keep an eye on the existing number of objects of a given class without introducing a non-class member variable. Which of the following makes this happen?
A
Add a member varible that gets incremented in the default constructor and decremented in the destructor

B
Add a local variable that gets incremented in each constructor and decremented in the destructor

C
Add a static member variable that gets incremented in each constructor and decremented in the destructor

D
This connot be accoplished since the creation of objects is being done dynamically via"new."

Note: Not available
1. Report
Question: Default user in MySQL server is root.
A
True

B
False

Note: Not available
1. Report
Question: What does SQL stand for?
A
Structured Query Language

B
Structured Question Language

C
Strong Question Language

Note: Not available
1. Report
Question: Which SQL statement is used to update data in a database?
A
MODIFY

B
SAVE AS

C
UPDATE

D
SAVE

Note: Not available
1. Report
Question: Which SQL statement is used to delete data from a database?
A
DELETE

B
REMOVE

C
COLLAPSE

Note: Not available
1. Report
Question: Can I define multiple unique constraints on a table?
A
Yes

B
No

Note: Not available
1. Report
Question: How do I find out all databases starting with ‘test to which I have access to?
A
SHOW DATABASES LIKE ‘%test%’;

B
SHOW DATABASES LIKE ‘%test;

C
SHOW DATABASES LIKE ‘'test'%’;

D
SHOW DATABASES LIKE ‘test%’;

Note: Not available
1. Report
Question: An outer join requires each record in the two joined tables to have a matching record.
A
True

B
False

Note: Not available
1. Report

First Prev 11 12 13 14 15 Next Last

Question: Is the following query valid?
Create table foo (id int primary key auto_increment, name varchar);

Question: Which of the following are PHP file upload related functions?

Question: You need to keep an eye on the existing number of objects of a given class without introducing a non-class member variable. Which of the following makes this happen?

Question: Default user in MySQL server is root.

Question: What does SQL stand for?

Question: Which SQL statement is used to update data in a database?

Question: Which SQL statement is used to delete data from a database?

Question: Can I define multiple unique constraints on a table?

Question: How do I find out all databases starting with ‘test to which I have access to?

Question: An outer join requires each record in the two joined tables to have a matching record.

Question: Is the following query valid?Create table foo (id int primary key auto_increment, name varchar);

Question: Which of the following are PHP file upload related functions?

Question: You need to keep an eye on the existing number of objects of a given class without introducing a non-class member variable. Which of the following makes this happen?

Question: Default user in MySQL server is root.

Question: What does SQL stand for?

Question: Which SQL statement is used to update data in a database?

Question: Which SQL statement is used to delete data from a database?

Question: Can I define multiple unique constraints on a table?

Question: How do I find out all databases starting with ‘test to which I have access to?

Question: An outer join requires each record in the two joined tables to have a matching record.

Question: Is the following query valid?
Create table foo (id int primary key auto_increment, name varchar);