Description : What command is used to remove a table or index from a SQL database ?
Last Answer : DROP TABLE is used to remove a table or index from a SQL database .
Description : What is SQL Query ?
Last Answer : SQL Query is a query that uses SQL 's DDL and DML languages to find , display , print , and perform certain conditions in one or more tables in a database .
Description : What's the simplest way to create a web form that will populate a SQL database?
Last Answer : Give Forms To Go a try.
Description : Which database is the choice of yours: MYSQL vs POSTGRESQL vs SQL?
Last Answer : I think MYSQL is the best for me and I used it also it is so easy to use and very popular. I used it since January 2018, I recommend to you it to you
Description : Points to resolve corruption of SQL server database?
Last Answer : Often the corruption for the SQL server database can't be resolved. And the best thing one can do is just roll over the past backup. And by that there is going to be certain amount of the data loss. But you have to make use of that instead of losing everything.
Description : What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?
Last Answer : Procedures and Functions,Packages and Database Triggers.
Description : In SQL, which commandis used to remove a stored function from the database? . REMOVE FUNCTION B. DELETE FUNCTION C. DROP FUNCTION D. ERASE FUNCTION E. None of the above
Last Answer : DROP FUNCTION
Description : In SQL, the CREATE TABLESPACE isused A. to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace B. to createa database trigger C. to add/rename data files, to change storage D. All of theabove E. None of the above
Last Answer : to createa place in the databasefor storageof scheme objects, rollback segments, andnaming the data files to comprise the tablespace
Description : Point out the wrong statement. a) Wolf Frameworks uses a C# engine and supports both Microsoft SQL Server and MySQL database b) Applications built in Wolf are 50-percent browser-based ... and multisource overlaid content c) Google applications are cloud-based applications d) None of the mentioned
Last Answer : Applications built in Wolf are 50-percent browser-based and support mashable and multisource overlaid content
Description : In JDBC ........................ imports all Java classes concerned with database connectivity. A) javax.sql.* B) java.mysql.* C) java.sql.* D) com.*
Last Answer : C) java.sql.*
Description : …………… table store information about database or about the system. A) SQL B) Nested C) System D) None of these
Last Answer : C) System
Description : What protocol is the Active Directory database based on? a. LDAP b. TCP c. SQL d. HTTP
Last Answer : d. HTTP
Description : Consider a CUSTOMERS database table having a column CITY filled with all the names of Indian cities (in capital letters). The SQL statement that finds all cities that have GAR somewhere in its name, ... *from customers where city like %GAR%'; (D) Select *from customers where city as '%GAR';
Last Answer : Answer: C
Description : In distributed databases, location transparency allows for database users, programmers and administrators to treat the data as if it is at one location. A SQL query with location transparency needs to specify: (A) Inheritances (B) Fragments (C) Locations (D) Local formats
Last Answer : (B) Fragments
Description : Consider the following two commands C1 and C2 on the relation R from an SQL database: C1: drop table R; C2: delete from R; Which of the following statements is TRUE? I. Both C1 and C2 delete the schema for R. II. C2 ... R. (A) I only (B) I and II only (C) II and III only (D) I, II and III
Last Answer : (C) II and III only
Description : Which of the following statement(s) is/are FALSE in the context of Relational DBMS ? I. Views in a database system are important because they help with access control by allowing users to see only a particular subset of the data ... (B) III and IV only (C) I, II and III only (D) II, III and IV only
Last Answer : (D) II, III and IV only
Description : Consider a database table R with attributes A and B. Which of the following SQL queries is illegal ? (A) SELECT A FROM R; (B) SELECT A, COUNT(*) FROM R; (C) SELECT A, COUNT(*) FROM R GROUP BY A; (D) SELECT A, B, COUNT(*) FROM R GROUP BY A, B;
Last Answer : (B) SELECT A, COUNT(*) FROM R;
Description : Consider the following statements regarding relational database model: (a) NULL values can be used to opt a tuple out of enforcement of a foreign key. (b) Suppose that table T has only one candidate key. If Q is in 3NF, then it is ... true. (C) (b) and (c) are true. (D) (a), (b) and (c) are true.
Last Answer : (D) (a), (b) and (c) are true.
Description : Why is database called information management system ?
Last Answer : Databases are called information management methods because the stored information can be managed.
Description : What is a database called ?
Last Answer : Database is called database.
Description : What is meant by database sorting ?
Last Answer : sorting means sorting. data sorting means sorting data. A table can have many names . If the names are arranged in a table, it can be easily found out . Records can be sorted on any one or more fields. ... is done on a field, less time is required to search the record according to that field.
Description : Why is the database changed ? Explain ?
Last Answer : Answer : The structure of the database is changed for the following reasons. 1. To change the name of the field in the table , 2. To change the data type of the field , 3. To change the size of the field , 4. To delete or delete the field , 5. Etc. to add new fields.
Description : The index file in the database is updated automatically - explain. ?
Last Answer : The data is arranged in a special order so that the user can quickly find any data from the database. Indexing is the process of arranging the records in a database table in such a logical ... to the database file, the index files are automatically updated. This does not change the original file.
Description : Why is sorting done in database ?
Last Answer : Sorting can be done very easily using Microsoft Access program. First you have to select the field on which you want to sort the table. Then select Sort from the Record menu . Click on the latest Sort Ascending or Sort Desending . The field can be sorted by Ascending or Descending order
Description : How many headings are there in each column of a database ?
Last Answer : Each column in a database has a heading.
Description : What is a database field ?
Last Answer : Database field is the title of the column.
Description : Which one is in a database ?
Last Answer : A database contains row column records.
Description : What are the keyboard commands for saving database files ?
Last Answer : The keyboard command for saving database files is Ctrl + S
Description : What is the name of the database ?
Last Answer : The database is called another DBMS .
Description : What is a corporate database ?
Last Answer : Answer : A multidimensional database management system is a multidimensional database management system created by specialized software for storing and using essential information. Example: The data ... , insurance companies , multinational companies , government agencies , NGOs and networking.
Description : What is Database Administrator ( DBA) ?
Last Answer : Answer : In DBMS , the person or organization who has the overall responsibility of database management is called Database Administrator .
Description : How to create a database program ?
Last Answer : Answer : Database programs can be created in three ways namely a) Database creation from Database Wizard . B) Create a database from the menu. C) Creating database with database language.
Description : What is Relation Database Management System ( RDBMS) ?
Last Answer : RDBMS refers to the relationship between multiple tables in a database based on a specific field (primary and foreign keys) . For example: Oracle , MySql , Ms -Sql, Microsoft Access, Microsoft Access, FoxPro , etc. Inventor : Dr. Edger Codd in 1960 .
Description : What is Database Software ?
Last Answer : Answer : Database software is the software that can be used to store any data and sort it out as needed.
Description : What is DBMS or Database Management System ?
Last Answer : DataBase Management System is the full form of DBMS . DBMS is a set of programs required for accessing , storing , controlling and managing interconnected information called database management systems.
Description : Write the name of some database software ?
Last Answer : There are many databases or database software . The most well-known and widely used database software is Oracle, MySQL , MySQL, Firrbird , MariaDB , Microsoft Access ( Microsoft Access or MS Access).
Last Answer : Database means a database where a lot of information is stored. Database software is the software that saves data and can be used as needed .
Description : How to enter data in database ?
Last Answer : How to enter data in a database depends on the software with which the database is created. For example, let's say the database is created in Microsoft Access . So the data can be entered in the ... MySQL or with a web app created with a server based programming language such as PHP or Java .
Description : How many types of database ?
Last Answer : Database two types. Namely: 1. Client Server Database Distributed Database
Description : What is Database ?
Last Answer : The word data means data and the word base means base or assembly. That is , a database is the sum of one or more interrelated data files.
Last Answer : Large companies, especially banks , insurance companies , government and non-government organizations use a kind of database software for intercommunication system. That database is called corporate database.
Description : What is Relational Database Management System ?
Last Answer : Database databases are organized in different rows, that is, files are considered only in records, but also in tables with list rows and columns. This type of database is called relational database management system.
Description : The PC productivity tool that manipulates data organized in rows and coloumn is called a a) spreadhsheet b) word processing document c) presentation mechanism d) database record manager e) None of these
Last Answer : a) spreadhsheet
Description : State which of the one is false A. In performance testing, usage of tool is a must B. In database testing, database knowledge is a must. C. In Functional Testing, knowledge of business logic is a must D. None of the above.
Last Answer : D. None of the above.
Description : The ________ is a tool for identifying ways to create more customer value. A. Value chain B. Customer survey C. Brand loyalty index D. Promotion channel E. Supplier database
Last Answer : A. Value chain
Description : Explain how procedures and functions are called in a PL/SQL block ?
Last Answer : Function is called as part of an expression. sal := calculate_sal ('a822'); procedure is called as a PL/SQL statement calculate_bonus ('A822');
Description : Python has a SQL-like querylanguage called ________- a) GQLb) PL SQL c) NOSQL d) JDBC
Last Answer : GQL
Description : I understand what the PL/SQL code below is supposed to do, but when I run the code, it won't compile. Can anybody help with why this is so?
Last Answer : answer:PL\SQL really isn’t my thing, but I believe you need something between the first IF statement and the ELSIF. What do you want it to do with the number if it is 50 or 90?
Description : Does anyone here have experience working with PL/SQL? I need some help getting started...
Last Answer : answer:PL/SQL is Oracle's take on SQL. It's mostly vanilla SQL, but with some Oracle-specific twists. You need Oracle SQL Developer or something similar. I doubt other relational ... more closely resembling a true object-oriented language, so make sure you get something Oracle-specific!.