Tag: databases
Questions Related to databases
-
Defining a clustered index on Account_ID
-
Defining a clustered index on Account_ID, Trans_Date
-
Defining a non-clustered index on Account_ID, Trans_Date
-
Don't define any indexes
-
Use UNION between the 10 SELECT statements
-
Execute separate SQL statements and let the front-end merge the results
-
Use UNION ALL between the 10 SELECT statements
-
Define a temporary table and populate it with data from the 10 SELECT statements and then do a single SELECT from this table
-
It will describe the table.
-
It will return ar error:'Table or view does not exist'
-
The query is not correct.
-
None of the above
-
Non aggregate functions only
-
Aggregate functions only
-
Both 1 & 2
-
None of the above
-
update table TABLE_NAME set COMLUMN_NAME= where
-
update TABLE_NAME set COMLUMN_NAME= where
-
Both 1 & 2 are correct
-
None of the above
-
Data Dynamic Link
-
Data Description Language
-
Data Definition Language
-
Data Definition Link