of the most important features of the SCM repository TRUE FALSE 1 0 A basic

Of the most important features of the scm repository

This preview shows page 17 - 23 out of 63 pages.

of the most important features of the SCM repository. TRUE FALSE 1 A basic configuration object is a __________ created by a software engineer during some phase of the software development process. program data structure unit of information a software component all of the above 0 0 0 1 0 When software configuration management is a formal activity, the software configuration audit is conducted by the quality assurance group development team senior managers testing specialists 1 0 0 0 Question Text Choice1 Choice2 Choice3 Choice4 Choice5 Grade1 Grade2 Grade3 Grade4 Grade5
Background image
Statement 1: A subquery is also called an inner query or inner select, while the statement containing a subquery is also called an outer query or outer select. Statement 2: A subquery can be nested inside the WHERE or HAVING clause of an outer SELECT, INSERT, UPDATE, or DELETE statement, or inside another subquery. Which of the above statements are TRUE? A query is called correlated subquery when both the inner query and the outer query are interdependent. Only statement 1 Only statement 2 Both statement 1 and statement 2 None of the listed options 0 0 1 0 State whether the above statement is TRUE or FALSE. 1 0 Statement 1: If a subquery is not dependent on the outer query it is called a non-correlated subquery. Statement 2: Subqueries cannot be used with the comparison Only statement 1 Only statement 2 Both statement 1 and statement 2 None of the listed options 1 0 0 0
Background image
operators. Which of the above statements are TRUE? An index helps speed up SELECT queries and WHERE clauses, but it slows down data input, with UPDATE and INSERT statements. State whether the above statement is TRUE or FALSE. 1 0 Which of the given options are TRUE? All listed options 1 0 0 0 To remove duplicate rows from the result set of a SELECT use the following keyword: NO DUPLICATE UNIQUE None of the listed options DISTINCT 0 0 1 Which of the following can add a row to a table? 0 1 0 0 Which SQL statement is used to insert a new data in a database? INSERT INTO UPDATE ADD INSERT NEW 1 0 0 0 In a LIKE clause, you can could ask for any value ending in "qpt" by writing LIKE %qpt LIKE *ton LIKE ton$ LIKE ^.*ton$ 1 0 0 0 In a LIKE clause, you can ask for any 6 letter value by writing? LIKE ?????? LIKE .{6} Answer 5: LIKE ^.{6}$ LIKE ......(that's six dots) LIKE ______ (that's six underscore characters) 0 0 0 1 The result of a SELECT TRUE FALSE 1 0
Background image
statement can contain duplicate rows. A table may be joined to itself. 1 Which of the following is not a valid aggregate function? 0 0 0 1 What SQL clause is used to restrict the rows returned by a query? AND WHERE HAVING FROM 0 1 0 0 Primary Key does allow the Null Values. where as in Unique key doesn't accept the Null values. State whether the statement is true or false 0 1 Which of the following commands should be used to create a database named “student”? CREATE ?I student CREATE DATABASE student DATABASE /student DATABSE student 0 1 0 0 Which one will delete the table data as well as table structure? TRUNCATE DROP REMOVE DISTINCT 0 1 0 0 A SELECT command without a WHERE clause returns? All the records from a table that match the previous WHERE clause All the records from a table, or information about all the records SELECT is invalid without a WHERE clause Nothing 0 1 0 0 What does the ALTER TABLE clause do? The SQL ALTER TABLE clause is used to insert data into database table. The SQL ALTER TABLE deletes data from database table. The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints. The SQL ALTER TABLE clause is used to delete a database table 0 0 1 0 Can you use combination of GROUP BY clause,HAVING clause and WHERE clause SQL 1 0
Background image
clauses in one SQL statement? What is a primary key? 0 1 0 What is the purpose of the SQL AS clause? The AS SQL clause is used to change the name of a column in the result set or to assign a name to a derived column. 0 1 Which two are true about aggregate You can use aggregate functions in any clause of a SELECT statement. You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns. You can pass column names, expressions, constants, or functions as parameters to an aggregate function. 0 functions?(Choose two) 0 0 1 1 Which clause should you use to exclude group results? WHERE HAVING RESTRICT GROUP BY 0 1 0 0 Which of the following SQL statements is correct? SELECT CustomerName, COUNT(CustomerName) FROM Orders ORDER BY CustomerName SELECT CustomerName, COUNT(CustomerName) FROM Orders SELECT CustomerName, COUNT(CustomerName) FROM Orders GROUP BY CustomerName 0 0 1 The SQL DROP TABLE clause is create a new table in the database delete a table from the database modify an existing table in a database 0 1 0
Background image
used to... We refer to a join as a self-join when? we are joining table to itself we are using left and right join together we are joining more than 2 tables 1 0 The INNER JOIN clause…returns all rows from 2 tables returns all rows that have matching value in the field on which the 2 tables are joined. returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined. 0 1 If table A have 10 0 0
Background image
Image of page 23

You've reached the end of your free preview.

Want to read all 63 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture