A to Z Exams

  SELECT LastName>'Hansen' AND LastName

  SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

  SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

  5

  4

  6

  2

  Using COUNT

  Using NUM

  Using NUMBER

  Both a and c above

  MySQL

  IBM DB/2

  PostgreSQL

  Microsoft SQL Server

  None of the above

  True

  Fasle

  None of the above

  True

  False

  select count(*) from table_name

  select * from table_name

  select count * from table_name

  select (count)* from table_name

  mysql.exe

  mysql

  mysqld

  httpd

  INSERT INTO Persons VALUES ('Jimmy', 'Jackson')

  INSERT ('Jimmy', 'Jackson') INTO Persons

  INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

  Your choice from Perl, PHP, Java or some other languages

  the Structured Query Language

  English

  Swedish

  MODIFY

  UPDATE

  SAVE AS

  SAVE

  REVOKE

  UNDO

  UNGRANT

  DELETE

  ROLLBACK

  False

  True

  CONCAT(  A  ,  B  )

  CONCAT  (  A  ,  B  )

  CONCAT(  "A"  ,  "B"  )

  CONCAT  (  "A"  ,  "B"  )

  True

  Fasle

  Either True or False

  None of the above

  EXTRACT FirstName FROM Persons

  SELECT FirstName FROM Persons

  SELECT Persons.FirstName

  SHOW DATABASES LIKE ‘%test%’;

  SHOW DATABASES LIKE ‘%test;

  SHOW DATABASES LIKE ‘'test'%’;

  SHOW DATABASES LIKE ‘test%’;

  True

  False

  A column defines multiple piece of data stored in all rows of the table.

  A column defines one piece of data stored in all rows of the table.

  A column defines one piece of data stored in one rows of the table.

  A column defines multiple piece of data stored in one row of the table.

  COUNT

  MIN

  MAX

  COMPUTE

  Structured Query Language

  Structured Question Language

  Strong Question Language

  None of the above

  Multiple-master replication

  Master to slave replication

  Single file based clustering

  MySQL doesn't support replication

  INSERT INTO

  UPDATE

  ADD

  INSERT NEW

  True

  false

  No joing concepts in the table.

  AND

  WHERE

  HAVING

  FROM

  Between..and..,

  Like,

  IN,

  Is NULL

  A row is a unit of data with related data items stored as one item in multiple columns in a table

  A row is a unit of data with related data items stored as multiple item in one column in a table

  A row is a unit of data with related data items stored as one item in two columns in a table

  A row is a unit of data with related data items stored as one item in one column in a table

  blob

  text

  nchar binary

  char binary

  Table

  Column

  Database

  All of above

  "show create table table_name";

  "show insert table table_name";

  "select table table_name";

  "show update table table_name";

  True

  False

  SELECT DISTINCT

  SELECT UNIQUE

  SELECT DIFFERENT

  SELECT DIFF

  SELECT * FROM Persons

  SELECT Persons

  SELECT [all] FROM Persons

  SELECT *.Persons

  There isn't a program just called mysql

  A wrapper through which Java clients must connect to the databases

  A client program that lets you send SQL commands to the database engine

  The database engine

  A program that starts up and shuts down the database engine

  If you use it for longer than 30 days

  You use MySQL in a live application and not just for evaluation

  You incorporate it into a product that you sell

  You use it on a publicly accessible site

  You are never required to buy a license

  getTime()

  Time()

  NOW()

  SELECT COLUMNS() FROM Persons

  SELECT COUNT(*) FROM Persons

  SELECT COLUMNS(*) FROM Persons

  SELECT COUNT() FROM Persons

  Dymanic

  Real

  Virtual

  Static

  DROP TABLE

  DELETE TABLE

  TRUNCATE TABLE

  REMOVE TABLE

  UNIQUE

  SEQUENCE

  AUTO_INCREMENT

  None of the above

  55

  72

  64

  40

  Only SHOW FIELDS FROM can take a LIKE clause

  Nothing - they're the same thing

  Only DESCRIBE can take a LIKE clause

  DROP TABLE XXX

  DROP XXX WHERE confirm = "YES"

  DELETE XXX WHERE confirm = "YES"

  DROP XXX

  UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

  UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

  MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen

  MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

  CREATE ?I student

  CREATE DATABASE student

  DATABASE /student

  DATABSE student

  To limit the output of a query

  To limit the output of a query using an aggregate function only

  When GROUP by is used

  both b and c above

  A Programming language

  A Programming language

  A technique for writing reliable programs

  A Relational Database Management System

  True

  False

  false

  true

  +-|

  +-*

  +-/

  +-}

  CREATE TRIGGER

  CREATE SCHEMA

  CREATE FAIRYLIGHTS

  CREATE DATABASE

  CREATE VIEW

  True

  False

  Undetermined

  Depend

  select now()

  SELECT now();

  SELECT now()

  None of these

  Edgar Codd

  Xigang Koi

  Robert Langton

  Mahatma Coate

  William Crawford

  SELECT * FROM Persons WHERE FirstName'Aru' AND LastName'Sum'

  SELECT * FROM Persons WHERE FirstName='Aru' AND LastName='Sum'

  SELECT FirstName='Aru', LastName='Sum' FROM Persons

  None of the above

  Rectangle

  Square

  Sphere

  None of these

  Foreign key not defined

  Table is empty

  Connectivity issue

  Data is present in the other table

  C only

  Java only

  Java and C

  Perl, PHP and C

  Username

  Password

  Only Username

  Both a) and b)

  .ism

  .myd

  .my

  .mys

  Linux and Mac OS-X only

  Any operating system at all

  Unix, Linux, Windows and others

  Unix and Linux only

  In the MySQL database metadata

  In the MySQL database metasql

  In the MySQL database mysql

  None of the above is correct.

  EXPLICIT

  IMPLICIT

  EXCLUSIVE

  Shared

  READ ONLY

  SELECT * FROM Persons WHERE FirstName='%a%'

  SELECT * FROM Persons WHERE FirstName LIKE '%a'

  SELECT * FROM Persons WHERE FirstName='a'

  SELECT * FROM Persons WHERE FirstName LIKE 'a%'

  SELECT * FROM Persons WHERE FirstName='a'"

  Data Definition Language

  Data Degenerated Language

  Data Delivered Language

  Defined Definition Language

  Can reset passwords for any mysql user account

  Perform certain "admin type" operations such as flush table and logs from memory to disc, but can't normally do anything "dangerous"

  Can repopulate the databases and tables from a backup

  Can restart the MySQL daemon in addition to any other priveliges he might also have

  exit

  exit;

  exit()

  exit();

  MySQL

  JSP/SQL

  JDBC/SQL

  Sun ACCESS

  Is used to load code from another file

  Has been deprecated and should be avoided for security reasons

  Is a pseudonym for the SELECT command

  Should be used to choose the database you want to use once you've connected to MySQL

  mysql_drop_database

  mysql_drop_entiredb

  mysql_drop_db

  mysql_drop_dbase

  No

  Yes

  The contents of OTHERTABLE will be deleted

  The contents of both OTHERTABLE and MYTABLE will be deleted

  The contents of OTHERTABLE will be deleted, as will be all the contents of MYTAB whoID is 1

  The database will remain unchanged to all users except the one that executes these queries.

  The database will remain unchanged

  Ascending

  Descending

  Used to uniquely identify a row

  Alias for primary key

  Used to identify a column

  Alias for foreign key

  concat

  substr

  instr

  coalesce

  AVG

  SUM

  MIN

  MAX

  CURRENT_DATE

  exit;

  quit;

  both a) and b)

  only a)

  A table is a data storage structure with rows .

  A table is a data storage structure with columns.

  A table is a data storage structure with rows and columns.

  None

  True

  False

  INSERT INTO Persons (LastName) VALUES ('Olsen')

  INSERT ('Olsen') INTO Persons (LastName)

  INSERT INTO Persons ('Olsen') INTO LastName

  To

  From

  Far

  Near

  MySQL

  JSP/SQL

  JDBC/SQL

  Sun ACCESS

  DELETE FROM Persons WHERE FirstName = 'Peter'

  DELETE ROW FirstName='Peter' FROM Persons

  DELETE FirstName='Peter' FROM Persons

  /h

  /c

  /e

  None of these

  False

  True

  None of the above

  True

  False

  None

  Both

  TRUNCATE

  DROP

  COLLAPSE

  DELETE

  MODIFY

  REMOVE

  AVG

  SUM

  MIN

  MAX

  CURRENT_DATE()

  True

  False, ENUM column cannot be null

  False, its default value is the last element of the list of allowed values

  Both b and c

  255

  7

  65535

  2 (True and False)

  True

  False

  3

  2

  1

  none of the above

  LIKE ??????

  LIKE .{6} Answer 5: LIKE ^.{6}$

  LIKE ...... (that's six dots)

  LIKE ______ (that's six underscore characters)

  use mysql;

  include ("mysql.h");

  #include

  import com.mysql.*;

  SELECT * FROM Persons WHERE FirstName='Peter'

  SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'

  SELECT [all] FROM Persons WHERE FirstName='Peter'

  SELECT * FROM Persons WHERE FirstName'Peter'

  DROP

  REMOVE ROW

  DELETE

  DELETE ROW

  Michael Widenius

  Stephanie Wall

  Sigmund Velin

  Bill Joy

  UNIQUE

  SEQUENCE

  Surrogate keys are not implemented in MySQL.

  AUTO_INCREMENT

  The ID that the user logged into the server through, and priveliges set up for that account.

  MySQL login accounts, and priveliges set for each account

  The normal login security is sufficient for MySQL, and it does not have any extra controls of its own.

  A table of valid IP addresses, and priveliges set up for each IP address