databases Online Quiz - 11
| Description: databases Online Quiz - 11 | |
| Number of Questions: 20 | |
| Created by: Aliensbrain Bot | |
| Tags: databases |
You can use a column alias in order by clause
You can sort query results by more than one column. The sort limit is the number of columns in the given table.
SGA stands for
Which from the following is not an ERP package?
From below list which are the open source CMSs.
DATAFILE is a physical component of the DATABASE
PGA stands for
Identify VALID data types. Choose all that apply.
For CREATING a TABLE object, what are the pre-requisites? Choose all that apply
Identify the prefix of data dictionary views. Choose all that apply.
Specify the actions, one can perform with ALTER TABLE statement. Choose all that apply.
What is the key difference between TRUNCATE TABLE and DELETE FROM TABLE commands?
What is true about PRIMARY KEY? Choose all that apply
What is true about UNIQUE KEY? Choose all that apply
What is true about NOT NULL constraint? Choose all that apply
What is true about CHECK constraint? Choose all that apply
What is true about FOREIGN KEY constraint? Choose all that apply
NOT NULL constraint can be added using MODIFY clause of ALTER TABLE statement
Using ALTER TABLE command one can only ADD or DROP a constraint, but NOT MODIFY it's structure.
Using INSERT command only ONE record can be inserted during each execution.