A to Z Exams

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

  INSERT ('Olsen') INTO Persons (LastName)

  INSERT INTO Persons ('Olsen') INTO LastName

  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

  DROP TABLE

  DELETE TABLE

  DEL TABLE

  REMOVE TABLE

  .ism

  .myd

  .my

  .mys

  Using COUNT

  Using NUM

  Using NUMBER

  Both a and c above

  REVOKE

  UNDO

  UNGRANT

  DELETE

  ROLLBACK

  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.

  True

  False

  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

  Yes

  No

  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

  No

  Yes

  COUNT

  MIN

  MAX

  COMPUTE

  False

  True

  None of the above

  To

  From

  Far

  Near

  True

  Fasle

  None of the above

  Add

  Insert

  Update

  Alter

  Rectangle

  Square

  Sphere

  None of these

  exit

  exit;

  exit()

  exit();

  False

  True

  In the MySQL database metadata

  In the MySQL database metasql

  In the MySQL database mysql

  None of the above is correct.

  Used to uniquely identify a row

  Alias for primary key

  Used to identify a column

  Alias for foreign key

  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

  SELECT DISTINCT

  SELECT UNIQUE

  SELECT DIFFERENT

  SELECT DIFF

  Show triggers;

  Display triggers;

  select triggers;

  view triggers;

  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

  CREATE TRIGGER

  CREATE SCHEMA

  CREATE FAIRYLIGHTS

  CREATE DATABASE

  CREATE VIEW

  /h

  /c

  /e

  None of these

  mysql.exe

  mysql

  mysqld

  httpd

  Dymanic

  Real

  Virtual

  Static

  TRUNCATE

  DROP

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

  the Structured Query Language

  English

  Swedish

  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)

  INSERT INTO

  UPDATE

  ADD

  INSERT NEW

  Between..and..,

  Like,

  IN,

  Is NULL

  MySQL

  IBM DB/2

  PostgreSQL

  Microsoft SQL Server

  None of the above

  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

  It causes the dataset returned by the query to be sorted in descending order

  It causes rows with the same ID to be sorted by NAME in ascending order

  It causes rows with the same ID to be sorted by NAME in descending order

  It causes rows to be sorted by NAME first and then by ID

  It causes the result set to include a description of the NAME field

  +-|

  +-*

  +-/

  +-}

  True

  Fasle

  Either True or False

  None of the above

  All the records from a table that match the previous WHERE clause

  All the records from a table, or information about all the records

  SELECT is invalid without a WHERE clause

  Nothing

  True

  False

  SORT

  ORDER BY

  ORDER

  SORT BY

  Temporary (Hash) Tables

  Table Joining

  Stored Procedures

  Regular Expression Matching

  4 bytes

  2 bytes

  8 bytes

  1 byte

  True

  False

  CREATE ?I student

  CREATE DATABASE student

  DATABASE /student

  DATABSE student

  MySQL

  JSP/SQL

  JDBC/SQL

  Sun ACCESS

  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'

  Foreign key not defined

  Table is empty

  Connectivity issue

  Data is present in the other table

  CONCAT(  A  ,  B  )

  CONCAT  (  A  ,  B  )

  CONCAT(  "A"  ,  "B"  )

  CONCAT  (  "A"  ,  "B"  )

  C only

  Java only

  Java and C

  Perl, PHP and C

  True

  False

  None

  Both

  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

  mysql_drop_database

  mysql_drop_entiredb

  mysql_drop_db

  mysql_drop_dbase

  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

  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 Control Language

  Data Content Language

  Data Column Language

  Defined Control Language

  MODIFY

  UPDATE

  SAVE AS

  SAVE

  select count(*) from table_name

  select * from table_name

  select count * from table_name

  select (count)* from table_name

  FETCH

  REVOKE

  LIKE

  JOIN

  True

  False

  Undetermined

  Depend

  Multiple-master replication

  Master to slave replication

  Single file based clustering

  MySQL doesn't support replication

  AVG

  SUM

  MIN

  MAX

  CURRENT_DATE

  AND

  WHERE

  HAVING

  FROM

  True

  False

  "show create table table_name";

  "show insert table table_name";

  "select table table_name";

  "show update table table_name";

  DROP TABLE XXX

  DROP XXX WHERE confirm = "YES"

  DELETE XXX WHERE confirm = "YES"

  DROP XXX

  mysqlconnect() function

  mysql-connect() function

  mysql_connect() function

  sql_connect() function

  BDB

  Isam99

  MyIsam

  Hash

  InnoDb

  Linux and Mac OS-X only

  Any operating system at all

  Unix, Linux, Windows and others

  Unix and Linux only

  NO DUPLICATE

  UNIQUE

  DISTINCT

  None of the above

  55

  72

  64

  40

  EXTRACT FirstName FROM Persons

  SELECT FirstName FROM Persons

  SELECT Persons.FirstName

  UNIQUE

  SEQUENCE

  AUTO_INCREMENT

  None of the above

  5

  4

  6

  2

  LIKE %qpt

  LIKE *ton

  LIKE ton$

  LIKE ^.*ton$

  Data Maintained Language

  Data mandatory Language

  Data manipulation Language

  Defined manipulation Language

  Michael Widenius

  Stephanie Wall

  Sigmund Velin

  Bill Joy

  255

  7

  65535

  2 (True and False)

  Data Definition Language

  Data Degenerated Language

  Data Delivered Language

  Defined Definition Language

  Edgar Codd

  Xigang Koi

  Robert Langton

  Mahatma Coate

  William Crawford

  password

  host name

  both a and b above

  database name associated with the user

  getTime()

  Time()

  NOW()

  false

  true

  concat

  substr

  instr

  coalesce

  A Programming language

  A Programming language

  A technique for writing reliable programs

  A Relational Database Management System

  UNIQUE

  SEQUENCE

  Surrogate keys are not implemented in MySQL.

  AUTO_INCREMENT

  SELECT LastName>'Hansen' AND LastName

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

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

  exit;

  quit;

  both a) and b)

  only a)

  SELECT * FROM Persons SORT BY 'FirstName' DESC

  SELECT * FROM Persons ORDER BY FirstName DESC

  SELECT * FROM Persons ORDER FirstName DESC

  SELECT * FROM Persons SORT 'FirstName' DESC

  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'

  use mysql;

  include ("mysql.h");

  #include

  import com.mysql.*;

  True

  False

  Use

  use database.name

  USE databasename;

  none of these

  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

  Structured Query Language

  Structured Question Language

  Strong Question Language

  None of the above

  True

  False

  blob

  text

  nchar binary

  char binary