Query Maestro - Round 1(Set 1)
.
- 1.What does SQL stand for?
- A.
Structured Question Language
- B.
Strong Question Language
- C.
Structured Query Language
- D.
String Query Language
- 2.Using which language can a user request information from a database?
- A.
Relational
- B.
Structural
- C.
Compiler
- D.
Query
- 3.-To remove a relation from an SQL database, we use the ____ command.
- A.
Delete
- B.
Remove
- C.
Drop table
- D.
Purge
- 4.Key to represent relationship between tables is called
- A.
Foreign Key
- B.
Primary Key
- C.
Super Key
- D.
Secondary key
- 5.In the ______ normal form, a composite attribute is converted to individual attributes.
- A.
First
- B.
Second
- C.
Third
- D.
Fourth
- 6.Which of the following is not Armstrong's Axiom?
- A.
Transitivity rule
- B.
Pseudotransitivity rule
- C.
Reflexive rule
- D.
Augmentation rule
- 7.An entity set that does not have sufficient attributes to form a primary key is termed as _____.
- A.
Strong entity set
- B.
Variant set
- C.
Weak entity set
- D.
Variable set
- 8.In SQL the spaces at the end of the string are removed by ______ function.
- A.
Upper
- B.
Lower
- C.
String
- D.
Trim
- 9.Student(ID, name, dept, name, tot_cred) In this query which attribute form the primary key?
- A.
Name
- B.
ID
- C.
Tot_cred
- D.
Dept
- 10.The tuples of the relations can be of ______ order.
- A.
Same
- B.
Sorted
- C.
Any
- D.
Constant
- 11.A domain is atomic if elements of the domain are considered to be ______units.
- A.
Different
- B.
Indivisible
- C.
Constant
- D.
Divisible
- 12.Course(course_id, sec_id, semester) Here the course_id, sec_id and semester are _______ and course is a______.
- A.
Relations,Attribute
- B.
Tuple,Relation
- C.
Attributes, Relation
- D.
Tuple, Attributes
- 13.Database ________ which is the logical design of the database, and the database _____which is a snapshot of the data in the database at a given instant of time.
- A.
Instance, Schema
- B.
Relation, Schema
- C.
Relation, Domain
- D.
Schema, Instance
- 14.For each attribute of a relation, there is a set of permitted values, called the _____of the attribute.
- A.
Relation
- B.
Domain
- C.
Set
- D.
Schema
- 15.A relational database consists of a collection of
- A.
Records
- B.
Tables
- C.
Fields
- D.
Keys
- 16.A ________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.
- A.
Triggers
- B.
Functions
- C.
Procedures
- D.
None of the above
- 17.The DROP TABLE statement :
- A.
Deletes the table structure only
- B.
Works whether or not referential integrity constraints would be violated
- C.
Deletes the table structure along with the table data
- D.
Is not an SQL statement
- 18.Which of the following indicates the maximum number of entities that can be involved in a relationship?
- A.
Greater Entity Count(GEC)
- B.
Minimum cardinality
- C.
ERD
- D.
Maximum cardinality
- 19.With SQL, how do you select all the columns from a table named "Persons"?
- A.
SELECT [all] FROM PERSONS
- B.
SELECT * FROM Persons
- C.
SELECT *.Persons
- D.
SELECT Persons
- 20.With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?
- A.
SELECT * FROM Persons ORDER FirstName DESC
- B.
SELECT * FROM Persons SORT 'FirstName' DESC
- C.
SELECT * FROM Persons ORDER BY FirstName DESC
- D.
SELECT * FROM Persons SORT BY 'FirstName' DESC
Questions: 30 | Attempts: 3743 | Last updated: Mar 21, 2022
-
Sample QuestionSalah satu dari lima ciri penting algoritma adalah….
Questions: 13 | Attempts: 61 | Last updated: Mar 22, 2022
-
Sample QuestionRoman number of 1 is
Questions: 101 | Attempts: 108 | Last updated: Mar 20, 2022
-
Sample QuestionWhen we look at the most common electric tools you use in the munitions storage area, when using a drill, what is the first thing you do?
Back to top