|
Question
|
Option1
|
Option2
|
Option3
|
Option4
|
Option5
|
Answer
|
|
|
Where is metadata stored in MySQL?
|
In the MySQL database metadata
|
In the MySQL database metasql
|
In the MySQL database mysql
|
None of the above is correct.
|
|
C
|
Edit |
Details |
Delete
|
|
________ is an open source DBMS product that runs on UNIX, Linux and Windows.
|
MySQL
|
JSP/SQL
|
JDBC/SQL
|
Sun ACCESS
|
|
A
|
Edit |
Details |
Delete
|
|
What MySQL property is used to create a surrogate key in MySQL?
|
UNIQUE
|
SEQUENCE
|
AUTO_INCREMENT
|
None of the above -- Surrogate keys are not implemented in MySQL.
|
|
C
|
Edit |
Details |
Delete
|
|
Row is synonymous with the term:
|
record.
|
relation.
|
column.
|
field.
|
|
A
|
Edit |
Details |
Delete
|
|
MySQL is
|
A Programming language
|
A Scripting language
|
A technique for writing reliable programs
|
A Relational Database Management System
|
|
D
|
Edit |
Details |
Delete
|
|
Which one will delete the table data as well as table structure?
|
TRUNCATE
|
DROP
|
|
|
|
B
|
Edit |
Details |
Delete
|
|
The main MySQL program that does all the data handling is called?
|
mysql.exe
|
mysql
|
mysqld
|
httpd
|
|
C
|
Edit |
Details |
Delete
|
|
MySQL supports the complete SQL99 standard
|
true
|
false
|
|
|
|
B
|
Edit |
Details |
Delete
|
|
Which of the following is not a valid aggregate function?
|
COUNT
|
MIN
|
MAX
|
COMPUTE
|
|
D
|
Edit |
Details |
Delete
|
|
The result of a SELECT statement can contain duplicate rows.
|
False
|
True
|
None of the above
|
|
|
B
|
Edit |
Details |
Delete
|
|
_________ data type can store unstructured data
|
RAW
|
CHAR
|
NUMERIC
|
VARCHAR
|
|
A
|
Edit |
Details |
Delete
|
|
A table joined with itself is called
|
Join
|
Self Join
|
Outer Join
|
Equi Join
|
|
B
|
Edit |
Details |
Delete
|
|
The ______ operator is used to compare a value to a list of literals values that have been
|
BETWEEN
|
ANY
|
IN
|
ALL
|
Nono
|
C
|
Edit |
Details |
Delete
|
|
Hierarchical model is also known
|
Tree structure
|
Plex Structure
|
Normalize Structure
|
Table Structure
|
|
A
|
Edit |
Details |
Delete
|
|
A primary key is combined with a foreign key creates
|
Parent-Child relation ship between the tables that connect them.
|
Many to many relationship between the tables that connect them.
|
Network model between the tables that connect them.
|
None of the above.
|
|
A
|
Edit |
Details |
Delete
|
|
ODBC stands for
|
Object Database Connectivity.
|
Oral Database Connectivity.
|
Oracle Database Connectivity.
|
Open Database Connectivity.
|
|
D
|
Edit |
Details |
Delete
|
|
RDBMS terminology for a row is
|
tuple
|
relation.
|
degree.
|
attribute
|
|
A
|
Edit |
Details |
Delete
|
|
Which of the following operations need the participating relations to be union compatible?
|
UNION
|
INTERSECTION
|
DIFFERENCE
|
All of the above
|
|
D
|
Edit |
Details |
Delete
|
|
The full form of DML is
|
Dynamic Data Language
|
Detailed Data Language
|
Data Definition Language
|
Data Manipulation Language
|
|
D
|
Edit |
Details |
Delete
|
|
NULL is
|
the same as 0 for integer
|
the same as blank for character
|
the same as 0 for integer and blank for character DC10 DATABASEMANAGEMENT SYSTEMS
|
not a value
|
|
D
|
Edit |
Details |
Delete
|