13004259
Beschreibung
Quiz von Faheem Ahmed, aktualisiert more than 1 year ago
|
Erstellt von Faheem Ahmed
vor mehr als 6 Jahre
|
|
Frage 1
Frage
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;
Antworten
-
1
-
2
-
4
-
8
-
16
Frage 2
Frage
The relationship between DEPARTMENT and EMPLOYEE is a
Antworten
-
One-to-one relationship
-
One-to-many relationship
-
Many-to-many relationship
-
Many-to-one relationship
-
None of the above
Frage 3
Frage
Which of the following terms does refer to the correctness and completeness of the data in a database?
Antworten
-
Data security
-
Data constraint
-
Data independence
-
Data model
-
Data integrity
Frage 4
Frage
Which of these field types would be best to hold a .jpg image?
Antworten
-
char binary
-
nchar binary
-
text
-
blob
Frage 5
Frage
The result of a SQL SELECT statement is a(n) ________ .
Antworten
-
report
-
form
-
file
-
table
Frage 6
Frage
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Antworten
-
ONLY
-
UNIQUE
-
DISTINCT
-
SINGLE
Frage 7
Frage
What’s the default port for MySQL Server?
Antworten
-
8080
-
3306
-
3000
-
2308
Frage 8
Frage
What is an index?
Antworten
-
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
Frage 9
Frage
What is a view?
Antworten
-
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.
Frage 10
Frage
The difference between the DELETE and TRUNCATE SQL clauses is:
Antworten
-
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
Frage 11
Frage
Which of the following statements gets the total value of the column 'Price' in the 'Sales' table?
Antworten
-
SELECT ADD(Price) FROM Sales
-
SELECT SUM(Price) WHERE Sales
-
SELECT TOTAL(Price) FROM Sales
-
SELECT SUM(Price) FROM Sales
Frage 12
Frage
A trigger belongs to...
Antworten
-
to all tables in the database
-
a single table in the database
-
more than one table in the database
Frage 13
Frage
A collection of related fields is called a:
Antworten
-
database
-
file
-
record
-
relation
-
table
Frage 14
Frage
Also known as online, this type of processing occurs at the same time as the transaction occurs.
Antworten
-
direct
-
immediate
-
method
-
real-time
Frage 15
Frage
Which of the following is correct:
Antworten
-
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
Frage 16
Frage
The language used in application programs to request data from the DBMS is referred to as the
Antworten
-
DML
-
DDL
-
DCL
-
SDL
Frage 17
Frage
To delete a particular column in a relation the command used is:
Antworten
-
UPDATE TABLE
-
TRUNCATE COLUMN
-
ALTER, DROP
-
DELETE COLUMN
Frage 18
Frage
_________ is a virtual table that draws its data from the result of an SQL SELECT statement.
Antworten
-
View
-
Synonym
-
Sequence
-
Transaction
Frage 19
Frage
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;
Antworten
-
0 row and 4 columns
-
3 rows and 4 columns
-
3 rows and 5 columns
-
6 rows and 5 columns
Frage 20
Frage
E-R model uses this symbol to represent weak entity set ?
Antworten
-
Dotted rectangle
-
Diamond
-
Doubly outlined rectangle
-
None of these
Frage 21
Frage
Relational Algebra is
Antworten
-
Data Definition Language
-
Meta Language
-
Procedural query Language
-
None of the above
Frage 22
Frage
Key to represent relationship between tables is called
Antworten
-
Primary key
-
Secondary key
-
Foreign key
-
None of these
Frage 23
Frage
The conceptual model is
Antworten
-
Dependent on hardware
-
Dependent on software
-
Dependent on both hardware and software
-
Independent of both hardware and software
Frage 24
Frage
The RDBMS terminology for a row is
Antworten
-
Tuple
-
Relation
-
Attribute
-
Degree
Frage 25
Frage
A set of possible data values is called
Antworten
-
Attribute
-
Degree
-
Tuple
-
Domain
Frage 26
Frage
In E-R Diagram derived attribute are represented by
Antworten
-
Ellipse
-
Dashed ellipse
-
Rectangle
-
Triangle
Frage 27
Frage
The default parameter type in stored procedures is
Antworten
-
IN
-
OUT
-
INOUT
-
There is no default type
Frage 28
Frage
Consider a table OLD with few rows. The statement CREATE TABLE new AS SELECT * FROM OLD WHERE 1=2
Antworten
-
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
Frage 29
Frage
Choose the correct pattern Matching sign for matching a single character
Antworten
-
_
-
?
-
*
-
%
Frage 30
Frage
Rollback and Commit affect
Antworten
-
Only DML statements
-
Only DDL statements
-
Both DML and DDL
-
All statements
Frage 31
Frage
What is the order of execution of SQL clauses
1. having 2. group by 3. where 4. orderby
Antworten
-
1 2 3 4
-
3 2 1 4
-
2 3 4 1
-
4 3 1 2
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.