13004259
Descripción
Test por Faheem Ahmed, actualizado hace más de 1 año
|
Creado por Faheem Ahmed
hace más de 6 años
|
|
Pregunta 1
Pregunta
What is output by the SQL below?
DROP TABLE IF EXISTS foo;
CREATE TABLE foo (a INT, b INT, c INT);
INSERT INTO foo VALUES (1,2,3);
INSERT INTO foo SELECT * FROM foo;
INSERT INTO foo SELECT * FROM foo;
SELECT sum(b) FROM foo;
Respuesta
-
1
-
2
-
4
-
8
-
16
Pregunta 2
Pregunta
The relationship between DEPARTMENT and EMPLOYEE is a
Respuesta
-
One-to-one relationship
-
One-to-many relationship
-
Many-to-many relationship
-
Many-to-one relationship
-
None of the above
Pregunta 3
Pregunta
Which of the following terms does refer to the correctness and completeness of the data in a database?
Respuesta
-
Data security
-
Data constraint
-
Data independence
-
Data model
-
Data integrity
Pregunta 4
Pregunta
Which of these field types would be best to hold a .jpg image?
Respuesta
-
char binary
-
nchar binary
-
text
-
blob
Pregunta 5
Pregunta
The result of a SQL SELECT statement is a(n) ________ .
Respuesta
-
report
-
form
-
file
-
table
Pregunta 6
Pregunta
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Respuesta
-
ONLY
-
UNIQUE
-
DISTINCT
-
SINGLE
Pregunta 7
Pregunta
What’s the default port for MySQL Server?
Respuesta
-
8080
-
3306
-
3000
-
2308
Pregunta 8
Pregunta
What is an index?
Respuesta
-
An index is a special way to join 2 or more tables.
-
An index is a database table attribute, which speeds-up data search within a table.
-
An index is the same as alias.
-
No such thing in MySQL
Pregunta 9
Pregunta
What is a view?
Respuesta
-
A view is a virtual table which results of executing a pre-compiled query.
-
A view is a special stored procedure executed when certain event occurs.
-
A view is a database diagram.
Pregunta 10
Pregunta
The difference between the DELETE and TRUNCATE SQL clauses is:
Respuesta
-
The DELETE clause deletes all rows in a database table, while the TRUNCATE clause can have a WHERE condition and might or might not delete all rows in a table.
-
The TRUNCATE clause deletes all rows in a database table, while the DELETE clause can have a WHERE condition and might or might not delete all rows in a table.
-
The TRUNCATE clause is identical to the DELETE clause
Pregunta 11
Pregunta
Which of the following statements gets the total value of the column 'Price' in the 'Sales' table?
Respuesta
-
SELECT ADD(Price) FROM Sales
-
SELECT SUM(Price) WHERE Sales
-
SELECT TOTAL(Price) FROM Sales
-
SELECT SUM(Price) FROM Sales
Pregunta 12
Pregunta
A trigger belongs to...
Respuesta
-
to all tables in the database
-
a single table in the database
-
more than one table in the database
Pregunta 13
Pregunta
A collection of related fields is called a:
Respuesta
-
database
-
file
-
record
-
relation
-
table
Pregunta 14
Pregunta
Also known as online, this type of processing occurs at the same time as the transaction occurs.
Respuesta
-
direct
-
immediate
-
method
-
real-time
Pregunta 15
Pregunta
Which of the following is correct:
Respuesta
-
a SQL query automatically eliminates duplicates.
-
SQL permits attribute names to be repeated in the same relation.
-
a SQL query will not work if there are no indexes on the relations
-
None of these
Pregunta 16
Pregunta
The language used in application programs to request data from the DBMS is referred to as the
Respuesta
-
DML
-
DDL
-
DCL
-
SDL
Pregunta 17
Pregunta
To delete a particular column in a relation the command used is:
Respuesta
-
UPDATE TABLE
-
TRUNCATE COLUMN
-
ALTER, DROP
-
DELETE COLUMN
Pregunta 18
Pregunta
_________ is a virtual table that draws its data from the result of an SQL SELECT statement.
Respuesta
-
View
-
Synonym
-
Sequence
-
Transaction
Pregunta 19
Pregunta
A relational database contains two tables student and department.
Student table has columns (roll_no, name and dept_id )and Department table has columns (dept-id and dept-name).
Department table has 3 records and Student table has 2 records.
How many rows and columns will be retrived by the following SQL, statement?
Select * from student, department;
Respuesta
-
0 row and 4 columns
-
3 rows and 4 columns
-
3 rows and 5 columns
-
6 rows and 5 columns
Pregunta 20
Pregunta
E-R model uses this symbol to represent weak entity set ?
Respuesta
-
Dotted rectangle
-
Diamond
-
Doubly outlined rectangle
-
None of these
Pregunta 21
Pregunta
Relational Algebra is
Respuesta
-
Data Definition Language
-
Meta Language
-
Procedural query Language
-
None of the above
Pregunta 22
Pregunta
Key to represent relationship between tables is called
Respuesta
-
Primary key
-
Secondary key
-
Foreign key
-
None of these
Pregunta 23
Pregunta
The conceptual model is
Respuesta
-
Dependent on hardware
-
Dependent on software
-
Dependent on both hardware and software
-
Independent of both hardware and software
Pregunta 24
Pregunta
The RDBMS terminology for a row is
Respuesta
-
Tuple
-
Relation
-
Attribute
-
Degree
Pregunta 25
Pregunta
A set of possible data values is called
Respuesta
-
Attribute
-
Degree
-
Tuple
-
Domain
Pregunta 26
Pregunta
In E-R Diagram derived attribute are represented by
Respuesta
-
Ellipse
-
Dashed ellipse
-
Rectangle
-
Triangle
Pregunta 27
Pregunta
The default parameter type in stored procedures is
Respuesta
-
IN
-
OUT
-
INOUT
-
There is no default type
Pregunta 28
Pregunta
Consider a table OLD with few rows. The statement CREATE TABLE new AS SELECT * FROM OLD WHERE 1=2
Respuesta
-
copies all the rows from OLD to NEW
-
creates a dummy NEW table
-
creates an empty NEW table with column definitions same as OLD
-
creates a table NEW that acts as a synonym for OLD
Pregunta 29
Pregunta
Choose the correct pattern Matching sign for matching a single character
Respuesta
-
_
-
?
-
*
-
%
Pregunta 30
Pregunta
Rollback and Commit affect
Respuesta
-
Only DML statements
-
Only DDL statements
-
Both DML and DDL
-
All statements
Pregunta 31
Pregunta
What is the order of execution of SQL clauses
1. having 2. group by 3. where 4. orderby
Respuesta
-
1 2 3 4
-
3 2 1 4
-
2 3 4 1
-
4 3 1 2
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.