Home⇒ Computer Engineering⇒ Oracle sql and pl sql
| 1-Dont try to cram or spend more time here just read it fast and cover syllabus then practice MCQ's cheptor of same topic to check your progress. . |
| 2-Wrong options are also given but dont concentrate there, Right answer is in bold format. |
| Q1 ⇒ What type of join is needed when you wish to include rows that do not have matching values? Outer join [other wrong options] [Discuss in forum] |
| Q2 ⇒ The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID Equi-join [other wrong options] [Discuss in forum] |
| Q3 ⇒ A ________ is a stored program that is attached to a table or a view. trigger [other wrong options] [Discuss in forum] |
| Q4 ⇒ When using the SQL INSERT statement: rows can either be inserted into a table one at a time or in groups. [other wrong options] [Discuss in forum] |
| Q5 ⇒ What SQL structure is used to limit column values of a table? The CHECK constraint [other wrong options] [Discuss in forum] |
| Q6 ⇒ Which type of SQL Server cursor concurrency places an update lock on a row when the row is read? READCOMMITTED [other wrong options] [Discuss in forum] |
| Q7 ⇒ Which of the following is true concerning systems information in an RDBMS? All of the above. [other wrong options] [Discuss in forum] |
| Q8 ⇒ With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data. Nonclustered [other wrong options] [Discuss in forum] |
| Q9 ⇒ The SQL command to create a table is: CREATE TABLE. [other wrong options] [Discuss in forum] |
| Q10 ⇒ Which of the following is the original purpose of SQL? All of the above. [other wrong options] [Discuss in forum] |
| Q11 ⇒ What is an SQL virtual table that is constructed from other tables? A view [other wrong options] [Discuss in forum] |
| Q12 ⇒ A subquery in an SQL SELECT statement is enclosed in: parenthesis -- (...) . [other wrong options] [Discuss in forum] |
| Q13 ⇒ The SQL ALTER statement can be used to: change the table structure. [other wrong options] [Discuss in forum] |
| Q14 ⇒ SQL query and modification commands make up a(n) ________ . XML [other wrong options] [Discuss in forum] |
| Q15 ⇒ SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n): INSTEAD OF trigger. [other wrong options] [Discuss in forum] |
| Q16 ⇒ To sort the results of a query use: ORDER BY. [other wrong options] [Discuss in forum] |
| Q17 ⇒ In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup? Differential backup [other wrong options] [Discuss in forum] |
| Q18 ⇒ Where is metadata stored in MySQL? In the MySQL database [other wrong options] [Discuss in forum] |
| Q19 ⇒ The SQL WHERE clause: limits the row data are returned. [other wrong options] [Discuss in forum] |
| Q20 ⇒ Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine? All of Type 1, Type 2, Type 3 and Type 4 [other wrong options] [Discuss in forum] |
| Or |